Data inquiry method and device based on mixed storage architecture
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
A data query and hybrid storage technology, applied in the field of data query, can solve problems such as the inability to use unified structured query operation statements, the lack of support for result set merging, and the inconsistency of interfaces.
Inactive Publication Date: 2017-05-31
ELECTRIC POWER SCI RES INST OF GUIZHOU POWER GRID CO LTD
View PDF5 Cites 24 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
[0004] The existing hybrid storage method has the problem of inconsistent interfaces in both data storage and data access: the operation of the relational library and the operation of the time series library are separated, and the time series library needs to develop an application programming interface (Application Programming Interface, "API" for short) ), you cannot use the unified structured query operation statement
Another problem is that the data consumer needs to customize the development, merge the query result set of the relational database and query the result set of the time series database
The interface is not unified, and result set merging is not supported, which leads to repeated custom development for data source systems or business systems that have an interface relationship with the data center
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0037] The embodiment of the present invention provides a data query method based on hybrid storage architecture, see figure 1 , the method can include:
[0038] In step S11, the hybrid storage architecture is initialized and a unified SQL engine is provided for the hybrid storage architecture. The hybrid storage architecture may include: a relational database for storing structured data and a time series database for storing real-time data.
[0039] In this embodiment, in addition to traditional structured data, there are many real-time monitoring data that need to be stored in the data generated by the electric power industry. Therefore, it is very necessary to use a hybrid storage architecture to store the above data. Specifically, a relational database may be used to store structured data, and a time series database may be used to store real-time data.
[0040] Optionally, in order to facilitate access to these databases, the above step S11 may be implemented in the follo...
Embodiment 2
[0068] An embodiment of the present invention provides a data query device based on a hybrid storage architecture, using the method described in Embodiment 1, see figure 2 , the device may include: an initialization module 100 , an acquisition module 200 , an analysis module 300 , and a processing module 400 .
[0069] The initialization module 100 is used to initialize the hybrid storage architecture and provide a unified SQL engine for the hybrid storage architecture. The hybrid storage architecture may include: a relational database for storing structured data and a time series database for storing real-time data.
[0070] In this embodiment, in addition to traditional structured data, there are many real-time monitoring data that need to be stored in the data generated by the electric power industry. Therefore, it is very necessary to use a hybrid storage architecture to store the above data. Specifically, a relational database may be used to store structured data, and a ...
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
Login to view more
Abstract
The invention discloses a data inquiry method and device based on a mixed storage architecture. The method comprises the following steps: initiating the mixed storage architecture and providing a uniform SQL (structured query language) engine for the mixed storage architecture; acquiring an SQL data inquiry request compiled according to an SQL with a preset uniform standard; parsing the acquired SQL data inquiry request according to the provided uniform SQL engine; performing corresponding data operation on different databases according to a parsing result and acquiring corresponding data operation results; combining a plurality of acquired data operation results to form a total inquiry result. The method provided by the invention supports unified SQL data inquiry in mixed storage of a relational database and a time series databases, therefore, a uniform standard access of the mixed storage architecture is realized, the data inquiry efficiency of the mixed storage architecture is effectively improved, the data inquiry cost is greatly lowered, and various business applications, such as a big data analysis and the like, are effectively supported.
Description
technical field [0001] The present invention relates to the technical field of data query, in particular to a data query method and device based on a hybrid storage architecture. Background technique [0002] The power system is building an enterprise-level data center to support various thematic data analysis, impromptu query, management report business, auxiliary decision-making analysis, and support personalized reports and customized theme applications for units at all levels. The data center is connected to various source systems, covering: structured management data, quasi-real-time time series data, GIS geographic information data, graphic data, video data, etc. From the perspective of data characteristics, it includes structured data, unstructured data and partially structured data. There are great differences in the size, frequency of generation, timeliness, and relevance of these data. [0003] Based on the differences in data characteristics, the data center for...
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06Q50/06
CPCG06F16/256G06F16/284G06Q50/06
Inventor 高正浩黄良曹洪赵立进邓琨林圳杰符飞虎刘为亮
Owner ELECTRIC POWER SCI RES INST OF GUIZHOU POWER GRID CO LTD
Login to view more 
Login to view more