Method and device for storing and reading multi-source data index

Abstract

The invention discloses a method for storing and reading a multi-source data index. The method includes the steps of a. grouping the deployed objects according to the amount of measuring points contained in each deployed object, b. dividing the deployed objects in each group, namely, with the preset value as a dividing line, the measuring points with the amount reaching the preset value are divided into one inner group, and the other measuring points with the amount not reaching the preset value are divided into another inner group, c. corresponding one inner group in each deployed object group to one storage file, and d. finding corresponding storage file according to the deployed object group and inner group to which the measuring points belong when the data of the measuring points are received and storing the data of the measuring points into the storage file. Therefore, when a large amount of data which come from multiple sources are stored, corresponding storage files of the data can be found quickly, and then the data is stored.

Description

technical field [0001] The invention relates to a data storage and reading technology, in particular to a multi-source data index storage and reading technology. Background technique [0002] For large-scale enterprises such as electric power, petroleum and chain operations, their sub-stations or business locations are distributed across the country or even around the world, and each of their sub-stations or business locations contains many measurement points. The data centers of these large-scale enterprises, at any time The data generated by these measurement points must be stored at any time, and when necessary, the required data must be read from the stored data. The data of these enterprises have one thing in common: the data volume is relatively large and the data sources are relatively extensive. In view of these characteristics, how to store and read data more quickly is a problem that needs to be solved urgently. [0003] In the database, the index strategy determ...

AI Technical Summary

Problems solved by technology

When there are a large number of records in the table, if you want to query the table, the first way to search information is to search the whole table, which is to take out all the records one by one, compare them with the query conditions one by one, and then return the records that meet the conditions, so Doing it will consume a lot of database system time and cause a lot of disk I / O operations; the second is to build an index in the table, then find the index value that meets the query conditions in the index, and finally pass the ROWID stored in the index (equivalent to page number) to quickly find the corresponding record in the table

Images