Standard-SQL-based method for implementing dual-engine database system

Abstract

The invention discloses a standard-SQL-based method for implementing a dual-engine database system and provides the dual-engine database system. A relational database is selected to serve as a relational data engine, a real-time database is selected as a timing sequence data engine, and the relational data engine and the timing sequence data engine form the dual-engine database system. The system includes an SQL query compiler and a query plan executor; the SQL query compiler includes a query analysis module and a query rewriting module; the method logically maps timing sequence data to an external table of the relational database, the timing sequence data and relational data are managed in a unified table space, and standard SQL grammar is provided for a business system to perform unified data access; the standard SQL is adopted to have access to the two databases, the unified management of the timing sequence data and the relational data is achieved, the difference shown by different databases in the aspect of access modes and storage modes is avoided, and the complexity of business system implementation is reduced.

Description

technical field [0001] The invention belongs to the technical field of databases, and in particular relates to an implementation method of a standard SQL-based dual-engine database system. Background technique [0002] With the continuous development of intelligence and informatization, the amount of time-series data for process industries such as electric power, petrochemicals, and steel continues to grow. At the same time, it is necessary to face a large number of structured data such as relational models and management information. Therefore, time-series data and traditional relationships Data fusion is facing more and more challenges. Taking power systems as an example, both relational databases and real-time databases are widely used. However, due to the different structures and implementation principles of the two databases, their application scenarios are also very different. For most application systems, business applications need to access data in these two databas...

AI Technical Summary

Problems solved by technology

Since relational databases use standard SQL for access, while real-time databases use APIs to obtain data, the interfaces of the two databases are not unified, resulting in inconsistent interfaces between relational databases and real-time databases, unified management of data, and joint operations of real-time data and relational data, etc. problems, and cannot be flexibly expanded, so that the operation of the data set must be completed by the business system, resulting in complex business logic and very low processing efficiency

Images