Efficient adaptation method for heterogeneous database advanced object conversion

Abstract

The invention relates to the technical field of heterogeneous database advanced object migration databases, in particular to an efficient adaptation method for heterogeneous database advanced object conversion, which comprises the following steps: S1, compiling lexical and grammar files of a specified database; s2, generating a lexical and grammar analyzer according to the lexical and grammar file by means of a grammar analyzer generation tool; s3, converting the source end high-level object into a specified syntax tree structure according to an analyzer; s4, reading the syntax tree and converting a source end syntax tree structure into an intermediate self-defined high-level object by using a source end mapping interface according to a source end database type; and S5, according to the target end type, using a corresponding target end mapping interface to convert the intermediate self-defined high-level object into a target end high-level object, and the method can effectively solve the problems that when an existing heterogeneous database high-level object conversion adaptation method migrates multiple heterogeneous databases, the high-level object mapping relation is complex, and the workload is large.

Description

Technical Field

[0001] The present invention relates to the technical field of advanced object migration in heterogeneous databases, and specifically to an efficient adaptation method for converting advanced objects in heterogeneous databases. Background Art

[0002] When an enterprise performs advanced object migration in heterogeneous databases, it will map the syntax structures of advanced objects at the source end and the target end one by one (including but not limited to stored procedures, views, functions, triggers, transactions, etc.). However, the existing adaptation methods for converting advanced objects in heterogeneous databases still have deficiencies. Specifically, when the database types at the source end and the target end are few, the adaptation is relatively convenient. But when there are many database types at the source end and the target end, every time a new database type is added at the source end or the target end, it is necessary to perform mapping adaptation on multiple source ends or target ends respectively. The mapping relationship of advanced objects is complex and the workload is large.

[0003] Therefore, an efficient adaptation method for converting advanced objects in heterogeneous databases is needed to solve the problems raised in the above background art. Summary of the Invention

[0004] The purpose of the present invention is to provide an efficient adaptation method for converting advanced objects in heterogeneous databases to solve the problems raised in the above background art.

[0005] To achieve the above purpose, the present invention provides the following technical solutions: An efficient adaptation method for converting advanced objects in heterogeneous databases, comprising the following steps: S1, write the lexical and syntax files for the specified database; S2, generate a lexical and syntax parser according to the lexical and syntax files with the help of a syntax analyzer generation tool; S3, convert the source-end advanced object into a specified syntax tree structure according to the parser; S4, read the syntax tree and convert the source-end syntax tree structure into an intermediate custom advanced object using the source-end mapping interface according to the source-end database type; S5, then convert the intermediate custom advanced object into a target-end advanced object using the corresponding target-end mapping interface according to the target-end type.

[0006] As a preferred solution of the present invention, antlr4 is used to process the.g4 format word / syntax files in S1.

[0007] As a preferred solution of the present invention, the acquisition of the syntax information in the source-end syntax tree in S4 is obtained by traversing according to the listener method of antlr4.

[0008] Compared with the prior art, the beneficial effects of the present invention are: In the present invention, by writing the lexical and syntax files of a specified database, a lexical and syntax parser is generated by means of a syntax analyzer generation tool according to the lexical and syntax files. The source - side high - level object is converted into a specified syntax tree structure according to the parser. The syntax tree is read, and according to the source - side database type, the source - side syntax tree structure is converted into an intermediate custom high - level object using the source - side mapping interface. According to the target - side type, the intermediate custom high - level object is converted into a target - side high - level object using the corresponding target - side mapping interface. The source - side mapping interface is responsible for converting the high - level object on the source side into a custom intermediate syntax structure object. When adding a new source - side database type, only this interface needs to be adapted and implemented. The target - side mapping interface is responsible for converting the custom intermediate syntax structure object into a target - side high - level object. When adding a new target - side database type, this interface also needs to be adapted and implemented. During the conversion of high - level objects, the program only needs to convert the source - side high - level object into an intermediate custom syntax structure object according to the source - side database type, and then convert the intermediate custom syntax structure object into a high - level object that meets the requirements of the target side according to the target - side database type. When adapting to a specific type of database, only the source - side mapping interface or the target - side mapping interface needs to be implemented to seamlessly connect with the existing source - side or target - side database types for high - level object conversion. This reduces the conversion complexity during the high - level object conversion of multiple heterogeneous databases, effectively reduces the adaptation workload, and solves the problems of complex high - level object mapping relationships and large workload during the migration of multiple heterogeneous databases. Brief Description of the Drawings

