Universal cross-database access method

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.

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

AI Technical Summary

Problems solved by technology

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 must pay attention to the differences in functions and parameters of various databases and the consistency of function return results, resulting in complicated statement syntax. Version differences make it difficult to achieve seamless integration with various databases, high development and learning costs, and high user requirements, resulting in poor user experience and poor scalability

Images