Universal cross-database access method

An access method and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as poor versatility, poor user experience, and poor scalability, achieve good user experience, reduce learning costs, The effect of good scalability
CN105260403AActive Publication Date: 2016-01-20GUANGDONG TOONE TECH CO LTD
3 Cites 24 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
GUANGDONG TOONE TECH CO LTD
Publication Date
2016-01-20

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention relates to a universal cross-database access method. The method comprises: based on grammars, comprising a data manipulation language (DML) and a database definition language (DDL), of a structured query language (SQL), adding predefined functions and grammars in combination with various databases, and defining and / or constructing a VSQL (V Structured Query Language) statement; a grammar analysis engine performing VSQL morphology analysis and VSQL grammar analysis on the VSQL statement, performing word segmentation on a VSQL, and performing word segmentation organization on the VSQL according to the defined grammars to obtain a corresponding grammar tree; an object analysis engine performing structural analysis on the VSQL grammar tree and performing object analysis on SQL grammars corresponding to each database and comprising fields, functions and pages to obtain a native SQL statement; and sending the statement to the database for execution to obtain a result. The universal cross-database access method can effectively realize seamless combination with various databases, and has rich secondary development interfaces and good user experience and expansibility.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention belongs to the technical field of computer information, and in particular relates to a universal cross-database access method. 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. Different industries, different projects, and even different stages of the same project may have different focuses. The technical tools, data models and databases adopted Management systems can all be completely different. At the same time, various well-known databases such as SQLServer, Oracle, DB2, Mysql, and Postgresq need to communicate across databases in the same management system. The methods between different databases, the access statements and methods of the existing technology, have a lack of versatility. Strong, we must pay attention to the complex correspondence such as field types of various databases, and at the same time m...

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