Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Power-grid big time series data storage method

A technology of big data storage and time sequence, applied in electrical digital data processing, special data processing applications, instruments, etc., to improve query efficiency and reduce seek time.

Inactive Publication Date: 2014-12-24
CHINA REALTIME DATABASE
View PDF10 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to its architectural design and implementation principle, traditional real-time databases cannot realize that the historical data of a batch of measurement points with location correlation in business logic are also located adjacent to each other in physical storage.

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
  • Power-grid big time series data storage method
  • Power-grid big time series data storage method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The present invention will be described in further detail below in conjunction with the accompanying drawings and embodiments.

[0019] In this embodiment, the collection of electricity consumption information of a community is taken as an example for illustration. Assume that the name of the community is lvsejiayuan, and there are 25 buildings in the community A, B, C, ... Y, each building has 8 units 1, 2, 3, 4, 5, 6, 7, 8, and each unit has 01 , 02, ..., 15 floors, each floor has 01, 02, ..., 19, 20 households. Assume that a resident household has an electric meter (measurement object) consisting of forward active electric energy (direction=fd), reverse active electric energy (direction=bd), forward active peak electric energy (direction=fd type=shark), forward active electric energy Direct active peak electric energy (direction=fd type=peak), forward active flat electric energy (direction=fd type=shoulder), forward active valley electric energy (direction=fd type=o...

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 power-grid big time series data storage method. The information of a batch of measurement points having location relevance to each other in service logic is re-described by selecting an open-source distributed column-oriented database HBase as a storage layer, and combining an SG-CIM model in power grid service; a reasonable index organization mode of a measurement point data storage table is designed, and the physical storage positions of the historical data of the batch of measurement points having location relevance to each other in service logic are adjacent to each other by use of the partitioning and load balancing functions of the HBase, so that the disk seek time can be reduced for querying the historical data of the batch of measurement points, and the query efficiency can be improved; instant query service can be provided for service application.

Description

technical field [0001] The invention relates to a time series big data storage and real-time query method sensitive to location information in grid business, belonging to the field of big data storage and distributed real-time databases. Background technique [0002] With the continuous development of intelligence and informatization, the time-series big data management system, as an important basic data platform for the production informatization of large-scale process industrial enterprises, is facing more and more challenges. Taking the power system as an example, on the one hand, there is a huge pressure on ultra-large-scale data processing. The construction of the massive historical / real-time data management platform of the State Grid Corporation of China (SG-ERP) continues to deepen, and its data scale is getting larger and larger. Among them, the scale of measuring points (data collection points) is expected to reach tens of millions or even hundreds of millions, and ...

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/30
CPCG06F16/2246G06F16/221
Inventor 王远袁军刘琛胡健张珂珩
Owner CHINA REALTIME DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products