Real-time database cross-database SQL interaction method and system

A database and cross-database technology, which is applied in the directions of database update, data processing application, structured data retrieval, etc., can solve the problems of complex data organization and low efficiency of separate access to multiple databases, so as to improve operating efficiency and quickly cross multiple real-time databases. Database joint query, the effect of improving the overall performance

Active Publication Date: 2020-10-09
NR ELECTRIC CO LTD +1
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The current real-time database architecture only supports business applications to link each real-time library that needs to be accessed to obtain data into the application process, and store it in the data structure cache insid

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
  • Real-time database cross-database SQL interaction method and system
  • Real-time database cross-database SQL interaction method and system
  • Real-time database cross-database SQL interaction method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0063] This embodiment introduces a real-time database cross-database SQL interaction method, including:

[0064] Obtain and update metadata information of multiple real-time databases at set time intervals;

[0065] In response to external SQL access requests, parse the SQL access requests to obtain all SQL operations and the real-time databases involved;

[0066] According to the real-time database involved in the SQL operation, the SQL operation is divided into single-database SQL execution sequences corresponding to a single real-time database respectively;

[0067] Execute the SQL operations in the corresponding single-database SQL execution sequence to each real-time database involved, and obtain SQL execution result data;

[0068] Based on the SQL execution result data, according to the current metadata information of the corresponding real-time database, construct a result data set including execution result information of all SQL operations;

[0069] Return the resu...

Embodiment 1-1

[0071] This embodiment specifically introduces an implementation manner of Embodiment 1.

[0072] On the basis of embodiment 1, in this embodiment:

[0073] The metadata information includes the table structure of the real-time database, the domain data type, and the relationship between tables.

[0074] The method of the present invention mainly involves the following contents:

[0075] 1. Real-time database cross-database metadata management

[0076] In order to realize cross-database metadata management, the method needs to construct a real-time database list, and determine the data update flag of each real-time database in the real-time database list according to the metadata update result and update time of each real-time database.

[0077] This embodiment obtains and updates the metadata information of multiple real-time databases including:

[0078] Query the data update flags of each real-time database in the real-time database list, and link the real-time database ...

Embodiment 2

[0165] This example introduces the real-time database cross-database SQL interaction system, refer to figure 1 shown, the system includes:

[0166] (Cross-database) metadata management module, configured to obtain and update metadata information of multiple real-time databases at set time intervals;

[0167] The SQL engine module is configured to respond to external SQL access requests, parse the SQL access requests, obtain all SQL operations and the real-time databases involved, and then divide the SQL operations into separate SQL operations according to the real-time databases involved in the SQL operations. A single-database SQL execution sequence corresponding to a single real-time database;

[0168] The single-database SQL execution scheduling module (single-database SQL execution scheduler) is configured to execute SQL operations in the corresponding single-database SQL execution sequence for each real-time database involved, obtain SQL execution result data, and return...

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 real-time database cross-database SQL interaction method and system. The method comprises the steps of acquiring and updating metadata information of multiple real-time databases at set time intervals; in response to an external SQL access request, analyzing the SQL access request to obtain all SQL operations and real-time databases involved in the SQL operations; according to a real-time database involved in the SQL operation, dividing the SQL operation into single-library SQL execution sequences corresponding to the single real-time database; executing an SQL operation in a corresponding single-library SQL execution sequence on each related real-time database to obtain SQL execution result data; based on the SQL execution result data, constructing a result dataset comprising all SQL execution results according to the current metadata information of the corresponding real-time database; and returning the result data set to the external SQL access requester.Rapid multi-real-time-library cross-library joint query can be realized, the data access efficiency of comprehensive analysis services is improved, and the data organization complexity is reduced.

Description

technical field [0001] The invention relates to the technical field of real-time database access of an electric power dispatching automation system, in particular to a cross-database SQL interaction method and system based on a container real-time database. Background technique [0002] In the field of power monitoring, applications cache real-time data in a real-time database for fast computing, and business modules usually access a specific real-time database through an access interface to obtain the required data. However, for comprehensive analysis business modules, it needs to obtain cross-professional data such as power grid topology information, real-time measurement information, and equipment status information, which are distributed in different real-time databases. [0003] The current real-time database architecture only supports business applications to link each real-time library that needs to be accessed to obtain data into the application process, and store it...

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): G06F16/23G06F16/242G06F16/2453G06Q50/06
CPCG06F16/2433G06F16/24539G06F16/23G06F16/24544G06Q50/06
Inventor 孙超史豪杰翟桂锋陆鑫顾全
Owner NR ELECTRIC CO LTD
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