Method and device for generating mapping document based on SQL script, medium and product

By parsing SQL scripts to generate abstract syntax trees and extracting information, mapping documents are automatically generated, solving the problems of time-consuming, labor-intensive, and inaccurate mapping document generation in existing technologies, and achieving efficient and accurate mapping document generation and updating.

CN121434239APending Publication Date: 2026-01-30CHINA CONSTRUCTION BANK +1
View PDF 0 Cites -1 Cited by

Patent Information

Application Number
CN202511514530.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-10-22
Publication Date
2026-01-30

Smart Images

  • Figure CN121434239A_ABST
    Figure CN121434239A_ABST
Patent Text Reader

Abstract

The invention discloses a method and equipment for generating a mapping document based on an SQL script, a medium and a product. The invention relates to the technical field of databases. The method comprises the following steps: parsing a to-be-parsed SQL script to obtain at least one abstract syntax tree associated with the to-be-parsed SQL script; for at least one abstract syntax tree, performing information extraction on at least one syntax sub-tree in the abstract syntax tree according to the data processing type of the abstract syntax tree to obtain to-be-used information corresponding to the abstract syntax tree; and determining a mapping document corresponding to the to-be-analyzed SQL script according to the to-be-used information corresponding to the at least one abstract syntax tree. According to the technical scheme, the efficiency and the accuracy of generating the mapping document are improved, and the real-time performance and the accuracy of the mapping document are ensured.
Need to check novelty before this filing date? Find Prior Art