Heterogeneous database compatibility method and system, electronic device, storage medium

CN118210774BActive Publication Date: 2026-11-03PING AN TECH (SHENZHEN) CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202410119186.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-01-26
Publication Date
2026-11-03
Estimated Expiration
2044-01-26

AI Technical Summary

Technical Problem

Traditional database migration tools require modifications to the upper-layer application program and incur high user learning costs during heterogeneous database migration, resulting in high maintenance and operation costs.

Method used

By acquiring the type and grammar data of the source database, the target parser is selected using candidate lexical and grammar parsers, and lexical and grammar parsing is performed. The grammar nodes are executed directly in the target database, thus achieving compatibility with heterogeneous databases.

Benefits of technology

Without the need for migration tools, the cost of modifying upper-layer applications and the learning cost for users are reduced, thereby lowering the maintenance and operation costs for enterprises.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118210774B_ABST
    Figure CN118210774B_ABST
Patent Text Reader

Abstract

The embodiment of the application provides a heterogeneous database compatible method and system, electronic equipment and storage medium, and belongs to the fields of databases and finance. The method comprises the following steps: obtaining the database type of the source database to obtain an original database type; receiving original database syntax data exported by the source database; screening a target lexical parser from the candidate lexical parsers according to the original database type, and screening the target syntax parser from the candidate syntax parsers according to the original database type; performing lexical analysis on the original database syntax data based on the target lexical parser to obtain lexical tags; performing syntax analysis on the lexical tags based on the target syntax parser to obtain a target syntax node; and executing the target syntax node based on the target executive module. The embodiment of the application can realize the compatibility of heterogeneous databases without the aid of a migration tool, and can reduce the migration and modification cost and learning cost of an upper-layer application.
Need to check novelty before this filing date? Find Prior Art

Citation Information

Patent Citations

  • Database grammar compatible system and implementation method

    CN114138822A

  • Data processing method and device, equipment and medium

    CN116483850A