CN110647588A - Universal algorithm for automatically filling all forms in any complex relation data model and automatically testing big data - Google Patents
Universal algorithm for automatically filling all forms in any complex relation data model and automatically testing big data Download PDFInfo
- Publication number
- CN110647588A CN110647588A CN201810584702.7A CN201810584702A CN110647588A CN 110647588 A CN110647588 A CN 110647588A CN 201810584702 A CN201810584702 A CN 201810584702A CN 110647588 A CN110647588 A CN 110647588A
- Authority
- CN
- China
- Prior art keywords
- data
- csv
- relational database
- tables
- filling
- 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
- 238000011049 filling Methods 0.000 title claims abstract description 50
- 238000012360 testing method Methods 0.000 title claims abstract description 17
- 238000013499 data model Methods 0.000 title description 2
- 238000000034 method Methods 0.000 claims abstract description 33
- 238000010586 diagram Methods 0.000 claims abstract description 19
- 238000007405 data analysis Methods 0.000 claims description 8
- 239000000463 material Substances 0.000 abstract description 5
- 230000008901 benefit Effects 0.000 abstract description 4
- 208000025174 PANDAS Diseases 0.000 description 2
- 208000021155 Paediatric autoimmune neuropsychiatric disorders associated with streptococcal infection Diseases 0.000 description 2
- 240000004718 Panda Species 0.000 description 2
- 235000016496 Panda oleosa Nutrition 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000003044 adaptive effect Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Abstract
The embodiment of the invention provides a method and a system for automatically filling table data of a relational database. Wherein the method comprises the following steps: determining a hierarchical relationship between tables in the relational database according to the SQL file of the relational database; and generating a contact diagram for contacting all the forms according to the hierarchical relationship, and automatically filling data in all the forms according to the contact diagram. The method can be used for automatically generating data and filling in the database form conveniently during database test, and can be applied to final actual data form filling after simple expansion and adjustment. By using the method and the device, the batch automatic form filling of the big data can be realized, the application value is wide, the manpower and the material resources are saved, and the obvious economic benefit can be brought to the enterprise.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method and a device for automatically filling table data of a relational database.
Background
The relational database is a database established on the basis of a relational model, and data in the database is processed by means of mathematical concepts and methods such as set algebra and the like. It is a database composed of a plurality of two-dimensional row-column tables which can be connected with each other. Relational databases are widely used in society, but tables within a database require manual population of all data individually. If the tables of the database are many, the number of fields of the tables is many, the relationship among the tables is complex, and the modification and the test of the table filling of the database are very inconvenient.
Therefore, the prior art has yet to be developed.
Disclosure of Invention
In view of the above disadvantages of the prior art, the present invention provides a method and a device for automatically filling table data of a relational database, which aims to solve the problem of inconvenient table filling, modification and testing of the database in the prior art.
In order to achieve the purpose, the invention adopts the following technical scheme: an automatic filling method for table data of relational database. The automatic filling method comprises the following steps: determining a hierarchical relationship between tables in the relational database according to the SQL file of the relational database; generating a contact diagram for contacting all the tables according to the hierarchical relationship; and automatically filling data in all the forms according to the contact diagram.
Optionally, the contact map includes: a dictionary structure consisting of key-value pairs; the key is the table name of the table, and the value is the pointer of the table in the relational database; the method comprises the following steps of (1) calling a csv table name, wherein the csv table name is a table containing real data; and an ID table name containing only table names of the sub-table IDs.
Optionally, the determining a hierarchical relationship between tables in the relational database according to the SQL file of the relational database specifically includes: analyzing and generating a corresponding SQL file when the relational database is generated by utilizing an initialization function; obtaining the hierarchical relationship of all tables in the relational database; generating corresponding parent relation variables and child relation variables according to the hierarchical relation; and the parent relation variable is an outermost table name list.
Optionally, generating a contact graph for contacting all the tables according to the hierarchical relationship, specifically including; searching a statement starting from alter in the SQL file; determining a table referenced after the statement as a parent table of the statement; repeatedly executing the searching and determining steps to obtain branch information of each statement; according to the branch information, the branches of each table node are correspondingly connected with the parent table one by one, and the parent relation variable and the child relation variable are generated simultaneously; searching fields and data types of all tables, and simultaneously generating csv table names and table names only containing sub-table IDs; and sequentially writing the parent relation variable and the child relation variable into corresponding tables in the relational database.
Optionally, the automatically filling data in all the forms according to the contact diagram specifically includes:
reading the SQL file corresponding to the relational database, and comparing each read table name with the csv table name and the ID table name; when the table name belongs to the csv table name, filling all field names except the ID field into the csv table; identifying a field containing real data in the csv table name; generating corresponding test data according to the data type of the real data; and adding the test data and the data of the contact diagram of the table to form a record and performing batch automatic form filling according to the record.
The embodiment of the invention also provides an automatic filling device for the table data of the relational database. The data automatic filling device comprises: the data analysis module is used for determining the hierarchical relationship among the tables in the relational database according to the SQL file of the relational database; generating a contact diagram for contacting all the tables according to the hierarchical relationship; and the csv generation module is used for automatically filling data in all the forms according to the contact diagram.
Optionally, the data analysis module is specifically configured to analyze, by using an initialization function, a corresponding SQL file when the relational database is generated; obtaining the hierarchical relationship of all tables in the relational database; generating corresponding parent relation variables and child relation variables according to the hierarchical relation; and the parent relation variable is an outermost table name list.
Optionally, the contact map includes: a dictionary structure consisting of key-value pairs; the key is the table name of the table, and the value is the pointer of the table in the relational database; the method comprises the following steps of (1) calling a csv table name, wherein the csv table name is a table containing real data; and an ID table name containing only table names of the sub-table IDs.
Optionally, the initialization function is specifically configured to: searching a statement starting from alter in the SQL file; determining a table referenced after the statement as a parent table of the statement; repeatedly executing the searching and determining steps to obtain branch information of each statement; according to the branch information, the branches of each table node are correspondingly connected with the parent table one by one, and the parent relation variable and the child relation variable are generated simultaneously; searching fields and data types of all tables, and simultaneously generating csv table names and table names only containing sub-table IDs; and sequentially writing the parent relation variable and the child relation variable into corresponding tables in the relational database.
Optionally, the csv generation module is specifically configured to: reading the SQL file corresponding to the relational database, and comparing each read table name with the csv table name and the ID table name; when the table name belongs to the csv table name, filling all field names except the ID field into the csv table; identifying a field containing real data in the csv table name; generating corresponding test data according to the data type of the real data; adding the test data to the data of the relation graph of the table to form a record; and performing automatic table filling in batches according to the records.
Has the advantages that: the method and the device provided by the invention can be used for conveniently and automatically generating data during database test and automatically filling the data into the database form. And can be applied to the final actual data form filling through simple expansion and adjustment. By using the method and the device, the batch automatic form filling of the big data can be realized, the application value is wide, the manpower and the material resources are saved, and the obvious economic benefit can be brought to the enterprise.
Drawings
Fig. 1 is a flowchart of a method for automatically filling table data in a relational database according to an embodiment of the present invention.
Fig. 2 is a functional block diagram of an automatic table data filling system of a relational database according to an embodiment of the present invention.
Detailed Description
The invention provides a method and a device for automatically filling table data of a relational database. In order to make the objects, technical solutions and effects of the present invention clearer and clearer, the present invention is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
In the description of the present invention, it is to be understood that the terms "central," "longitudinal," "lateral," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," "axial," "radial," "circumferential," and the like are used in the orientations and positional relationships indicated in the drawings for convenience in describing the invention and to simplify the description, and are not intended to indicate or imply that the referenced devices or elements must have a particular orientation, be constructed and operated in a particular orientation, and are therefore not to be considered limiting of the invention.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means two or more unless specifically defined otherwise.
In the present invention, unless otherwise expressly stated or limited, the terms "mounted," "connected," "secured," and the like are to be construed broadly and can, for example, be fixedly connected, detachably connected, or integrally formed; can be mechanically or electrically connected; either directly or indirectly through intervening media, either internally or in any other relationship. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations.
In the present invention, unless otherwise expressly stated or limited, the first feature "on" or "under" the second feature may be directly contacting the first and second features or indirectly contacting the first and second features through an intermediate. Also, a first feature "on," "over," and "above" a second feature may be directly or diagonally above the second feature, or may simply indicate that the first feature is at a higher level than the second feature. A first feature being "under," "below," and "beneath" a second feature may be directly under or obliquely under the first feature, or may simply mean that the first feature is at a lesser elevation than the second feature.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Fig. 1 is a diagram illustrating an automatic filling method for table data of a relational database according to an embodiment of the present invention. As shown in fig. 1, the automatic filling method may generally include the steps of:
110. and determining the hierarchical relationship between the tables in the relational database according to the SQL file of the relational database.
120. And generating a contact diagram for contacting all the tables according to the hierarchical relationship.
The contact graph includes the following key data structures:
1. the "key" is a character string, that is, each table name, which is obtained by automatically searching under a specified csv file list path; "value" is a pointer to the actual table in the database, obtained through the functionality provided by the open source framework SQLAlchemy.
2. table _ real { "csv table name", [ list of all fields in table ] }, which is a table containing real data.
3. table _ ID { "table name containing only sub-table ID", [ list of all fields in table ] }. I.e. the ID table name, which contains only table names of sub-table IDs
In a specific SQL file analysis process, an initialization function init () needs to be used.
The initialization function is specifically configured to: and analyzing the corresponding SQL file when the database is generated, obtaining the hierarchical relation of all tables in the database, and generating parent [ ], child _0[ ], child _1[ ], … and root _ child.
Where para [ ] is the outermost list of table names, these tables must be the tables from csv that contain the real data, corresponding to the leaves in the tree structure. These tables must correspond to table _ real.
Of course, in this embodiment, the parent definition is consistent with the definition of the database when analyzing the dependency, and is opposite to the parent-child relationship definition in the data structure. The outermost layer in this embodiment is not the lowest layer in the tree structure, but all leaf nodes that have no more branches may be distributed in each layer.
child _0[ ] is a list of the top level nodes of all leaves, i.e., each child _0 is sent with the possibility of branching off several branch leaves.
By analogy based on the above basis, child _1[ ], child _2[ ], … can be obtained. Of course, it should be noted that there may be a table _ ID containing only sub-table IDs starting from child _ 1. root _ child is the root node of the tree, only one.
Specifically, the work flow of the initialization function init () in some embodiments is as follows:
first, the SQL file is searched for all statements beginning with "alter", and the table following "referrens" is the parent table of this table (the parent table in the database dependency). And repeating the searching steps to obtain the branch information of each node.
Then, the branches of each table node are connected with the parent table in a one-to-one correspondence manner, and parent [ ], child _0[ ], child _1[ ], … and root _ child are generated at the same time.
And finally, searching fields and data types of all tables, and generating table _ real { }andtable _ ID { }.
In some embodiments, after child _1[ ], child _2[ ], … are computed by an initialization function, the method may further use an insert () function, an insert _ tbl _ real () function, and an insert _ tbl _ ID () function.
Wherein, the insert () function is written into the corresponding table in the database in the order of parent [ ], child _0[ ], child _1[ ], …, root _ child. While a parent will only call insert _ tbl _ real () because the parent's data must come from the csv file, being the actual data, others may call insert _ tbl _ real () or insert _ tbl _ ID ().
The insert () function reads real csv table data or records, reading fixed size records at a time with pandas for large data scenarios. All records are written into the corresponding tables of the database.
The insert _ tbl _ ID () function writes only the common contact fields used to contact records of all sub-tables, such as economic monitoring, and can contact the small records of all sub-tables with the three fields "enterprise", "year", "month" to become one large record. All tables need to be updated simultaneously each time any one or several tables of the database are updated.
130. And automatically filling data in all the forms according to the contact diagram.
In the final form filling step 130, two different functions may be implemented. In the present embodiment, the function includes gen _ csv () and fill _ csv ().
Wherein gen _ csv () reads the SQL file corresponding to the database. Comparing each read table name with table _ real { }, table _ ID { } generated by the identification of the prior initialization function init (). If the file belongs to table _ real { }, after the ID field of the main/foreign key is removed, all field names are filled into the csv table, namely, csv files only containing real data fields are generated.
The filel _ csv () is used to identify a field containing real data from table _ real { } generated by the initialization function init (), generate corresponding test data according to the data type of the field, and finally add the data of the public field which is used for connecting each table to form a record, and then, can perform automatic table filling in batches according to needs, thereby realizing automation in the case of large data.
After all csv files generated by the previous gen _ csv () are repeatedly subjected to the file _ csv (), the automatic table filling of all csv tables can be completed.
Based on the disclosure of the above method embodiment, the embodiment of the present invention further provides an automatic table data filling device for a relational database. Fig. 2 is a functional block diagram of an automatic table data filling apparatus according to an embodiment of the present invention.
As shown in fig. 2, the data automatic filling-in device includes: a data analysis module (db module) 210 and a csv generation module (gen _ csv module) 220.
The data analysis module (db module) 210 is configured to determine a hierarchical relationship between tables in the relational database according to the SQL file of the relational database, and generate a relationship diagram for associating all tables according to the hierarchical relationship. The csv generation module (gen _ csv module) 220 is used for automatically filling data in all the tables according to the contact diagram.
Specifically, the data analysis module 210 may specifically analyze, by using the initialization function 211, the SQL file corresponding to the generation of the relational database. And acquiring the hierarchical relations of all tables in the relational database, and generating corresponding parent relation variables and child relation variables according to the hierarchical relations. And the parent relation variable is an outermost table name list.
In some embodiments, the contact map comprises: a dictionary structure consisting of key-value pairs; the key is the table name of the table, and the value is the pointer of the table in the relational database; the method comprises the following steps of (1) calling a csv table name, wherein the csv table name is a table containing real data; and an ID table name containing only table names of the sub-table IDs.
Similar to the disclosure of the above method embodiment, the specific workflow of the initialization function is:
first, the SQL file is searched for all statements beginning with "alter", and the table following "referrens" is the parent table of this table (the parent table in the database dependency). And repeating the searching and confirming process to obtain the branch information of each node.
Then, the branches of each table node are connected with the parent table in a one-to-one correspondence manner, and parent [ ], child _0[ ], child _1[ ], … and root _ child are generated at the same time.
And finally, searching fields and data types of all tables, and generating table _ real { }andtable _ ID { }.
Specifically, the data analysis module 210 may further include two different insert () functions based on the result of the initialization function.
For the insert () function, it is written into the corresponding table in the database in order of parent [ ], child _0[ ], child _1[ ], …, root _ child. Only insert _ tbl _ real () will be called for parent because parent's data must come from the csv file, being the actual data, and others may call insert _ tbl _ real () or insert _ tbl _ ID ().
The insert _ tbl _ real () function is used to read real csv table data or records, with pandas, for large data scenes, a fixed size record at a time. All records are written into the corresponding tables of the database. The insert _ tbl _ ID () function writes only the common contact fields for contacting records of all sub-tables, e.g., for economic monitoring, the small records of all sub-tables can be contacted as one large record by using the three fields "enterprise", "year" and "month". All tables need to be updated simultaneously each time any one or several tables of the database are updated.
In other embodiments, as shown in fig. 2, the csv generation module 220 may specifically include a gen _ csv () function 221 and a fill _ csv () function 222.
The gen _ csv () unit reads an SQL file corresponding to the database, and compares each read table name with table _ real { } and table _ ID { } generated by identification of an initialization function init () in the front db module.
If the file belongs to table _ real { }, after the ID field of the main/foreign key is removed, all field names are filled into the csv table, namely, csv files only containing real data fields are generated.
The fill _ csv () unit identifies a field containing real data from table _ real { } generated by an initialization function init () in the db module, generates corresponding test data according to the data type of the field, and finally adds the data of the public field which is related to each table to form a record, and then can perform automatic table filling in batches according to needs to realize automation in the case of large data.
All csv files generated by gen _ csv () can complete the automatic table filling of all csv tables by repeating the above process.
In summary, the apparatus and method provided in the embodiments of the present invention can facilitate automatic generation of data and filling of database tables during database testing. Based on the principles and inventive concepts disclosed in the embodiments of the present invention, those skilled in the art can also expand and adapt the same to apply to actual form filling.
The method and the device are adaptive to the explosive data quantity growth trend, can be used for automatic batch form filling of large data, have wide application value, save manpower and material resources and can bring remarkable economic benefit to enterprises
It should be understood that the technical solutions and concepts of the present invention may be equally replaced or changed by those skilled in the art, and all such changes or substitutions should fall within the protection scope of the appended claims.
Claims (10)
1. A method for automatically filling table data of a relational database is characterized by comprising the following steps:
determining a hierarchical relationship between tables in the relational database according to the SQL file of the relational database;
generating a contact diagram for contacting all the tables according to the hierarchical relationship;
and automatically filling data in all the forms according to the contact diagram.
2. The method of claim 1, wherein the contact graph comprises:
a dictionary structure consisting of key-value pairs; the key is the table name of the table, and the value is the pointer of the table in the relational database;
the method comprises the following steps of (1) calling a csv table name, wherein the csv table name is a table containing real data; and
an ID table name containing only table names of sub-table IDs.
3. The method according to claim 2, wherein determining the hierarchical relationship between tables in the relational database according to the SQL file of the relational database comprises:
analyzing and generating a corresponding SQL file when the relational database is generated by utilizing an initialization function;
obtaining the hierarchical relationship of all tables in the relational database;
generating corresponding parent relation variables and child relation variables according to the hierarchical relation; and the parent relation variable is an outermost table name list.
4. The method according to claim 3, wherein generating a contact graph for contacting all the tables according to the hierarchical relationship includes;
searching a statement starting from alter in the SQL file;
determining a table referenced after the statement as a parent table of the statement;
repeatedly executing the searching and determining steps to obtain branch information of each statement;
according to the branch information, the branches of each table node are correspondingly connected with the parent table one by one, and the parent relation variable and the child relation variable are generated simultaneously;
searching fields and data types of all tables, and simultaneously generating csv table names and table names only containing sub-table IDs;
and sequentially writing the parent relation variable and the child relation variable into corresponding tables in the relational database.
5. The method according to claim 4, wherein automatically populating all forms with data according to the contact graph includes:
reading the SQL file corresponding to the relational database, and comparing each read table name with the csv table name and the ID table name;
when the table name belongs to the csv table name, filling all field names except the ID field into the csv table;
identifying a field containing real data in the csv table name;
generating corresponding test data according to the data type of the real data;
adding the test data to the data of the relation graph of the table to form a record;
and performing automatic batch form filling according to the record.
6. An automatic table data filling device for relational databases, comprising:
the data analysis module is used for determining the hierarchical relationship among the tables in the relational database according to the SQL file of the relational database; generating a contact diagram for contacting all the tables according to the hierarchical relationship;
and the csv generation module is used for automatically filling data in all the forms according to the contact diagram.
7. The apparatus according to claim 6, wherein the data analysis module is specifically configured to analyze, by using an initialization function, a SQL file corresponding to the generation of the relational database; obtaining the hierarchical relationship of all tables in the relational database; generating corresponding parent relation variables and child relation variables according to the hierarchical relation; and the parent relation variable is an outermost table name list.
8. The apparatus of claim 6, wherein the contact map comprises: a dictionary structure consisting of key-value pairs; the key is the table name of the table, and the value is the pointer of the table in the relational database; the method comprises the following steps of (1) calling a csv table name, wherein the csv table name is a table containing real data; and an ID table name containing only table names of the sub-table IDs.
9. The apparatus according to claim 8, wherein the initialization function is specifically configured to: searching a statement starting from alter in the SQL file; determining a table referenced after the statement as a parent table of the statement; repeatedly executing the searching and determining steps to obtain branch information of each statement; according to the branch information, the branches of each table node are correspondingly connected with the parent table one by one, and the parent relation variable and the child relation variable are generated simultaneously; searching fields and data types of all tables, and simultaneously generating csv table names and table names only containing sub-table IDs; and sequentially writing the parent relation variable and the child relation variable into corresponding tables in the relational database.
10. The apparatus of claim 9, wherein the csv generation module is specifically configured to: reading the SQL file corresponding to the relational database, and comparing each read table name with the csv table name and the ID table name; when the table name belongs to the csv table name, filling all field names except the ID field into the csv table; identifying a field containing real data in the csv table name; generating corresponding test data according to the data type of the real data; adding the test data to the data of the relation graph of the table to form a record; and performing automatic table filling in batches according to the records.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810584702.7A CN110647588A (en) | 2018-06-08 | 2018-06-08 | Universal algorithm for automatically filling all forms in any complex relation data model and automatically testing big data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810584702.7A CN110647588A (en) | 2018-06-08 | 2018-06-08 | Universal algorithm for automatically filling all forms in any complex relation data model and automatically testing big data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110647588A true CN110647588A (en) | 2020-01-03 |
Family
ID=69008602
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810584702.7A Pending CN110647588A (en) | 2018-06-08 | 2018-06-08 | Universal algorithm for automatically filling all forms in any complex relation data model and automatically testing big data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110647588A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111309726A (en) * | 2020-01-17 | 2020-06-19 | 北京明略软件系统有限公司 | Directed graph generation method and device and readable storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101379463A (en) * | 2005-12-20 | 2009-03-04 | 贝克曼库尔特公司 | Adaptable database system |
| CN102831245A (en) * | 2012-09-17 | 2012-12-19 | 洛阳翔霏机电科技有限责任公司 | Real-time data storage and reading method of relational database |
| CN105224597A (en) * | 2015-08-28 | 2016-01-06 | 上海斐讯数据通信技术有限公司 | A kind of can by the system and method for the foreign key relationship synthetic image in database |
| CN106227892A (en) * | 2016-08-24 | 2016-12-14 | 深圳市卓讯信息技术有限公司 | A kind of intellectual analysis database table relation generates the method and device of E R figure |
| CN106462643A (en) * | 2014-06-27 | 2017-02-22 | 微软技术许可有限责任公司 | Rule-based joining of foreign to primary key |
-
2018
- 2018-06-08 CN CN201810584702.7A patent/CN110647588A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101379463A (en) * | 2005-12-20 | 2009-03-04 | 贝克曼库尔特公司 | Adaptable database system |
| CN102831245A (en) * | 2012-09-17 | 2012-12-19 | 洛阳翔霏机电科技有限责任公司 | Real-time data storage and reading method of relational database |
| CN106462643A (en) * | 2014-06-27 | 2017-02-22 | 微软技术许可有限责任公司 | Rule-based joining of foreign to primary key |
| CN105224597A (en) * | 2015-08-28 | 2016-01-06 | 上海斐讯数据通信技术有限公司 | A kind of can by the system and method for the foreign key relationship synthetic image in database |
| CN106227892A (en) * | 2016-08-24 | 2016-12-14 | 深圳市卓讯信息技术有限公司 | A kind of intellectual analysis database table relation generates the method and device of E R figure |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111309726A (en) * | 2020-01-17 | 2020-06-19 | 北京明略软件系统有限公司 | Directed graph generation method and device and readable storage medium |
| CN111309726B (en) * | 2020-01-17 | 2024-03-22 | 北京明略软件系统有限公司 | Directed graph generation method, directed graph generation device and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8150674B2 (en) | Automated testing platform for event driven systems | |
| CN109271326B (en) | Cloud database testing method and device, equipment and storage medium thereof | |
| US7933932B2 (en) | Statistics based database population | |
| Pröll et al. | Scalable data citation in dynamic, large databases: Model and reference implementation | |
| CN106326122A (en) | Software unit test case management system | |
| CN107665171A (en) | Automatic regression test method and device | |
| CN110275861B (en) | Data storage method and device, storage medium and electronic device | |
| WO2007136959A2 (en) | Apparatus and method for recursively rationalizing data source queries | |
| US11386086B2 (en) | Permutation-based machine learning for database query optimization | |
| CN110019116B (en) | Data tracing method, device, data processing equipment and computer storage medium | |
| CN112328499A (en) | Test data generation method, device, equipment and medium | |
| CN117150050A (en) | Knowledge graph construction method and system based on large language model | |
| CN107491558A (en) | Metadata updates method and device | |
| CN110647588A (en) | Universal algorithm for automatically filling all forms in any complex relation data model and automatically testing big data | |
| CN114676961A (en) | Enterprise external migration risk prediction method and device and computer readable storage medium | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN110147313A (en) | A kind of log-output method and device | |
| CN111352824B (en) | Test method and device and computer equipment | |
| CN113791980A (en) | Test case conversion analysis method, device, equipment and storage medium | |
| CN116795723B (en) | Chain unit test processing method and device and computer equipment | |
| CN111666286A (en) | Method and device for detecting sub-warehouse and sub-table, computer equipment and storage medium | |
| CN116737698B (en) | Distributed database configuration comparison method, device, equipment and storage medium | |
| US20230141506A1 (en) | Pre-constructed query recommendations for data analytics | |
| WO2023125059A1 (en) | Failure data acquisition method, failure handling method, electronic device, and storage medium | |
| CN115687512A (en) | Risk data processing method, apparatus, device, medium, and computer program product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200103 |
|
| WD01 | Invention patent application deemed withdrawn after publication |