Method, device and electronic equipment for field bloodline analysis based on SQL
By standardizing and preprocessing the SQL text, the problem of low accuracy in SQL parsing results was solved, and more accurate field lineage analysis was achieved.
CN115934757BActive Publication Date: 2026-06-16DIGITAL ZHEJIANG TECH OPERATION CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- DIGITAL ZHEJIANG TECH OPERATION CO LTD
- Filing Date
- 2022-12-01
- Publication Date
- 2026-06-16
AI Technical Summary
⚠Technical Problem
Existing technologies for data lineage analysis using SQL suffer from low accuracy, especially when encountering code with asterisks, which can lead to missing lineage relationships and results that may not match reality.
⚗Method used
By performing standardized preprocessing on the original SQL text, including basic formatting, asterisk removal, and target field replacement, standardized SQL text is generated. It is then parsed based on an abstract syntax tree, and combined with program logic judgment and testing, the field lineage data is output.
🎯Benefits of technology
It improves the accuracy of SQL parsing results, ensures that the parsing results match the actual data, and outputs more granular field lineage data.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN115934757B_ABST
Abstract
The application provides a method and device for field blood relationship analysis based on SQL and electronic equipment, and relates to the technical field of data processing, which comprises the following steps: performing standardization preprocessing on the original SQL text obtained in advance to generate a standardized SQL text; the standardization preprocessing comprises the following steps: basic format processing, asterisk processing and target field replacement; the standardized SQL text is parsed, and field blood relationship data is output according to the parsing result; the field blood relationship data comprises the following: field Chinese name, field English name and field type. Through the method, the problem of low accuracy of the parsing result in the existing data blood relationship analysis technology based on SQL can be solved, and the technical effect of improving the accuracy is achieved.
Need to check novelty before this filing date? Find Prior Art