Method and system for realizing compatibility of heterogeneous database reserved words based on driver layer

Abstract

The invention discloses a method for realizing compatibility of heterogeneous database reserved words. In the method, a reserved word configuration file which belongs to a target database but does not belong to any source database is loaded and stored in a driver layer. The method comprises the following specific steps of: implementing an SQL (Structured Query Language) sentence through an application program; analyzing the SQL language sentence by using the driver layer to generate a semantic grammar tree; performing reserved word identification on an object in the grammar tree according the reserved word configuration file, and marking reserved words by adopting reserved word signs in a target database; generating a new SQL sentence according to the grammar tree in which the reserved words are marked; and transmitting the new SQL sentence to the target database. The invention further provides a system for implementing the method. Due to the adoption of the method, the aim of transplanting from a source database to different heterogeneous databases can be fulfilled without changing an application program code; and compared with compatible support of the conventional server layer, the method has the advantages of the technical characteristics of easiness and flexibility due to support of compatibility in the driver layer, and the system risk and transplanting cost are lowered.

Description

technical field [0001] The invention belongs to the technical field of databases in computers, and in particular relates to a heterogeneous database reserved word compatibility method and system based on a driver layer, which is used for transplantation services across heterogeneous databases. Background technique [0002] The field of database compatibility for applications is very common in the current large number of existing old information system upgrade projects. In these projects, developers require domestic database manufacturers to ensure that the application does not change a line of code, so as to realize the transplantation from the old database to the new database of other manufacturers. However, because foreign database manufacturers have stable market scope in their respective markets, there is no strong product demand in the field of heterogeneous database product compatibility. DB2 has only started to take the route of Oracle compatibility in the past two ye...

AI Technical Summary

Problems solved by technology

[0003] At present, many domestic database manufacturers cannot solve the problem of compatibility of reserved words without changing a line of code in the application program. One of the reasons is that the names of some database objects in the application system are reserved words in the database. Without changing the object name, you must add double quotation marks to the reserved word object name to appear as a delimited identifier, but this requires code modification, so whether you add quotation marks or change the object name, you cannot avoid changing the application code

Images