Unlock instant, AI-driven research and patent intelligence for your innovation.

Method, device and equipment for generating data relational model

A relational model and data relationship technology, applied in the computer field, can solve problems such as the inability to sort out data tables, the inability to obtain data table relationships, and the inability to perform cross-database operations.

Active Publication Date: 2020-09-15
ADVANCED NEW TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, since the join statement can only operate on one database, it cannot perform cross-database operations. Therefore, through the analysis of the join statement, only the relationship between the data tables of one database can be obtained, but all the databases corresponding to the business system cannot be obtained. The relationship between the data tables of the business system, it can be seen that the related technology cannot realize the combing of the relationship between the data tables of all databases in the business system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method, device and equipment for generating data relational model
  • Method, device and equipment for generating data relational model
  • Method, device and equipment for generating data relational model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] Such as figure 1 As shown, the present application provides an embodiment of a method for generating a data relationship model, so as to sort out the relationships between data tables of all databases in the business system. This application can obtain the second relational model of multiple databases of the business system through the operation information of cross-database operations on each database of the business system, and the first relational model of each database of the business system, so that based on the obtained second The relationship model is used to sort out the relationship between the data tables of all databases in the business system. The method specifically includes the following steps:

[0034] In step S101: generate the first relational model of each database of the business system according to the operation information of the internal operation of each database of the business system; wherein, the first relational model of the database is used ...

Embodiment 2

[0072] Such as Figure 5 As shown, the present application provides another embodiment of a method for generating a data relationship model, so as to sort out the relationships between data tables of all databases in the business system. This application can obtain the second relational model of multiple databases of the business system through the log files generated by the operation information of the cross-database operation of the business system, and the first relational model of each database of the business system, so that based on the obtained second The relationship model is used to sort out the relationship between the data tables of all databases in the business system. The method specifically includes the following steps:

[0073] In step S501 : generating first log files corresponding to each database of the business system according to the operation information of internal operations on each database of the business system.

[0074] In this embodiment, the abov...

Embodiment 3

[0101] The above is the method for generating a data relationship model provided by the embodiment of the present application. Based on the same idea, the embodiment of the present application also provides an embodiment of a device for generating a data relationship model, such as Image 6 Shown:

[0102] The device for generating the data relationship model includes: a first generating module 610 and a second generating module 620, wherein:

[0103] The first generation module 610 is configured to generate the first relational model of each database of the business system according to the operation information of the internal operation of each database of the business system; wherein, the first relational model of the database is used to represent The association relationship between the data tables in the database;

[0104] The second generating module 620 is configured to generate a second relational model of multiple databases of the business system according to the oper...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a method, a device and equipment for generating a data relationship model. The method comprises the steps of separately generating a first relationship model of each database of a service system according to operating information for carrying out an internal operation on each database of the service system; and generating a second relationship model of the plurality of databases of the service system according to operating information for carrying out a cross-database operation on each database of the service system and the first relationship model of each database. Because the relation between data tables of all databases of the service system can be determined through the embodiment, organization for the relation between the data tables of all databases of the service system can be achieved.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a method, device and equipment for generating a data relational model. Background technique [0002] In order to meet the diverse needs of users, the number of services providing different functions is also increasing. Among them, some services that provide different functions can come from different departments of the same company. For example, in order to meet the needs of users to deal with idle items, the first department of company A can provide the business of selling idle items; The second department of company A can provide the business of buying second-hand goods. [0003] Although these businesses that provide different functions come from different departments of the same company, these businesses can share one or several databases. When a department purchases second-hand items, it is possible to register a user name and use that user name to purchase...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F16/22G06F16/28
CPCG06F16/212G06F16/22G06F16/288
Inventor 周鹏举
Owner ADVANCED NEW TECH CO LTD