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

Method for maintaining association relationship of data tables, computing device and storage medium

A data table association and association relationship technology, applied in the database field, can solve problems such as complex implementation methods, and achieve the effect of simple implementation methods and reduced dependencies

Pending Publication Date: 2020-04-03
CHEZHI HULIAN BEIJING SCI & TECH CO LTD
View PDF11 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] As the application of the database becomes more and more extensive, there will be such a problem in the data query of the database: when storing a large amount of data, the data is usually split and stored in multiple database tables, and the relationship between the data tables is determined in the form of foreign keys. connection relation
[0003] The existing solution is to know the association relationship through the development document. When querying multiple data tables, the operator needs to check the development document to determine the association information between the data tables. The implementation method is relatively complicated.

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 for maintaining association relationship of data tables, computing device and storage medium
  • Method for maintaining association relationship of data tables, computing device and storage medium
  • Method for maintaining association relationship of data tables, computing device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0031] figure 1 is a structural block diagram of a computing device 100 according to an exemplary embodiment of the present invention. A method 200 for maintaining data table association relationship according to the present invention can be executed in the computing device 100 . In a basic configuration 102 , computing device 100 typically includes system memory 106 and one or more processors 104 . A memory bus 108 may be used f...

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 invention discloses a method for maintaining an association relationship of data tables, a computing device and a storage medium. The computing device can access a log file of a database and can store an association relationship table, each record of the association relationship table represents an association relationship between fields of different data tables in the database, and the methodcomprises the steps of extracting an association query statement from the log file; obtaining an association relationship between the fields of the two queried data tables from the association querystatement; and updating the association relationship table according to the obtained association relationship.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method for maintaining the association relationship of data tables, a computing device and a storage medium. Background technique [0002] As the application of the database becomes more and more extensive, there will be such a problem in the data query of the database: when storing a large amount of data, the data is usually split and stored in multiple database tables, and the relationship between the data tables is determined in the form of foreign keys. connection relation. In the process of data analysis and extraction, operators need to obtain the association relationship between data tables. [0003] The existing solution is to know the association relationship through the development document. When querying multiple data tables, the operator needs to check the development document to determine the association information between the data tables. The implementation method is re...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/242
CPCG06F16/2282G06F16/2425
Inventor 陈安琪刘标邱泽成林泽中
Owner CHEZHI HULIAN BEIJING SCI & TECH CO LTD