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

Indexing method applied to time sequence historical database

A database and indexing technology, applied in the field of data indexing, can solve the problems of relational database storage and retrieval, which are difficult to satisfy, and achieve the effects of low consumption of memory resources, ensuring efficiency, and reducing the frequency of file access

Active Publication Date: 2013-01-23
STATE GRID CORP OF CHINA +2
View PDF5 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

With such a large amount of historical data, traditional relational databases are stretched for both storage and retrieval, and it is difficult to meet the needs of these applications

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
  • Indexing method applied to time sequence historical database
  • Indexing method applied to time sequence historical database
  • Indexing method applied to time sequence historical database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0025] The data of the entire time series historical database is divided into three parts: measuring point files, index files and data files. The measuring point file mainly stores the information of the collected measuring points, the index file stores the index information of the data, and the data file stores the historical data.

[0026] figure 1 What is shown is the access mechanism among the three files of the time series historical database. First obtain the information of the relevant measuring point through the measuring point file, then find the position of the index according to the information of the measuring point, and then obtain the position of the data according to the position pointed to by the index. The three files are connected in series, and they are accessed through file pointers in the form of (file name, offset in th...

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 indexing method applied to time sequence historical database, which is used for realizing the high-efficiency storage and retrieval of the time sequence historical database. According to the indexing method, the time point is taken as a keyword to establish multi-tree indexes, and the indexes can be orderly stored in an index file in a disc according to the time sequence, and the time sequence historical database can be orderly stored in the data file in a disc according to the time sequence. During data access, the access frequency of files can be reduced through batching memory mapping file mechanisms, so that the data storage and retrieval efficiency of the time sequence historical database can be ensured, and moreover, the consumption on memory resources is small.

Description

technical field [0001] The invention relates to a data indexing method, in particular to a data indexing method in a time series historical database. Background technique [0002] With the deepening of industrialization and informatization "integration of industrialization and industrialization", the industrial automation system is facing more and more pressure on massive data processing, and the system is facing more and more collection points. The annual data storage scale of the system will be from The current GB level is turning to TB level or even PB level. With such a large amount of historical data, traditional relational databases are stretched for both storage and retrieval, and it is difficult to meet the needs of these applications. In recent years, the emergence of time-series historical databases has made it possible to realize these application requirements. The time series historical database is a database management system specially designed to deal with t...

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
Inventor 郑晓露陈静
Owner STATE GRID CORP OF CHINA
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