CN103617284A - Data field extension method - Google Patents
Data field extension method Download PDFInfo
- Publication number
- CN103617284A CN103617284A CN201310676333.1A CN201310676333A CN103617284A CN 103617284 A CN103617284 A CN 103617284A CN 201310676333 A CN201310676333 A CN 201310676333A CN 103617284 A CN103617284 A CN 103617284A
- Authority
- CN
- China
- Prior art keywords
- data field
- database table
- attribute
- add
- extended
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/213—Schema design and management with details for schema evolution support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data database table rapid extension method. The method is characterized by including the following steps that a base class is set in project engineering, an attribute of a String type is added to the base class, the name of the attribute is defined, the attribute is used as an XML data source, and a method for processing XML data is added to the base class; a field of an XML data type is added to a database table to be extended and named, the name of the field is the same as the name of the attribute, and an extended database table is acquired; an entity class corresponding to the extended database table is added to the project engineering and inherits the base class; extended data fields are added to the entity class. The database table in which data fields need to be extended is extended in a database, the entity class mapped with the extended database table is added, the extended data fields are operated in the entity class, the database is prevented from being directly operated, and therefore safety of the database is improved.
Description
Technical field
The present invention relates to a kind of data field extended method.
Background technology
The conventional data disposal system of database Shi Yige unit or an application, what he stored is to belong to enterprise and operating divisions, the set of the relevant data of organization and individual, universal and development along with informationization technology, increasing enterprise, unit or team need the computer software complicated business datum of assisting management, several computer softwares share a database, resource in several users' while shared data banks, in database table, increase new data field, just need to repeat to revise to database table, so not only make the security performance of data in database reduce, return software developer and bring very large repeated workload and pressure, and complicated business data processing, work efficiency can not get improving, product competitiveness in the market declines.
Summary of the invention
The data field the invention solves in this factor data bank changes, the problem that causes repetition Update Table storehouse table, the present invention is under the prerequisite that Update Table storehouse is not shown, increase quickly growth data field, assist developer to shorten greatly the construction cycle of software, the working pressure and the program complexity that have reduced developer, reduced cost, improved the competitiveness of product in market.
Technical scheme provided by the invention is:
A data field extended method, comprises the following steps:
Step 1: base class is set in projects, adds the attribute of a String type in described base class, and define the title of described attribute, wherein, described attribute is as XML data source, and in base class, add the method for processing XML data;
Step 2: in database table to be expanded, add the field of an XML data type, and name, and consistent with the title of described attribute, database table is expanded;
Step 3: add the entity class corresponding with extending database table in projects, described entity class is inherited described base class;
Step 4: add growth data field in described entity class.
Preferably, in described database table extended method, process the method for described XML data in described step 1, it comprises: add, revise, delete and inquiry.
Preferably, in described data field extended method, described growth data field, it provides as follows:
Preferably, in described data field extended method, the field of described XML data type, its back end comprising is the memory location of described growth data field.
Data field extended method in the present invention, be first in database to needing the database table of growth data field to expand, then add the entity class with the mapping of extending database table, in entity class, add growth data field, and growth data field is operated, in database table, do not operate, increased the security of database, facilitate growth data field.In addition, the present invention has realized under the prerequisite that Update Table storehouse is not shown, and adds quickly growth data field, and assistance developer has shortened the construction cycle of software greatly, has reduced developer's working pressure and program complexity.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of data field extended method of the present invention.
Embodiment
Below in conjunction with accompanying drawing, the present invention is described in further detail, to make those skilled in the art can implement according to this with reference to instructions word.
As shown in Figure 1, the invention provides a kind of data field extended method, comprise the following steps:
A data field extended method, comprises the following steps:
Step 1: base class is set in projects, and adds the attribute of a String type in this base class, and define the title of this attribute, wherein, this attribute is as XML data source, and in base class, add the method for processing XML data;
Step 2: in database table to be expanded, add the field of an XML data type, and name, and consistent with the title of attribute in step 1, database table is expanded;
Step 3: add the entity class corresponding with extending database table in projects, described entity class is inherited described base class;
Step 4: in described entity class, add growth data field, wherein, and the method for processing XML data in step 1, it comprises: add, revise, delete and inquiry.
In building database, consider the expansion of data field, base class will be set in projects, add entity class, the attribute of base class is as XML data source, in growth data field, directly in database table, add XML data type field so, just can in entity class, directly to growth data field, operate.
In building database, base class is not set in projects, add entity class, so in the expansion of the data field in this database table, just need first in projects, to arrange base class, attribute and the title of definition base class, attribute is as XML data source, and in base class, add the method for processing XML data, then in database table, add the field of XML data type, and the title of database table is identical with the title of the attribute of base class, now, database table is expanded, the memory location of database table increases, in database table during growth data field, need in projects, add one with the corresponding entity class of database table after expansion, this entity class is inherited base class, and in this entity class, add growth data field, the growth data field of adding, it provides as follows:
The field of the XML data type of adding in database table to be expanded, its back end comprising is the memory location of growth data field.
Although embodiment of the present invention are open as above, but it is not restricted to listed utilization in instructions and embodiment, it can be applied to various applicable the field of the invention completely, for those skilled in the art, can easily realize other modification, therefore do not deviating under the universal that claim and equivalency range limit, the present invention is not limited to specific details and illustrates here and the legend of describing.
Claims (4)
1. a data field extended method, is characterized in that, comprises the following steps:
Step 1: base class is set in projects, adds the attribute of a String type in described base class, and define the title of described attribute, wherein, described attribute is as XML data source, and in base class, add the method for processing XML data;
Step 2: in database table to be expanded, add the field of an XML data type, and name, and consistent with the title of described attribute, database table is expanded;
Step 3: add the entity class corresponding with extending database table in projects, described entity class is inherited described base class;
Step 4: add growth data field in described entity class.
2. data field extended method as claimed in claim 1, is characterized in that, processes the method for described XML data in described step 1, and it comprises: add, revise, delete and inquiry.
3. data field extended method as claimed in claim 1, is characterized in that, described growth data field, and it provides as follows:
4. data field extended method as claimed in claim 1, is characterized in that, the field of described XML data type, and its back end comprising is the memory location of described growth data field.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310676333.1A CN103617284A (en) | 2013-12-11 | 2013-12-11 | Data field extension method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310676333.1A CN103617284A (en) | 2013-12-11 | 2013-12-11 | Data field extension method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103617284A true CN103617284A (en) | 2014-03-05 |
Family
ID=50167987
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310676333.1A Pending CN103617284A (en) | 2013-12-11 | 2013-12-11 | Data field extension method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103617284A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107943926A (en) * | 2017-11-21 | 2018-04-20 | 郑州云海信息技术有限公司 | The attribute increase method, apparatus and medium of a kind of tables of data |
| CN108073709A (en) * | 2017-12-20 | 2018-05-25 | 上海达梦数据库有限公司 | A kind of operating method of data record, device, equipment and storage medium |
| CN108959221A (en) * | 2018-06-04 | 2018-12-07 | 广州环通信息技术有限公司 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
| CN111241093A (en) * | 2019-12-31 | 2020-06-05 | 嘉兴太美医疗科技有限公司 | Dynamic storage expansion method based on database |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102200977A (en) * | 2010-03-23 | 2011-09-28 | 国际商业机器公司 | Method and system for extending database table under multi-tenant environment |
| CN102930027A (en) * | 2012-11-06 | 2013-02-13 | 苏州两江科技有限公司 | Data processing system and processing method in cloud computing multi-tenant architecture |
-
2013
- 2013-12-11 CN CN201310676333.1A patent/CN103617284A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102200977A (en) * | 2010-03-23 | 2011-09-28 | 国际商业机器公司 | Method and system for extending database table under multi-tenant environment |
| US20110238709A1 (en) * | 2010-03-23 | 2011-09-29 | International Business Machines Corporation | Extending database tables in a multi-tenant environment |
| CN102930027A (en) * | 2012-11-06 | 2013-02-13 | 苏州两江科技有限公司 | Data processing system and processing method in cloud computing multi-tenant architecture |
Non-Patent Citations (4)
| Title |
|---|
| 唐圣潘 等: "基于SAAS模式的共享模型的数据扩展技术研究", 《计算机技术与发展》, vol. 21, no. 8, 31 August 2011 (2011-08-31) * |
| 杜佳 等: "SaaS数据扩展模型研究", 《情报杂志》, vol. 29, 30 June 2010 (2010-06-30), pages 188 - 191 * |
| 袁来如此博主: "如何设计动态（不定）字段的产品数据库表", 《新浪博客》, 7 August 2013 (2013-08-07), pages 1 - 9 * |
| 马淑红 等: "数据库设计的可扩展性案例研究", 《科技信息》, no. 25, 31 December 2009 (2009-12-31), pages 437 - 450 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107943926A (en) * | 2017-11-21 | 2018-04-20 | 郑州云海信息技术有限公司 | The attribute increase method, apparatus and medium of a kind of tables of data |
| CN108073709A (en) * | 2017-12-20 | 2018-05-25 | 上海达梦数据库有限公司 | A kind of operating method of data record, device, equipment and storage medium |
| CN108959221A (en) * | 2018-06-04 | 2018-12-07 | 广州环通信息技术有限公司 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
| CN111241093A (en) * | 2019-12-31 | 2020-06-05 | 嘉兴太美医疗科技有限公司 | Dynamic storage expansion method based on database |
| CN111241093B (en) * | 2019-12-31 | 2021-06-22 | 杭州太美星程医药科技有限公司 | Dynamic storage expansion method based on database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI718375B (en) | Data processing method and equipment based on blockchain | |
| WO2021032002A1 (en) | Big data processing method based on heterogeneous distributed knowledge graph, device, and medium | |
| US8751437B2 (en) | Single persistence implementation of business objects | |
| JP2007531115A5 (en) | ||
| CN110119393B (en) | Code version management system and method | |
| JP2022033825A (en) | Generating, accessing and displaying lineage metadata | |
| RU2007139779A (en) | APPLIED PHASE PHASE MODEL | |
| WO2019134340A1 (en) | Salary calculation method, application server, and computer readable storage medium | |
| US20160063043A1 (en) | Versatile Data Model | |
| KR101643436B1 (en) | Extensibility for web based diagram visualization | |
| CN103617284A (en) | Data field extension method | |
| EP3433770A1 (en) | Methods, electronic device and computer-readable medium for the conversion of cad descriptions | |
| CN106951254B (en) | Method and device for multiplexing similar service function modules in payment system | |
| CN103593456A (en) | Form user-defined design method and device | |
| WO2019076050A1 (en) | Business report query method and apparatus, computer device and storage medium | |
| US8413109B2 (en) | Systems and methods for metamodel transformation | |
| US8732655B2 (en) | Systems and methods for metamodel transformation | |
| CN108108392B (en) | Commodity data management method, commodity data management device, computer equipment and storage medium | |
| US8402038B1 (en) | Method and system for data allocation | |
| CN104199675A (en) | System capable of quick system development based on database parameter utilization | |
| CN106202239B (en) | A kind of CAD data generation SHAPE data file method and system | |
| CN105740131B (en) | Software user behavior rollback processing method and device | |
| CN108228708B (en) | Big data ETL system and scheduling method thereof | |
| Lage | Concept oriented design of numerical software | |
| CN105094845A (en) | Process modeling device and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140305 |