Power data storage method

An electric power data and database technology, applied in the field of electric power data storage, can solve the problems of low query efficiency, increased query burden, bulky database, etc., and achieve the effects of improving query speed, reducing retrieval burden, and increasing storage space.

Inactive Publication Date: 2019-11-29
广州高谱技术有限公司
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, due to the structural characteristics of continuous storage of multiple attributes and different types of measurement points in traditional databases, the database is bulky and huge. As a result, when querying a certain type of measurement point, other types of measurement points will increase the query burden, resulting in low query efficiency.

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 data storage method
  • Power data storage method
  • Power data storage method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0011] Such as figure 1 , 2 As shown, a method for storing electric power data according to the present invention performs sub-database and sub-table processing. In this embodiment, the first time cycle is set to 1 hour, and the corresponding first cycle history table is an hour table; the second time cycle is 1 day, and the second cycle history table is a day table; the third cycle history table is a day table; The time period is January, and the history table of the third period is a month table. Of course, the specific period in this embodiment is a preference, not a limitation to the scope of protection. Those skilled in the art can make reasonable adjustments to the three different periods under the concept of the present invention to suit different applications, which should be considered covered by the technical solution of this patent.

[0012] Sub-database: Create a database named hisdataXXXX every year to save historical data according to the year, where XXXX repr...

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 an electric power data storage method, and relates to the field of electric power data processing. The scheme is provided for solving the problems that in the prior art, when acertain type of measuring point is inquired, inquiring burdens can be increased by other types of measuring points, and the inquiring efficiency is low. The method includes: screening and recording the data in the real-time database according to different time periods, and then recording different tables into corresponding historical databases according to the types of the measurement points. According to the method, the problems of overlarge single-table data volume and mutual interference of frequencies of different measurement points on the query speed can be solved, the database retrievalburden is reduced, the query speed is increased, the data compression ratio can also be increased, and the storage space is increased.

Description

technical field [0001] The invention relates to the field of power data processing, in particular to a method for storing power data. Background technique [0002] In the process of power informatization and lean construction, with the increase in the breadth and depth of power information system applications, the complexity of various businesses such as data analysis continues to increase, and the amount of data is increasing day by day. In terms of databases, due to the structural characteristics of continuous multi-attribute storage, traditional databases degrade data query performance in massive data scenarios, seriously affecting work efficiency, and making it difficult to meet user real-time requirements. In the actual application of power grid system report business, the query frequency of each measurement point is different. For example, the query frequency of electric energy measurement points is the highest. However, due to the structural characteristics of contin...

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): G06F16/22G06F16/28
CPCG06F16/2282G06F16/285
Inventor 曾保权颜盛官江明杨晚云
Owner 广州高谱技术有限公司
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