Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data origin collection method of relational databases

A data origin and database technology, applied in the field of data management, can solve problems such as the inability to obtain the source of query results, the inability of the database system to provide, and the failure to solve the problem of data origin

Active Publication Date: 2016-08-31
SOUTH CHINA UNIV OF TECH
View PDF3 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Traditional relational database management systems mainly provide efficient query, insert, delete, and update methods, but do not solve the problem of data origin, so the source of query results cannot be obtained
When users analyze the query results in the database, they sometimes need to track key data or questionable data, query the original source table and the data processing process that acts on the source table, and the existing database system cannot provide this Function

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
  • Data origin collection method of relational databases
  • Data origin collection method of relational databases
  • Data origin collection method of relational databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be further described in detail below in conjunction with the drawings and specific embodiments.

[0050] figure 1 It is a flow chart of an embodiment of a method for collecting data originating from a relational database according to the present invention, such as figure 1 As shown, this embodiment includes:

[0051] Step 101: Define a data origin model according to relational database data origin semantics.

[0052] Step 102: Parse the received SQL statement to generate an abstract syntax tree.

[0053] Step 103: Traversing the abstract syntax tree to extract the source table, target table, and logical operation operators.

[0054]Step 104: According to the data origin model, make a structural description of the source table, target table, and logical operation operators to g...

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 data origin collection method of relational databases. The method comprises following steps: defining a data original model based on SQL data flow origin semantics; analyzing SQL sentences to generate an abstract syntax tree; browsing the abstract syntax tree to extract source lists, target lists and logic operators; and making structural descriptions of source lists, target lists and logic operator based on the data origin model to generate origin information metadata. The data origin collection method of relational databases has following beneficial effects: data-processing logic in SOL scripts can be described by data conversion graphs and attribute mapping graphs such that a data origin analysis function and a field affecting and analyzing function can be provided for a relation database system; data scripts can be analyzed; and the relationship between data tracing and analysis of data can be achieved based on analysis information.

Description

technical field [0001] The invention relates to the technical field of data management, in particular to a data origin collection method of a relational database. Background technique [0002] With the development of the information society, the storage capacity and scale of data continue to grow, and more and more information is digitized. In the face of massive data, it becomes very difficult to identify data sources and evaluate data quality. Data sources and identification methods pose a huge challenge to data management. Therefore, research on data origins emerges as the times require. [0003] Data provenance refers to the origin of the data and its processing history during its lifecycle. Traditional relational database management systems mainly provide efficient query, insert, delete, and update methods, but do not solve the problem of data origin, so the source of query results cannot be obtained. When users analyze the query results in the database, they sometime...

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): G06F17/30
CPCG06F16/2246G06F16/284
Inventor 汤德佑周忠林悦邦
Owner SOUTH CHINA UNIV OF TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products