[0009] Figure 1 It is a structural block diagram of the present invention; Detailed Embodiments

[0010] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work belong to the scope of protection of the present invention.

[0011] To facilitate the understanding of the present invention, the present invention will be described more comprehensively with reference to the relevant drawings. Several embodiments of the present invention are given. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. On the contrary, the purpose of providing these embodiments is to make the disclosure of the present invention more thorough and comprehensive.

[0012] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the technical field to which this invention belongs. The terms used in the description of the present invention herein are for the purpose of describing specific embodiments only and are not intended to limit the present invention. The term "and / or" used herein includes any and all combinations of one or more of the related listed items.

[0013] For the embodiments, please refer to Figure 1 , the present invention provides a technical solution: An efficient adaptation method for high-level object conversion in heterogeneous databases, comprising the following steps: S1, write the lexical and syntax files for the specified database; S2, generate a lexical and syntax parser according to the lexical and syntax files with the help of a syntax parser generation tool; S3, convert the source-side high-level object into a specified syntax tree structure according to the parser; S4, read the syntax tree and convert the source-side syntax tree structure into an intermediate custom high-level object using the source-side mapping interface according to the source-side database type; S5, then convert the intermediate custom high-level object into a target-side high-level object using the corresponding target-side mapping interface according to the target-side type.

[0014] Further, in S1, antlr4 is used to process the.g4 format word / syntax files.

[0015] Further, in S4, the acquisition of the syntax information in the source-side syntax tree is obtained by traversing according to the listener mode of antlr4.

[0016] Use antlr4 to process the.g4 format word / syntax files and write the lexical and syntax files for the specified database; Generate a lexical and syntax parser according to the lexical and syntax files with the help of a syntax parser generation tool; Convert the source-side high-level object into a specified syntax tree structure according to the parser; Read the syntax tree and convert the source-side syntax tree structure into an intermediate custom high-level object using the source-side mapping interface according to the source-side database type. The acquisition of the syntax information in the source-side syntax tree is obtained by traversing according to the listener mode of antlr4; Then convert the intermediate custom high-level object into a target-side high-level object using the corresponding target-side mapping interface according to the target-side type.

[0017] Although embodiments of the present invention have been shown and described, those of ordinary skill in the art will appreciate that various changes, modifications, substitutions and variations can be made to these embodiments without departing from the principles and spirit of the present invention. The scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. An efficient adaptation method for high-level object conversion in heterogeneous databases, characterized in that: The following steps are involved: S1, write the lexical and grammar files of the specified database; S2, using a syntax analyzer generation tool to generate a lexical and grammatical parser based on the lexical and grammatical files; S3, converting the source-side high-level object into a specified syntax tree structure according to the parser; S4, reads the syntax tree and uses the source-side mapping interface to convert the source-side syntax tree structure into an intermediate custom high-level object according to the source-side database type; S5, and then convert the intermediate custom high-level object into a target-side high-level object using the corresponding target-side mapping interface according to the target-side type.

2. The efficient adaptation method for high-level object conversion of heterogeneous databases according to claim 1 is characterized by: In S1, antlr4 is used to process .g4 format word / grammar files.

3. The efficient adaptation method for high-level object conversion of heterogeneous databases according to claim 1 is characterized by: The acquisition of the grammatical information in the source syntax tree in S4 is performed by traversing and acquiring according to the listener method of antlr4.

Images