Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Data inquiry method and device based on mixed storage architecture

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

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
  • Data inquiry method and device based on mixed storage architecture
  • Data inquiry method and device based on mixed storage architecture

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

No 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
no application 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
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
Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com