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

Time-series data storage method based on distributive column storage

A time series and data storage technology, applied in the database field, can solve problems such as restricting the development of time series data business applications, lack of common functions of aggregation computing, and difficulty in expansion, and achieve the effect of improving speed, enhancing security, and improving fault tolerance.

Inactive Publication Date: 2014-09-10
CHINA REALTIME DATABASE
View PDF8 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But at the same time, there are difficulties in later expansion, and it does not have the common functions of databases such as aggregation calculations, and there are many deficiencies in processing massive time series data.
On the whole, these two methods have great limitations in both theory and practical application, which restricts the further development of business applications for time series data

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
  • Time-series data storage method based on distributive column storage
  • Time-series data storage method based on distributive column storage
  • Time-series data storage method based on distributive column storage

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The present invention will be described in further detail below with reference to the accompanying drawings and examples.

[0020] In an example of the present invention, the data tables of the entire time series database are divided into three parts: the measuring point information table METRIC_INFO, the name mapping table METRICTAG_UID and the measuring point data table METRIC_DATA. The measuring point information table mainly stores the information of the collected measuring points, the name mapping table mainly stores the name of the measuring point or label and the corresponding name mapping value, and the measuring point data table stores the specific time series data.

[0021] Such as figure 1 As shown, the measuring point data table METRIC_DATA is composed of a sparse table composed of row keys and columns, and the columns can be realized by one or more sub-columns. The row key is structured like image 3 As shown in , the row key consists of feature points, t...

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 time-series data storage method based on distributive column storage, and belongs to the technical field of database. The method is characterized in that a spare table composed of row keys and rows is used to store data stored in measuring points, wherein each of the row keys contains as much retrieval information; data that are dispersedly acquired at some time slots are merged in the record at each row; a name mapping table is created to store name information. With the adoption of the time-series data storage method based on the distributive column storage, various advantages of the distributive column storage technology can be fully utilized, thus the efficiency of storing and retrieving time-series data in the distributive column storage can be ensured, and the safety of the data storage is improved due to the distributive storage manner.

Description

technical field [0001] The invention belongs to the technical field of databases, and more precisely, the invention relates to a time series data storage method based on distributed column storage. Background technique [0002] With the continuous deepening of industrialization and informatization "integration of industrialization and industrialization", various industries are facing explosive growth of data, and the pressure of data processing is increasing. From the perspective of the State Grid, with the rapid development of the State Grid, the extensive and in-depth application of information technology in various businesses of the State Grid, and the promotion and popularization of the Smart Grid. The data of various business systems in the power system has experienced explosive growth, and the growth rate of time series is particularly obvious. The traditional time-series database, no matter in terms of the amount of data processed or the response speed, is increasing...

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
IPC IPC(8): G06F17/30
CPCG06F16/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

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