SQL dialect conversion method, device, system and storage medium

CN114764558BActive Publication Date: 2025-04-15JINGDONG TECH HLDG CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202110051745.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-01-14
Publication Date
2025-04-15
Estimated Expiration
2041-01-14

AI Technical Summary

Technical Problem

When implementing SQL language conversion between different database types in the prior art, there are problems with SQL language compatibility, lack of custom mapping functions, high maintenance costs and charging problems.

Method used

By obtaining the SQL dialect to be converted and its configuration information, a syntax analysis model is analyzed and generated, and processing it based on the configuration information, the target SQL dialect generation is achieved. This method does not require compatibility code and supports custom field, function and table name mapping, reducing database maintenance costs.

Benefits of technology

It realizes SQL language conversion between different database types, reduces database maintenance costs, supports custom mapping, isolates the code development work of development engineers and database engineers, and reduces the cost of database table upgrade and optimization.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114764558B_ABST
    Figure CN114764558B_ABST
Patent Text Reader

Abstract

The embodiment of the present invention relates to a method, device, system and storage medium for converting SQL dialects. The method includes: obtaining a SQL dialect to be converted and configuration information corresponding to the SQL dialect to be converted; parsing the SQL dialect to be converted to generate a first syntax parsing model; processing the first syntax parsing model according to the configuration information to obtain a second syntax parsing model; generating a target SQL dialect according to the configuration information and the second syntax parsing model. In this process, there is no need to write business code for SQL languages ​​compatible with different databases. There is no need to convert the SQL dialect to be converted into a specific SQL language, which greatly reduces the database maintenance script and other development costs.
Need to check novelty before this filing date? Find Prior Art

Citation Information

Patent Citations

  • Language conversion method and device, storage medium and data query system and method

    CN108710662A