CN111563131A - Database entity relation generation method and device, computer equipment and storage medium - Google Patents
Database entity relation generation method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111563131A CN111563131A CN202010263356.XA CN202010263356A CN111563131A CN 111563131 A CN111563131 A CN 111563131A CN 202010263356 A CN202010263356 A CN 202010263356A CN 111563131 A CN111563131 A CN 111563131A
- Authority
- CN
- China
- Prior art keywords
- database
- analyzed
- query statement
- project code
- code file
- 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
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000004458 analytical method Methods 0.000 claims description 31
- 238000000605 extraction Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 20
- 239000000284 extract Substances 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 4
- 230000014509 gene expression Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 238000013523 data management Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database entity relation generation method, a device, computer equipment and a computer readable storage medium, wherein the method comprises the following steps: acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file; analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed; analyzing the target query statement to acquire the association relation information between the entities of the database to be analyzed; and generating a relation graph between the database entities to be analyzed according to the association relation information. The invention extracts the relation between the database entities to be analyzed through analyzing the codes, thereby reducing the workload and avoiding omission, and finally presenting the association relation in a graph form, thereby being capable of integrally grasping the association relation between the database entities to be analyzed and reducing the difficulty of understanding the integral system.
Description
Technical Field
The present invention relates to the field of technologies, and in particular, to a database entity relationship generation method, apparatus, computer device, and storage medium.
Background
As systems (e.g., e-commerce systems, information systems, etc.) evolve, the systems become more complex and difficult to understand as a whole. For example, the number of database tables is thousands, and it is difficult to understand the relationship between them. And at present, when the e-commerce system builds a database table structure, a foreign key is not usually used, so that the relationship between the table and the table is not solidified into the database. Along with the evolution of items, more and more database tables are provided, and the relationships between tables are more and more complex, especially for some large-scale items, the relationships between tables are difficult to be clarified after years of evolution, so that the system is difficult to be understood integrally. If the relationship between the tables is maintained manually, not only the workload is large, but also omission is possible,
therefore, it is desirable to provide a new method for generating database entity relationships to solve the above problems.
Disclosure of Invention
In order to solve the problems in the prior art, embodiments of the present invention provide a method and an apparatus for generating a database entity relationship, a computer device, and a storage medium, so as to overcome the problems in the prior art that the workload of manually maintaining the association relationship between database entities is large, and omission occurs easily.
In order to solve one or more technical problems, the invention adopts the technical scheme that:
in a first aspect, a database entity relationship generation method is provided, which includes the following steps:
acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file;
analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed;
analyzing the target query statement to acquire the incidence relation information between the database entities to be analyzed;
and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
Further, the obtaining of the project code file corresponding to the database entity to be analyzed and the extracting of the query statement from the project code file include:
reading a project code file corresponding to a database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and analyzing the project code file, and extracting the query statement in the project code file according to the analysis result.
Further, the analyzing the target query statement to obtain the association relationship information between the database entities to be analyzed includes:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
Further, before generating the relationship graph between the database entities to be analyzed according to the association relationship information, the method further includes:
and carrying out duplicate removal processing on the incidence relation information by using a preset analysis tool.
In a second aspect, an apparatus for generating database entity relationships is provided, the apparatus comprising:
the system comprises a first extraction module, a second extraction module and a third extraction module, wherein the first extraction module is used for acquiring a project code file corresponding to a database entity to be analyzed and extracting a query statement from the project code file;
the second extraction module is used for analyzing the query statement and extracting a plurality of target query statements related to the database entity to be analyzed;
the information acquisition module is used for analyzing the target query statement and acquiring the incidence relation information between the entities of the database to be analyzed;
and the relationship generation module is used for generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
Further, the first extraction module comprises:
the code reading unit is used for reading a project code file corresponding to the database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and the statement extraction unit is used for analyzing the project code file and extracting the query statement in the project code file according to the analysis result.
Further, the information obtaining module is specifically configured to:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
Further, the apparatus further comprises:
and the relationship duplication eliminating module is used for utilizing a preset analysis tool to conduct duplication eliminating processing on the incidence relationship information.
In a third aspect, a computer device is provided, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and when the processor executes the computer program, the following steps are implemented:
acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file;
analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed;
analyzing the target query statement to acquire the incidence relation information between the database entities to be analyzed;
and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
In a fourth aspect, there is provided a computer readable storage medium having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file;
analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed;
analyzing the target query statement to acquire the incidence relation information between the database entities to be analyzed;
and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
The technical scheme provided by the embodiment of the invention has the following beneficial effects:
the embodiment of the invention provides a database entity relationship generation method, a database entity relationship generation device, computer equipment and a storage medium, by obtaining the project code file corresponding to the database entity to be analyzed, extracting the query sentence from the project code file, analyzing the query sentence to extract a plurality of target query sentences related to the database entity to be analyzed, analyzing the target query statement to obtain the incidence relation information among the database entities to be analyzed, generating a relation graph among the database entities to be analyzed according to the incidence relation information, namely, the relation between the database entities to be analyzed is extracted through analyzing the codes, the workload is reduced greatly, omission is avoided, and finally the association relation is presented in a graph form, therefore, the incidence relation among the database entities to be analyzed can be integrally grasped, and the difficulty in understanding the whole system is reduced.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a flow diagram illustrating a database entity relationship generation method in accordance with an illustrative embodiment;
FIG. 2 is a schematic block diagram illustrating an arrangement of a database entity relationship generation apparatus in accordance with an illustrative embodiment;
FIG. 3 is a schematic diagram illustrating an internal architecture of a computer device, according to an example embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The database entity is different data management objects set for facilitating data management in the database management system, such as database tables, views, storage processes, and the like. In a broad sense, the data stored in these objects are also database entities, as they are also the exact entities that exist. Database entity relationships are used to represent the association of database entities with entities.
FIG. 1 is a flowchart illustrating a database entity relationship generation method according to an exemplary embodiment, and referring to FIG. 1, the method includes the following steps:
s1: and acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file.
Specifically, taking a database entity as a database table as an example, usually, the item code has a table-table relationship therein, and we only need to analyze the item code to extract the table-table relationship from the item code and finally present the table-table relationship, so that we can grasp the table-table association relationship integrally, thereby reducing the difficulty in understanding the whole system and reducing the workload. The query statement is a database query and programming language, and is used for accessing data, querying, updating, managing a database system, and the like. Therefore, in the embodiment of the present invention, the project code files corresponding to the database entities to be analyzed are first obtained, and then query statements (such as SQL statements) are extracted from each project code file.
S2: and analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed.
Specifically, the query statement is analyzed, then the generated analysis result is analyzed, and a query statement meeting the condition is extracted from the analysis result to serve as a target query statement, for example, the query statement not meeting the condition is filtered by using a pre-configured matching model, and only the query statement meeting the condition is retained. Wherein the query statement meeting the condition comprises a plurality of query statements associated with the database entity to be analyzed. In particular implementations, open-source query statement analysis tools, such as alibaba/druid, may be used.
S3: and analyzing the target query statement to acquire the association relation information between the database entities to be analyzed.
Specifically, as a preferred embodiment, the extracting of the target query statement in the above steps and analyzing the target query statement to obtain the association relationship information between the database entities to be analyzed includes: traversing all the extracted target query sentences, standardizing the target query sentences in a preset expression mode and the like, filtering and replacing special characters in the target query sentences to obtain standardized target query sentences, analyzing the standardized target query sentences by adopting a preset analysis tool, analyzing expressions in all blocks of the standardized target query sentences, analyzing whether incidence relations between database entities exist on two sides of the expressions, and if so, extracting incidence relation information.
S4: and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
Specifically, as a preferred implementation manner, in the embodiment of the present invention, the association relationship information obtained in the above steps is imported into a Neo4j image database, and a relationship diagram between database entities to be analyzed is generated by using the Neo4j image database. It should be noted here that Neo4j is a high-performance NOSQL graph database that stores structured data on a network rather than in tables. It is an embedded, disk-based Java persistence engine with full transactional properties, but it stores structured data on the network (called a graph mathematically) instead of in tables. Neo4j can also be viewed as a high performance graph engine with all the features of a full database. Programmers work under an object-oriented, flexible network architecture rather than a strict, static table, but at the same time can enjoy all the benefits of a fully transactional, enterprise-level database.
As a better implementation manner, in the embodiment of the present invention, the obtaining a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file includes:
reading a project code file corresponding to a database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and analyzing the project code file, and extracting the query statement in the project code file according to the analysis result.
Specifically, the obtaining of the project code file corresponding to the database entity to be analyzed includes: and acquiring a project code path of a project code file corresponding to the database entity to be analyzed, and reading the project code file corresponding to the database entity to be analyzed according to the project code path by adopting a preset extraction tool. The project code path may be specified in advance or may be actively acquired. Then each project code file is analyzed, and the query statement in the project code file is extracted. The query statement includes, but is not limited to, an SQL statement. When the SQL sentences in the project code files are written by mybatis, the SQL sentences are all in the xml files, and at the moment, the SQL sentences in the query can be extracted by analyzing the xml files.
It should be noted that, in the embodiment of the present invention, the manner of obtaining the query statement is only a preferred example, and the query statement may also be obtained in other manners, for example, by using collection manners such as a monitoring program process and a query database log. Taking SQL sentences as an example, when the query sentences are acquired in a manner of acquiring the logs of the query database, the SQL execution log information of the target database can be retrieved by regularly connecting the target database through administrator information configured by a data source when the query sentences are specifically implemented, and the SQL sentence information of daily business execution is extracted.
As a preferred implementation manner, in an embodiment of the present invention, the to-be-analyzed database entity includes a database table, and the analyzing the target query statement to obtain the association relationship information between the to-be-analyzed database entities includes:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
Specifically, when the database entity to be analyzed is a database table and the association relationship information between the database tables is obtained, the target query statement obtained through the foregoing steps may be analyzed to generate an analysis result, and then the analysis result is analyzed, and the information such as the name of the database table and the name of the association field in the target query statement is extracted as the association relationship information.
Taking SQL statements as an example, the information of the database table can be scanned by using a preconfigured SQL analysis tool and a target query statement to obtain information such as the name and associated field name of the database table. The process of extracting the incidence relation information comprises the following steps:
1. extracting from part: sys _ user u and sys _ org o, and the table name is analyzed: sys _ user, sys _ org, aliases u and o, and corresponding relation;
2. extracting a where part: u.org _ id ═ o.id, the alias is replaced with the table name sys _ user. The set of relationships is found: sys _ user _ org _ id, user _ id 1000001;
3. the relationship group sys _ user _ org _ id that retains two tables is filtered out, i.e., is an association relationship.
As a preferred implementation manner, in the embodiment of the present invention, before generating the relationship graph between the database entities to be analyzed according to the association relationship information, the method further includes:
and carrying out duplicate removal processing on the incidence relation information by using a preset analysis tool.
Specifically, the extracted association relationship information is usually repeated, and if the extracted association relationship information is not processed, the association relationship between the database entities may be unclear due to the repetition of the association relationship, and the relationship diagram between the database entities to be analyzed, which is generated subsequently according to the association relationship, is inaccurate.
Fig. 2 is a schematic structural diagram illustrating a database entity relationship generation apparatus according to an exemplary embodiment, and referring to fig. 2, the apparatus includes:
the system comprises a first extraction module, a second extraction module and a third extraction module, wherein the first extraction module is used for acquiring a project code file corresponding to a database entity to be analyzed and extracting a query statement from the project code file;
the second extraction module is used for analyzing the query statement and extracting a plurality of target query statements related to the database entity to be analyzed;
the information acquisition module is used for analyzing the target query statement and acquiring the incidence relation information between the entities of the database to be analyzed;
and the relationship generation module is used for generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
As a preferred implementation manner, in an embodiment of the present invention, the first extraction module includes:
the code reading unit is used for reading a project code file corresponding to the database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and the statement extraction unit is used for analyzing the project code file and extracting the query statement in the project code file according to the analysis result.
As a preferred implementation manner, in an embodiment of the present invention, the information obtaining module is specifically configured to:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
As a preferred implementation manner, in an embodiment of the present invention, the apparatus further includes:
and the relationship duplication eliminating module is used for utilizing a preset analysis tool to conduct duplication eliminating processing on the incidence relationship information.
Fig. 3 is a schematic diagram illustrating an internal configuration of a computer device according to an exemplary embodiment, which includes a processor, a memory, and a network interface connected through a system bus, as shown in fig. 3. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of optimization of an execution plan.
Those skilled in the art will appreciate that the configuration shown in fig. 3 is a block diagram of only a portion of the configuration associated with aspects of the present invention and is not intended to limit the computing devices to which aspects of the present invention may be applied, and that a particular computing device may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
As a preferred implementation manner, in an embodiment of the present invention, the computer device includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and the processor implements the following steps when executing the computer program:
acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file;
analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed;
analyzing the target query statement to acquire the incidence relation information between the database entities to be analyzed;
and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
As a preferred implementation manner, in the embodiment of the present invention, when the processor executes the computer program, the following steps are further implemented:
reading a project code file corresponding to a database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and analyzing the project code file, and extracting the query statement in the project code file according to the analysis result.
As a preferred implementation manner, in the embodiment of the present invention, when the processor executes the computer program, the following steps are further implemented:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
As a preferred implementation manner, in the embodiment of the present invention, when the processor executes the computer program, the following steps are further implemented:
and carrying out duplicate removal processing on the incidence relation information by using a preset analysis tool.
In an embodiment of the present invention, a computer-readable storage medium is further provided, on which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the following steps:
acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file;
analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed;
analyzing the target query statement to acquire the incidence relation information between the database entities to be analyzed;
and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
As a preferred implementation manner, in the embodiment of the present invention, when executed by the processor, the computer program further implements the following steps:
reading a project code file corresponding to a database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and analyzing the project code file, and extracting the query statement in the project code file according to the analysis result.
As a preferred implementation manner, in the embodiment of the present invention, when executed by the processor, the computer program further implements the following steps:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
As a preferred implementation manner, in the embodiment of the present invention, when executed by the processor, the computer program further implements the following steps:
and carrying out duplicate removal processing on the incidence relation information by using a preset analysis tool.
In summary, the technical solution provided by the embodiment of the present invention has the following beneficial effects:
the embodiment of the invention provides a database entity relationship generation method, a database entity relationship generation device, computer equipment and a storage medium, by obtaining the project code file corresponding to the database entity to be analyzed, extracting the query sentence from the project code file, analyzing the query sentence to extract a plurality of target query sentences related to the database entity to be analyzed, analyzing the target query statement to obtain the incidence relation information among the database entities to be analyzed, generating a relation graph among the database entities to be analyzed according to the incidence relation information, namely, the relation between the database entities to be analyzed is extracted through analyzing the codes, the workload is reduced greatly, omission is avoided, and finally the association relation is presented in a graph form, therefore, the incidence relation among the database entities to be analyzed can be integrally grasped, and the difficulty in understanding the whole system is reduced.
It should be noted that: the database entity relationship generating device provided in the foregoing embodiment is only illustrated by the division of the functional modules when triggering the relationship generating service, and in practical applications, the function distribution may be completed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions described above. In addition, the embodiment of the database entity relationship generation apparatus and the embodiment of the database entity relationship generation method provided in the above embodiments belong to the same concept, that is, the apparatus is based on the database entity relationship generation method, and the specific implementation process thereof is detailed in the method embodiments and will not be described herein again.
It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, where the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1. A database entity relationship generation method, the method comprising the steps of:
acquiring a project code file corresponding to a database entity to be analyzed, and extracting a query statement from the project code file;
analyzing the query statement, and extracting a plurality of target query statements related to the database entity to be analyzed;
analyzing the target query statement to acquire the incidence relation information between the database entities to be analyzed;
and generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
2. The database entity relationship generation method according to claim 1, wherein the obtaining of the project code file corresponding to the database entity to be analyzed and the extracting of the query statement from the project code file include:
reading a project code file corresponding to a database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and analyzing the project code file, and extracting the query statement in the project code file according to the analysis result.
3. The database entity relationship generation method according to claim 1 or 2, wherein the database entities to be analyzed include a database table, and the analyzing the target query statement to obtain the association relationship information between the database entities to be analyzed includes:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
4. The database entity relationship generation method according to claim 1 or 2, wherein before generating the relationship graph between the database entities to be analyzed according to the association relationship information, the method further comprises:
and carrying out duplicate removal processing on the incidence relation information by using a preset analysis tool.
5. An apparatus for database entity relationship generation, the apparatus comprising:
the system comprises a first extraction module, a second extraction module and a third extraction module, wherein the first extraction module is used for acquiring a project code file corresponding to a database entity to be analyzed and extracting a query statement from the project code file;
the second extraction module is used for analyzing the query statement and extracting a plurality of target query statements related to the database entity to be analyzed;
the information acquisition module is used for analyzing the target query statement and acquiring the incidence relation information between the entities of the database to be analyzed;
and the relationship generation module is used for generating a relationship graph between the database entities to be analyzed according to the incidence relationship information.
6. The database entity relationship generation apparatus according to claim 5, wherein the first extraction module comprises:
the code reading unit is used for reading a project code file corresponding to the database entity to be analyzed according to the project code path by adopting a preset extraction tool;
and the statement extraction unit is used for analyzing the project code file and extracting the query statement in the project code file according to the analysis result.
7. The database entity relationship generation apparatus according to claim 5 or 6, wherein the information acquisition module is specifically configured to:
and analyzing the target query statement, extracting at least the name and the associated field name of the database table from an analysis result, and taking the name and the associated field name as the association relation information.
8. The database entity relationship generation apparatus according to claim 5 or 6, wherein the apparatus further comprises:
and the relationship duplication eliminating module is used for utilizing a preset analysis tool to conduct duplication eliminating processing on the incidence relationship information.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 4 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010263356.XA CN111563131A (en) | 2020-04-03 | 2020-04-03 | Database entity relation generation method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010263356.XA CN111563131A (en) | 2020-04-03 | 2020-04-03 | Database entity relation generation method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111563131A true CN111563131A (en) | 2020-08-21 |
Family
ID=72070384
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010263356.XA Pending CN111563131A (en) | 2020-04-03 | 2020-04-03 | Database entity relation generation method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111563131A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112506965A (en) * | 2020-12-03 | 2021-03-16 | 北京天融信网络安全技术有限公司 | Database management device and method |
| CN112597171A (en) * | 2020-12-31 | 2021-04-02 | 平安银行股份有限公司 | Table relation visualization method and device, electronic equipment and storage medium |
| CN113342580A (en) * | 2021-07-06 | 2021-09-03 | 中国工商银行股份有限公司 | Data backup method, device and equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN108304463A (en) * | 2017-12-26 | 2018-07-20 | 中国广核电力股份有限公司 | A kind of data managing method and its database application component for database |
| CN110909016A (en) * | 2019-10-12 | 2020-03-24 | 中国平安财产保险股份有限公司 | Database-based repeated association detection method, device, equipment and storage medium |
-
2020
- 2020-04-03 CN CN202010263356.XA patent/CN111563131A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN108304463A (en) * | 2017-12-26 | 2018-07-20 | 中国广核电力股份有限公司 | A kind of data managing method and its database application component for database |
| CN110909016A (en) * | 2019-10-12 | 2020-03-24 | 中国平安财产保险股份有限公司 | Database-based repeated association detection method, device, equipment and storage medium |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112506965A (en) * | 2020-12-03 | 2021-03-16 | 北京天融信网络安全技术有限公司 | Database management device and method |
| CN112597171A (en) * | 2020-12-31 | 2021-04-02 | 平安银行股份有限公司 | Table relation visualization method and device, electronic equipment and storage medium |
| CN113342580A (en) * | 2021-07-06 | 2021-09-03 | 中国工商银行股份有限公司 | Data backup method, device and equipment |
| CN113342580B (en) * | 2021-07-06 | 2024-02-27 | 中国工商银行股份有限公司 | Data backup method, device and equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
| CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
| CN111563131A (en) | Database entity relation generation method and device, computer equipment and storage medium | |
| CN111324610A (en) | Data synchronization method and device | |
| JP2022118108A (en) | Log auditing method, device, electronic apparatus, medium and computer program | |
| CN111309760A (en) | Data retrieval method, system, device and storage medium | |
| CN112347071B (en) | Power distribution network cloud platform data fusion method and power distribution network cloud platform | |
| CN110688544A (en) | Method, device and storage medium for querying database | |
| CN110737594A (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN115328928B (en) | kudu table updating method, kudu table updating device, kudu table updating equipment and storage medium | |
| CN111221698A (en) | Task data acquisition method and device | |
| CN111443901A (en) | Business expansion method and device based on Java reflection | |
| CN116244387A (en) | Entity relationship construction method, device, electronic equipment and storage medium | |
| CN113138906A (en) | Call chain data acquisition method, device, equipment and storage medium | |
| CN110309206B (en) | Order information acquisition method and system | |
| CN112068981A (en) | Knowledge base-based fault scanning recovery method and system in Linux operating system | |
| CN116303427A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN106802922B (en) | Tracing storage system and method based on object | |
| CN113343036B (en) | Data blood relationship analysis method and system based on key topological structure analysis | |
| US10664501B2 (en) | Deriving and interpreting users collective data asset use across analytic software systems | |
| US11681721B2 (en) | Systems and methods for spark lineage data capture | |
| CN110851437A (en) | Storage method, device and equipment | |
| CN114519071A (en) | Generation method, matching method, system, device and medium of rule matching model | |
| CN115168363B (en) | Metadata processing method and device, electronic equipment and storage medium | |
| CN113553320B (en) | Data quality monitoring method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200821 |
|
| RJ01 | Rejection of invention patent application after publication |