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

A technology of reserved words and databases, applied in the direction of digital data processing, special data processing applications, program loading/starting, etc., to achieve the effect of improving compatibility, reducing system risks, and reducing transplant costs

Inactive Publication Date: 2013-01-09
WUHAN DAMENG DATABASE
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 dat

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for realizing compatibility of heterogeneous database reserved words based on driver layer
  • Method and system for realizing compatibility of heterogeneous database reserved words based on driver layer

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The present invention will be further described below in conjunction with the drawings and specific embodiments, but the embodiments should not be construed as limiting the present invention.

[0022] The driver layer is a program between the server and the application program, and is used to process the request of the application program before the server, and its specific implementation method is not limited here. A reserved word configuration file is set in the driver layer in advance, and the reserved word configuration file is loaded during the startup process of the driver layer, and the reserved word is conveniently searched quickly. In the driver layer, the reserved word dictionary is defined as a HASH table, and the reserved words are used as elements in the HASH table. Each reserved word keyword is stored in the HASH table with a structure, and its structure definition is shown in Table 1.

[0023] structure item

illustrate

Keyword

res...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30G06F9/445G06F17/27
Inventor 孙峰余院兰
Owner WUHAN DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap