Uniform access method of isomeric database

An access method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc.

Active Publication Date: 2013-04-10
ELECTRIC POWER RES INST OF GUANGDONG POWER GRID
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

On the one hand, the refinement of data management is an inevitable trend, and it is necessary to introduce different highly targeted database management software; on the other hand, there is currently no effective method and unified access technology to unify and simplify heterogeneous databases

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
  • Uniform access method of isomeric database
  • Uniform access method of isomeric database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] Such as figure 1 As shown, the system of the heterogeneous database unified access method of the method includes: calling client (0); traditional relational database management system SQL analysis processor (100); real-time / historical database system SQL analysis processor (200); Object database management system SQL analysis processor (300); virtual table constructor (400), which includes real-time / historical database system virtual table constructor (410) and object database system virtual table constructor (420); database original API ( 700), which includes the original API of traditional relational database management system (710), the original API of real-time / historical database system (720) and the original API of object database management system (730); finally is the background heterogeneous database server system (800).

[0056] What calls the client (0) is the interface called by the developer of the database application software, which is the access interfac...

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 uniform access method of an isomeric database, comprising the following steps of: receiving an SQL (Structured Query Language) statement, which is input by a user, by a foreground client-side, and sending an SQL statement request to a request processing program of a background database; analyzing whether the SQL statement is legal or not by the request processing programof the background database according to an SQL standard syntax; carrying out preliminary syntax analysis on the request SQL and decomposing a table name of a virtual table needing to be operated; judging that the existing request is sent to which type of an isomeric database server according to the table name of the virtual table; selecting an SQL analysis processor corresponding to the isomeric database server according to a result judged by the third step to process an actual read-write request of the SQL statement; and returning the executed result in the fourth step back to the foregroundclient-side. According to the uniform access method provided by the invention, various isomeric databases can be accessed by a uniform access interface, so that the difficulty of a database application and development process is reduced and a time period of the development is shortened; and therefore, the post-period maintenance cost of an application system is further reduced.

Description

technical field [0001] The invention relates to a database access method, in particular to a unified access method for heterogeneous databases. Background technique [0002] With the continuous development of computer and software technology, the division of labor in the software field is becoming more and more refined, which is specifically reflected in the fact that different industries, different projects, and even different stages of the same project may have different emphases. Both data models and database management systems can be completely different. [0003] In the field of database management systems, there are currently: traditional relational database management systems (for example: Oracle of Oracle, DB2 of IBM, Sybase of Sun, and SQL Server of Microsoft, etc.), real-time / historical database systems, Object database management system. Usually, the traditional relational database management system provides external memory access interface, Insert / Select / Update...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 周伊琳陈炯聪黄缙华孙建伟胡亚平陈扬
Owner ELECTRIC POWER RES INST OF GUANGDONG POWER GRID
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