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

Power grid mass time series data access method applicable to section access mode

A time-series data and access mode technology, which is applied in the field of smart grid, can solve problems such as undiscovered and inability to solve the performance of time-section query scenarios, and achieve the effect of ensuring efficiency

Inactive Publication Date: 2015-02-04
CHINA REALTIME DATABASE
View PDF4 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For grid time series data information storage, the design usually only considers that the time series data are adjacent to each other on the physical disk. Although this ensures the efficiency of time series query, it cannot solve the performance problem of time section query scenarios.
After a preliminary search, no relevant patents that solve the above problems have been found

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 mass time series data access method applicable to section access mode
  • Power grid mass time series data access method applicable to section access mode
  • Power grid mass time series data access method applicable to section access mode

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0031] This embodiment describes the present invention with an example of sensor data in a smart meter monitoring scenario.

[0032] According to the previous description of the time series data characteristics of the power grid, it is assumed that a certain sensor data record is as follows:

[0033] electric_energy.forward_direction 1292148123476 device=myammeter device_type=ammeter.

[0034] Here the timestamp 1292148123 is described in UNIX format, and its corresponding time is 10:02:03 on December 12, 2010, so the sensor data record indicates: ammeter at the moment of 10:02:03 on December 12, 2010 The forward active energy value of myammeter is 476.

[0035] In order to show the specific implementation, here is an example of HBase distributed columnar database. First, three tables are created, which are Uid table, time series...

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 mass time series data access method applicable to a section access mode, so as to ensure that both time series inquiry and the inquiry efficiency under a time section inquiry scene are taken into consideration under the condition that the write-in performance is not influenced. The method comprises the following steps: establishing three tables, which are respectively a Uid table, a Time-series data table and a Time-point time section data table; respectively storing power grid Time-series data into the Time-series data table and the Time-point time section data table, so that the positions of power grid data of the same time slice in a physical disk are adjacent, and the positions of the power grid data of different power grid devices in the same time point in the disk are also adjacent, so that the inquiry efficiencies based on the time series and time section can be ensured.

Description

technical field [0001] The invention relates to a data access method, which belongs to the technical fields of massive data processing and new databases, and is particularly suitable for the scene of real-time processing of massive time-series data in the field of smart grids. Background technique [0002] With the continuous development of smart grids, the scale of data processing has become increasingly massive, and there have been application requirements for tens of millions or even hundreds of millions of data collection scales. Taking the power system as an example, on the one hand, the scale of measuring points is getting larger and is expected to reach tens of millions or even more than 100 million; on the other hand, the scale of historical time series data is increasing, and it is expected to reach more than PB bytes. There are many ways to store massive information. Oracle and EMC provide storage systems and hardware. The more classic one is RAC (Real Application ...

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/22G06F16/2474
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