Supercharge Your Innovation With Domain-Expert AI Agents!

SQL statement analysis method and system, computer equipment and storage medium

A parsing method and sentence technology, applied in the field of data processing, can solve problems such as enlarging the scope of metadata and data information leakage

Active Publication Date: 2021-01-22
PING AN TECH (SHENZHEN) CO LTD
View PDF7 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, it may cause unnecessary data information leakage. In scenarios where data security is more sensitive, the data dictionary enlarges the range of metadata that can be accessed during the SQL parsing process, posing certain security risks.

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
  • SQL statement analysis method and system, computer equipment and storage medium
  • SQL statement analysis method and system, computer equipment and storage medium
  • SQL statement analysis method and system, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0045] It can be understood that the terms "first", "second" and the like used in this application may be used to describe various elements herein, but these elements are not limited by these terms. These terms are only used to distinguish one element from another element.

[0046] figure 1 It is an implementation environment diagram of the SQL statement parsing method based on data lineage provided in one embodiment, such as figure 1 As shown, in this implementation environment, a computer device 110 and a display device 120 are included.

[0047] The computer device 110 may be a computer devic...

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 provides an SQL statement analysis method and system, computer equipment and a storage medium. The method comprises steps of obtaining a directed acyclic graph, and obtaining the directed acyclic graph through carding of SQL statements; traversing the graph layers with SQL sub-queries of the directed acyclic graph, obtaining the graph layer with the substitute character, and taking the graph layer with the substitute character appearing first during traversal as the current layer; acquiring a field corresponding to the substitute character in the current layer according to the field of the previous layer of the current layer; and continuing to obtain the remaining layers with the substitutors, and performing replacement till all the substitutors in the directed acyclic graphare analyzed. Therefore, when the SQL statement parsing method is adopted in an SQL-based data blood relationship analysis software tool or system, interaction with database software is not needed, additional metadata does not need to be accessed, security of metadata of a user can be guaranteed as much as possible, and the metadata information which does not appear in related SQL cannot be exposed due to data blood relationship parsing. Meanwhile, the invention also relates to a blockchain technology.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to an SQL statement parsing method, system, computer equipment and storage medium. Background technique [0002] As an important asset of an enterprise, data needs to be managed, maintained, and used through data governance. As an important part of data governance, data blood relationship analyzes the source and destination of data through the SQL statements used in the data processing process, providing data Governance provides an important data base for other efforts. The SQL statements used in data lineage analysis can be divided into original SQL statements and SQL statements converted by the database system. [0003] The method uses the original SQL statement for analysis. Compared with the SQL statement converted by the database software, the original SQL basically has no dependence on the database software, which reduces the complexity of the data lineage analysis sy...

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/242G06F8/41
CPCG06F8/425G06F8/427G06F16/2433
Inventor 陈玉张茜凌海挺杜均
Owner PING AN TECH (SHENZHEN) CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com