A data index creation method, data retrieval method and system

Abstract

The invention discloses an establishing method for a data index, and a data searching method and system. The establishing method for the data index comprises the following steps: obtaining all the index information recorded by a data sheet file; calculating the size of an index recording area corresponding to each index information and calculating an excursion head address of each index information according to the size of the index recording area; storing data blocks in a preset size in the data file into an internal memory in a fixed size, according to a storing sequence of the data in the data file; reading data from the internal memory one by one and obtaining the data index information and the data address information of each piece of read data; confirming the index information corresponding to the data index information of each piece of data and storing the data address information of each piece of data into the index recording area corresponding to the excursion head address of the corresponding index information; and after storing the data address information of all the data in the data file into the corresponding index recording area, finishing the establishment for the data index, thereby increasing the reading speed and saving the space.

Description

technical field [0001] The present application relates to the field of databases, and more specifically, to a data index creation method, data retrieval method and system. Background technique [0002] With the continuous improvement of the current bus bandwidth, the simulation test of the electronic system is indispensable, so that a large amount of information data needs to be processed, so the problem of database processing has attracted the attention of various industries. The focus of attention is on the large-scale data storage, data query, and data analysis. [0003] At present, the commonly used databases have some requirements when processing large batches of data. For example, before the processing of large batches of data in the Mysql database, it is necessary to ensure that there is a suitable storage engine, and the time and storage capacity cannot be satisfied at the same time in this database. and space utilization requirements; Mysql can use the insert state...

AI Technical Summary

Problems solved by technology

[0003] At present, the commonly used databases have some requirements when processing large batches of data. For example, before the processing of large batches of data in the Mysql database, it is necessary to ensure that there is a suitable storage engine, and the time and storage capacity cannot be satisfied at the same time in this database. and space utilization requirements; Mysql can use the insert statement of multiple value tables to process a large amount of data, and the client terminal reads the data in the Mysql database from the disk of the server storing the Mysql database, and reads the data from the disk to reduce the read time. read speed, increase read time

Images