CN105740429A - Extensible database table structure - Google Patents
Extensible database table structure Download PDFInfo
- Publication number
- CN105740429A CN105740429A CN201610067009.3A CN201610067009A CN105740429A CN 105740429 A CN105740429 A CN 105740429A CN 201610067009 A CN201610067009 A CN 201610067009A CN 105740429 A CN105740429 A CN 105740429A
- Authority
- CN
- China
- Prior art keywords
- data model
- data
- attribute
- model
- extendible
- 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
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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an extensible database table structure. The extensible database table structure comprises a data model description table and a data model access table, wherein the data model description table and the data model access table are respectively established in a database; the data model description table at least comprises three important fields: model type, data model attribute and data model incidence relation; and the data model access table at least comprises two important fields: data model type and data mode attribute. The extensible database table structure has the benefit of effectively isolating the influences, on the database table structure, of the data model change, so as to reduce the maintenance cost, caused by the data model change, of the database table structure.
Description
Technical field
The present invention relates to database design technique field, be specifically related to a kind of extendible database table structure.
Background technology
Data base is the physical store carrier of data model, and data base uses tables of data that data model is accessed, tables of data and data model one_to_one corresponding, the data attribute of the field corresponding data model in tables of data.
Three big normal forms are followed in the design of database table:
1. first normal form: guarantee that each column keeps atomicity；
2. second normal form: guarantee that each column in table is all relevant with major key；
3. third normal form: guarantee that each column is all directly related with primary key column, rather than indirect correlation.
In existing database schema, in data base's design, general data model and tables of data are relations one to one, therefore there is very strong dependence between tables of data and data model, data model changes, tables of data also to be modified accordingly, so causes that the maintenance cost of data model is very high.
Summary of the invention
The purpose of the present invention is contemplated to solve the problems referred to above, it is proposed that a kind of extendible database table structure, and this structure relieves the strong dependence of tables of data and data model, effectively avoids the change of the data list structure that data model change brings.
To achieve these goals, the present invention adopts the following technical scheme that
A kind of extendible database table structure, including: the data model set up in data base respectively describes table and data model access list；
Described data model describes table for describing the information that data model stores in data base；
Described data model access list, for describing based on the information stored in table by data model, carries out the access of data model example；
Described data model describes table including at least types of models, data model attribute and three important fields of data model interaction relation；Described data model access list includes at least data model type and two significant fields of data model attributes value.
Described data model describes the data model type field in table for describing the type of data model, is the unique designation of data model.
Described data model describes the data model incidence relation field in table by called data types of models field, describes the incidence relation between data model.
Described data model describes the data model attribute field in table for describing all properties of data model, uses special symbol segmentation between data model attribute.
Each described data model attribute field includes again Property Name, attribute type, attribute default value content information, uses special symbol segmentation between above-mentioned data model property content information.
Data model type field in described data model access list is used for accessing data model type, and the data model type that described data model type describes with data model in table is corresponding.
Data model attribute field in described self-description data model table is for all properties of descriptive model, character string and special list separator is used to split between model attributes, describe realize newly-increased model data attribute by adding separator and model attributes, without extending database literary name section.
Each described data model attribute value field includes: Property Name and property value, uses special symbol segmentation between described Property Name and property value.
When carrying out data base data model extension, only need to data model describe table at least increases to extend data model type, data model attribute and and other data models between incidence relation field information, it is not necessary to change data model access list.
The invention has the beneficial effects as follows:
The design of the extendible database table structure of the present invention, it is possible to database table structure is affected by effective isolated data model change, thus reducing the maintenance cost of the database table structure that data model change brings.
Accompanying drawing explanation
Fig. 1 is database table structure schematic diagram of the present invention；
Fig. 2 is that data model of the present invention describes expression intention；
Fig. 3 is data model access list schematic diagram of the present invention.
Detailed description of the invention:
Below in conjunction with accompanying drawing, the present invention will be further described with embodiment:
A kind of extendible database table structure, as it is shown in figure 1, include: the data model set up in data base respectively describes table and data model access list；
Data model describes table for describing the information that data model stores in data base；
Data model access list, for describing based on the information stored in table by data model, carries out the access of data model example；I.e. data model access list, storage is the data model example value that describes the data model in table.
Data model describes table including at least types of models, data model attribute and three important fields of data model interaction relation；Data model access list includes at least data model type and two significant fields of data model attributes value.
As in figure 2 it is shown, data model describes the data model type field in table for describing the type of data model, it is used for accessing data model type, sets up the mapping (association) of data model access list and self-description data model table；It is illustrated below:
1, data model describes table (being designated as Table A), and data model access list (is designated as table B)
Data model type field in table B and the types of models field in Table A, access is identical content, for setting up the mapping accessing data in Table A and table B.Such as, Table A comprises computer, the description of two kinds of models of phone, table B then needs the example of accessed computer and two kinds of typess of models of phone, in so actually used middle table B, model instance particularly belongs to which kind of types of models (computer or phone), how this types of models resolves, it is accomplished by the data model type field (computer or phone) of first inquiry table B, if computer, it is accomplished by inquiry Table A, data model type is the record of computer, then go to resolve the example in current table B according to the resolution rules of this record in Table A, including which attribute example has, the type of attribute be what etc..
The data model incidence relation field that data model describes in table passes through types of models, relation between descriptive model, for instance model A is a router, Model B is a computer, B is a child node of A in a network, can this filiation by data model incidence relation field description.
Data model describes all properties for descriptive model of the data model attribute field in table, uses special symbol segmentation, it is achieved that the expanded function of model attributes between model attributes.All model attributes are placed in a data sheet field, with character string and special separator describe (such as "；"), it is possible to by adding separator and model attributes, the purpose reaching to increase model data attribute without growth data literary name section is described, it is achieved thereby that the extension of the data model attribute when not changing database table structure.
Each described data model attribute field includes again Property Name, attribute type, attribute default value content information, between above-mentioned model attributes content information use special symbol segmentation (such as "; "), separator is separated these information and is easy to resolve according to fixing form, it is achieved that the self-described function of model attributes.
As it is shown on figure 3, the data model type field in data model access list is used for accessing data model type, it it is the unique designation of storage data model.
Data model attribute value field in data model access list uses special symbol segmentation for accessing between the Value Data model attributes of all of data attribute of data model.
Each described data model attribute value field includes: Property Name, property value, uses special symbol segmentation between Property Name and property value；
Generic data model access list achieves the data model access facility unrelated with data model.
Data model access list can access all of data model, thus unrelated with data model；Such as router above-mentioned, computer are stored in this table.
If you wish to add a mobile phone in data base, then you only need to describe in table at data model, describe mobile phone, in data model access list, then just can describe the description information of mobile phone in table according to data model, carry out the access of mobile model example.
The specific embodiment of the present invention is described in conjunction with accompanying drawing although above-mentioned; but not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme, those skilled in the art need not pay various amendments or deformation that creative work can make still within protection scope of the present invention.
Claims (9)
1. an extendible database table structure, is characterized in that, including: the data model set up in data base respectively describes table and data model access list；
Described data model describes table for describing the information that data model stores in data base；
Described data model access list, for describing based on the information stored in table by data model, carries out the access of data model example；
Described data model describes table including at least types of models, data model attribute and three important fields of data model interaction relation；Described data model access list includes at least data model type and two significant fields of data model attributes value.
2. a kind of extendible database table structure as claimed in claim 1, is characterized in that, described data model describes the data model type field in table for describing the type of data model, is the unique designation of data model.
3. a kind of extendible database table structure as claimed in claim 1, is characterized in that, described data model describes the data model incidence relation field in table by called data types of models field, describes the incidence relation between data model.
4. a kind of extendible database table structure as claimed in claim 1, is characterized in that, described data model describes the data model attribute field in table for describing all properties of data model, uses special symbol segmentation between data model attribute.
5. a kind of extendible database table structure as claimed in claim 4, it is characterized in that, each described data model attribute field includes again Property Name, attribute type, attribute default value content information, uses special symbol segmentation between above-mentioned data model property content information.
6. a kind of extendible database table structure as claimed in claim 1, it is characterized in that, data model type field in described data model access list is used for accessing data model type, and the data model type that described data model type describes with data model in table is corresponding.
7. a kind of extendible database table structure as claimed in claim 1, it is characterized in that, data model attribute field in described self-description data model table is for all properties of descriptive model, character string and special list separator is used to split between model attributes, describe realize newly-increased model data attribute by adding separator and model attributes, without extending database literary name section.
8. a kind of extendible database table structure as claimed in claim 7, is characterized in that, each described data model attribute value field includes: Property Name and property value, uses special symbol segmentation between described Property Name and property value.
9. a kind of extendible database table structure as claimed in claim 1, it is characterized in that, when carrying out data base data model extension, only need to data model describe table at least increases to extend data model type, data model attribute and and other data models between incidence relation field information, it is not necessary to change data model access list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610067009.3A CN105740429A (en) | 2016-01-29 | 2016-01-29 | Extensible database table structure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610067009.3A CN105740429A (en) | 2016-01-29 | 2016-01-29 | Extensible database table structure |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105740429A true CN105740429A (en) | 2016-07-06 |
Family
ID=56247259
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610067009.3A Pending CN105740429A (en) | 2016-01-29 | 2016-01-29 | Extensible database table structure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105740429A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040117397A1 (en) * | 2002-12-16 | 2004-06-17 | Rappold Robert J | Extensible database system and method |
| US6766326B1 (en) * | 2000-07-24 | 2004-07-20 | Resty M Cena | Universal storage for dynamic databases |
| CN105144162A (en) * | 2013-04-30 | 2015-12-09 | 西斯特米特公司 | Integration database framework |
-
2016
- 2016-01-29 CN CN201610067009.3A patent/CN105740429A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6766326B1 (en) * | 2000-07-24 | 2004-07-20 | Resty M Cena | Universal storage for dynamic databases |
| US20040117397A1 (en) * | 2002-12-16 | 2004-06-17 | Rappold Robert J | Extensible database system and method |
| CN105144162A (en) * | 2013-04-30 | 2015-12-09 | 西斯特米特公司 | Integration database framework |
Non-Patent Citations (1)
| Title |
|---|
| 朱晓春: "基于CWM的关系型数据库建模工具的研究", 《中国优秀博硕士学位论文全文数据库 (硕士)信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109299102B (en) | HBase secondary index system and method based on Elastcissearch | |
| US11468027B2 (en) | Method and apparatus for providing efficient indexing and computer program included in computer readable medium therefor | |
| US9129005B2 (en) | Method and apparatus for searching a hierarchical database and an unstructured database with a single search query | |
| US8224804B2 (en) | Indexing of partitioned external data sources | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN100561482C (en) | A kind of implementation method of embedded system data base | |
| AU2015218513B2 (en) | Versatile data model | |
| US20120109970A1 (en) | Methods for indexing and searching based on language locale | |
| US11150996B2 (en) | Method for optimizing index, master database node and subscriber database node | |
| CN106095698A (en) | OO caching write, read method and device | |
| Von der Weth et al. | Multiterm keyword search in NoSQL systems | |
| CN107145549B (en) | Database cache control method and system | |
| CN110928882B (en) | Memory database indexing method and system based on improved red black tree | |
| US20120078905A1 (en) | Manipulating non-schema attributes for objects in a schema based directory | |
| CN108628871A (en) | A kind of link De-weight method based on chain feature | |
| CN103714121B (en) | The management method and device of a kind of index record | |
| CN106874429B (en) | Method for converting standard SQL into full text retrieval standard query | |
| CN110716913B (en) | Mutual migration method of Kafka and Elasticissearch database data | |
| CN105740429A (en) | Extensible database table structure | |
| CN105740414A (en) | Database-based self-described data model structure | |
| US11080332B1 (en) | Flexible indexing for graph databases | |
| CN109002446A (en) | A kind of intelligent sorting method, terminal and computer readable storage medium | |
| EP3091447B1 (en) | Method for modifying root nodes and modifying apparatus | |
| CN102609510B (en) | Chinese name data processing method and device | |
| CN106844388A (en) | A kind of information knowledge base based on Solr technologies |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 250101 block B, Yinhe building, 2008 Xinjie street, hi tech Zone, Ji'nan, Shandong. Applicant after: Shandong Luneng Intelligent Technology Co., Ltd. Address before: 250101 B block 626, Yinhe building, 2008 Xinjie street, Ji'nan high tech Zone, Shandong. Applicant before: Shandong Luneng Intelligent Technology Co., Ltd. |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160706 |
|
| RJ01 | Rejection of invention patent application after publication |