CN103617182A - Basic genetic relationship database construction method and device - Google Patents
Basic genetic relationship database construction method and device Download PDFInfo
- Publication number
- CN103617182A CN103617182A CN201310544941.7A CN201310544941A CN103617182A CN 103617182 A CN103617182 A CN 103617182A CN 201310544941 A CN201310544941 A CN 201310544941A CN 103617182 A CN103617182 A CN 103617182A
- Authority
- CN
- China
- Prior art keywords
- fixing
- sibship
- data
- field
- structural unit
- 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.)
- Withdrawn
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
Abstract
The invention discloses a basic genetic relationship database construction method and device. The method includes: allocating a storage space for the basic genetic relationship database in a relationship database system, creating a table capable of correspondingly storing the fields of the data items expressed by the corresponding attribute for each attribute of a fixed expression structure using a basic genetic relationship data expression method or device, storing the genetic relationship data expressed by the fixed expression structure into the table according to the attribute filed correspondence, and recording and storing one unit with one table. Index can be built for fields of the self information of the relationship storage unit in each table so as to increase retrieval speed. If no corresponding fields exist, the fields need to be built for storing corresponding information. Two or more tables can be built to store the data of the fixed expression structure separately according to importance. By the method, all the basic genetic relationship data can be really and uniformly stored, and comprehensive system analysis can be performed on the basis of the storage.
Description
Technical field
The invention belongs to computer information processing field, relate in particular to a kind of basic sibship database construction method and device.
Background technology
A kind of basic sibship data representation method of application for a patent for invention according to extract transformation rule from existing sibship extracting data change relevant party and own father, breeder mother, with father siblings, with sibship data between 6 kind of two people such as female siblings, own children, spouse, then for each party who relates to create unique use by indicate corresponding sibship people comprise above-mentioned 6 kinds be related to content fixedly represent structural unit, finally according to the data of extracting conversion, the fixing corresponding contents that represents structural unit of related party is set.But the method only lays the foundation for the centralized and unified storage of basic sibship data, really to realize the centralized and unified storage of basic sibship data and carry out on this basis comprehensive systematic analysis also must build basic sibship database.The database platform of current popular is relational database system, and conventional have MS SQL, ORACLE, a MYSQL etc., and building basic sibship database can build on the basis of these ripe relational database systems.
Summary of the invention
The present invention will solve the Construct question of basic sibship database, for addressing the above problem, the object of the present invention is to provide a kind of basic sibship database construction method and device, make basic sibship data can really accomplish centralized and unified storage and carry out on this basis comprehensive systematic analysis.For general Genetic relationship and the application scenario of retrieval, the basic sibship database of the basic sibship data such as centralized stores genetic connection and marital relations can be satisfied the demand.
For solving the problems of the technologies described above, the basic sibship database construction method that the present invention proposes, comprises the following steps:
It in relational database system, is basic sibship database memory allocated space;
Each attribute that creates a fixedly expression structure for institute's employing basic sibship data representation method or in installing in the storage space distributing has all created the table of the field that can store the represented data item of respective attributes of correspondence;
According to attribute field corresponding relation, the fixing sibship data that represent that structural unit represents are stored in table, a fixing expression structural unit is stored with a table record.
For solving the problems of the technologies described above, the basic sibship database construction device that the present invention proposes, this device possesses:
At least one processor; And
At least one storer, contains computer program code, and described at least one storer and computer program code are configured to utilize described at least one processor to make described device
It in relational database system, is basic sibship database memory allocated space;
Each attribute that creates a fixedly expression structure for institute's employing basic sibship data representation method or in installing in the storage space distributing has all created the table of the field that can store the represented data item of respective attributes of correspondence;
According to attribute field corresponding relation, the fixing sibship data that represent that structural unit represents are stored in table, a fixing expression structural unit is stored with a table record.
If fixing, represent that structure is not containing the attribute that indicates affiliated party, described method and apparatus can further improve, table creates a field in foundation step again to store the fixing party's information under structural unit that represents, in data storing step, storage is simultaneously fixing represent structural unit under party's information to showing same record in corresponding field.
As the further improvement of the method for the invention or device, described method or device can be set up index for the field of party's information under the fixing expression of storage structure in table, to improve query and search efficiency.Also can do following adjustment according to actual, in the step of establishment table, create two or more tables, one of them is as master data sheet, for storing, fixing represent that structure is used in reference to this sibship people's of Benq etc. the represented data item of main attribute, other data item is stored in other table, this other data item be not each party possess in the situation that a minute different table storage can realize conserve space.
Accompanying drawing explanation
Fig. 1 is the basic procedure that basic sibship database builds.
Embodiment
Below in conjunction with accompanying drawing, describe.
The basic procedure of basic sibship database construction method and device is referring to Fig. 1:
The first step is basic sibship database memory allocated space in relational database system.First choose a kind of relational database system as the basic database platform of setting up basic sibship database, and in this relational database system, be basic sibship database memory allocated space, conventional relational database system has MS SQL, ORACLE, MYSQL etc. at present, can choose according to actual conditions, the factor of considering mainly contains data volume, performance requirement, cost input etc., if just can select such as wanting to reduce costs the MYSQL that freely increases income;
Second step, in the storage space distributing, create the table that each attribute for the fixedly expression structure in institute's employings basic sibship data representation method or device has all created the corresponding field that can store the represented data item of respective attributes, thereby assurance sibship tables of data can be stored the sibship data of fixing expression representation completely; If fixing, represent that structure is not containing the attribute that indicates affiliated party, need to create again a field and fixing represent party's information under structural unit to store, otherwise not know the basic sibship data of that party that fixing expression structural unit means on earth.Also can create two or more tables of data, one of them is as master data sheet, for storing, fixing represent that structure is used in reference to this sibship people's of Benq etc. the represented data item of main attribute, other data item is stored in other table, for other data item, not can conserve space in each party situation about possessing, when query analysis, these two or more tables of data can be placed in a view, similarly be also in a table for inquiring user etc.; In order to improve the speed of retrieval, can set up index for the field of the attribute of corresponding named principal in tables of data;
The 3rd step, stores the fixing sibship data that represent that structural unit represents in table into according to attribute field corresponding relation, and a fixing expression structural unit is stored with a table record.If fixing, represent that structure itself is not containing the attribute that indicates affiliated party, to have created specially a field fixing represent under structural unit party's information in the situation that to store, also to store simultaneously and fixingly represent under structural unit that party's information stores into and show same record in this field.
Embodiment 1
This example relies on commercial relational database system ORACLE to realize, login ORACLE Database Systems, create a BASIC_RELATION database as basic sibship database, memory allocated space, create the default configuration that index all adopts ORACLE Database Systems, in BASIC_RELATION database, create a BASIC_RELATION table, the field of definition list has ID, FATHER, MOTHER, NEXTBROTHER_F, NEXTBROTHER_M, ACHILD, MARRYED, type is VCHAR (18), store respectively corresponding party, own father, breeder mother, with father siblings, with female siblings, own children, spouse's identification card number, the field that creates index is ID.
Suppose to have certain family in census register management system to have 8 people V0, V1, V2, V3, V4, V5, V6, V7, householder is V2, the currency of V0 " with householder's relation " is " wife ", the currency of V1 " with householder's relation " is " brother wife ", the currency of V3 " with householder's relation " is " son ", the currency of V4 " with householder's relation " is " father-in-law ", the currency of V5 " with householder's relation " is " mother-in-law ", the currency of V6 " with householder's relation " is " mother ", and the currency of V7 " with householder's relation " is " father ".Through extracting and be converted to canonical representation structure, the simplest canonical representation structure should have 7 attributes, with seven tuple (ID, FATHER, MOTHER, NEXTBROTHER_F, NEXTBROTHER_M, ACHILD, MARRYED) represent, V0, V1, V2, V3, V4, V5, V6, V7 for property value wherein represents that corresponding identification card number, NULL represent that corresponding sibship people is unknown, is respectively me and for own father, breeder mother, with father siblings, with 6 kinds of parties such as female siblings, own children, spouses.The corresponding polynary ancestral who obtains after extracting conversion is respectively:
E0：（V0,V4,V5,V1,V1, V3, V2）
E1：（V1,V4,V5,V0,V0, NULL, NULL）
E2：（V2,V7,V6, NULL, NULL, V3, V0）
E3：（V3,V2,V1, NULL, NULL, NULL, NULL）
E4：（V4, NULL, NULL, NULL, V0, NULL, NULL）
E5：（V5, NULL, NULL, NULL, V0, NULL, NULL）
E6：（V6, NULL, NULL, NULL, V2, NULL, NULL）
E7：（V7,NULL, NULL, NULL, V2, NULL, NULL）
By INSERT statement, insert 8 and be recorded in BASIC_RELATION table, by attribute field corresponding relation, carry out assignment.Complete insertion statement example is as follows:
INSERT BASIC_RELATION
SET ID= E0.ID，FATHER= E0. FATHER，MOTHER= E0. MOTHER，NEXTBROTHER_F= E0. NEXTBROTHER_F，NEXTBROTHER_M= E0. NEXTBROTHER_M，ACHILD= E0. ACHILD，MARRYED= E0. MARRYED。
Claims (8)
1. a basic sibship database construction method, is characterized in that comprising the following steps:
It in relational database system, is basic sibship database memory allocated space;
Each attribute that creates a fixedly expression structure for institute's employing basic sibship data representation method or in installing in the storage space distributing has all created the table of the field that can store the represented data item of respective attributes of correspondence;
According to attribute field corresponding relation, the fixing sibship data that represent that structural unit represents are stored in table, a fixing expression structural unit is stored with a table record.
2. method according to claim 1, it is characterized in that: table creates a field in foundation step again to store the fixing party's information under structural unit that represents, in data storing step, storage is simultaneously fixing represent structural unit under party's information to showing same record in corresponding field.
3. method according to claim 1 and 2, is characterized in that: for the field of party's information under the fixing expression of storage structure in table is set up index.
4. method according to claim 1 and 2, it is characterized in that: in the step of establishment table, create two or more tables, one of them is as master data sheet, for storing, fixing represent that structure is used in reference to this sibship people's of Benq etc. the represented data item of main attribute, other data item is stored in other table.
5. a basic sibship database construction device, is characterized in that, this device possesses:
At least one processor; And
At least one storer, contains computer program code, and described at least one storer and computer program code are configured to utilize described at least one processor to make described device
It in relational database system, is basic sibship database memory allocated space;
Each attribute that creates a fixedly expression structure for institute's employing basic sibship data representation method or in installing in the storage space distributing has all created the table of the field that can store the represented data item of respective attributes of correspondence;
According to attribute field corresponding relation, the fixing sibship data that represent that structural unit represents are stored in table, a fixing expression structural unit is stored with a table record.
6. device according to claim 5, it is characterized in that: table creates a field in foundation step again to store the fixing party's information under structural unit that represents, in data storing step, storage is simultaneously fixing represent structural unit under party's information to showing same record in corresponding field.
7. according to the device described in claim 5 or 6, it is characterized in that: for the field of party's information under the fixing expression of storage structure in table is set up index.
8. according to the device described in claim 5 or 6, it is characterized in that: in the step of establishment table, create two or more tables, one of them is as master data sheet, for storing, fixing represent that structure is used in reference to this sibship people's of Benq etc. the represented data item of main attribute, other data item is stored in other table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310544941.7A CN103617182A (en) | 2013-11-07 | 2013-11-07 | Basic genetic relationship database construction method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310544941.7A CN103617182A (en) | 2013-11-07 | 2013-11-07 | Basic genetic relationship database construction method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103617182A true CN103617182A (en) | 2014-03-05 |
Family
ID=50167885
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310544941.7A Withdrawn CN103617182A (en) | 2013-11-07 | 2013-11-07 | Basic genetic relationship database construction method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103617182A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105868521A (en) * | 2015-12-14 | 2016-08-17 | 乐视网信息技术（北京）股份有限公司 | Data information processing method and apparatus |
| CN107291951A (en) * | 2017-07-24 | 2017-10-24 | 北京都在哪智慧城市科技有限公司 | Data processing method, device, storage medium and processor |
-
2013
- 2013-11-07 CN CN201310544941.7A patent/CN103617182A/en not_active Withdrawn
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105868521A (en) * | 2015-12-14 | 2016-08-17 | 乐视网信息技术（北京）股份有限公司 | Data information processing method and apparatus |
| CN107291951A (en) * | 2017-07-24 | 2017-10-24 | 北京都在哪智慧城市科技有限公司 | Data processing method, device, storage medium and processor |
| CN107291951B (en) * | 2017-07-24 | 2020-09-29 | 北京都在哪智慧城市科技有限公司 | Data processing method, device, storage medium and processor |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9047330B2 (en) | Index compression in databases | |
| Karnitis et al. | Migration of relational database to document-oriented database: Structure denormalization and data transformation | |
| CN106227800B (en) | Storage method and management system for highly-associated big data | |
| CN103577440B (en) | A kind of data processing method and device in non-relational database | |
| CN103390015B (en) | Based on mass data stored in association method and the search method of unified index | |
| CN106933833B (en) | Method for quickly querying position information based on spatial index technology | |
| CN105260464B (en) | The conversion method and device of data store organisation | |
| CN104915450A (en) | HBase-based big data storage and retrieval method and system | |
| EP2821924A1 (en) | Method, device and system for querying data index | |
| US10127254B2 (en) | Method of index recommendation for NoSQL database | |
| CN105243162A (en) | Relational database storage-based objective data model query method and device | |
| CN108009265B (en) | Spatial data indexing method in cloud computing environment | |
| CN102930027A (en) | Data processing system and processing method in cloud computing multi-tenant architecture | |
| CN104504008B (en) | A kind of Data Migration algorithm based on nested SQL to HBase | |
| US10078624B2 (en) | Method of generating hierarchical data structure | |
| CN103020262A (en) | Data storage method, system and data storage equipment | |
| CN104021210B (en) | Geographic data reading and writing method of MongoDB cluster of geographic data stored in GeoJSON-format semi-structured mode | |
| US20130262400A1 (en) | Data index query method, apparatus and system | |
| Kong et al. | A novel model supporting customization sharing in SaaS applications | |
| CN103617182A (en) | Basic genetic relationship database construction method and device | |
| CN103617181A (en) | Method and device for establishing universal database of relationships | |
| CN107273443B (en) | Mixed indexing method based on metadata of big data model | |
| CN103617184A (en) | Method and device for building consanguineous relationship database | |
| CN103617185A (en) | Method and device for establishing comprehensive genetic relationship databases | |
| CN103617188A (en) | Method and device for establishing main genetic relationship databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C04 | Withdrawal of patent application after publication (patent law 2001) | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20140305 |