Data query method and device, storage medium and computer equipment

Abstract

According to the data query method and device, the storage medium and the computer equipment provided by the invention, before the data is queried in the database, the database is divided into the cold data area and the hot data area in advance according to the data query frequency, so that the problem of index performance collapse caused by storing all the storage data in the same storage area can be avoided; the hot data is the data which is frequently queried in the stored data recently, when the user performs data query, the probability that the to-be-queried data corresponding to the query statement contains the hot data is high, and compared with an original storage area, the hot data area has the advantages that the stored data size is small, the index performance is excellent, and the user experience is improved. Therefore, the data query range is reduced to a certain extent, and the data query efficiency and query precision are effectively improved; and when the to-be-queried data contains the cold data, the cold data can be transferred from the cold data area to the hot data area in a targeted manner to generate the hot data, so that the data query efficiency is further improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular, to a data query method, device, storage medium and computer equipment. Background technique [0002] At present, with the popularization of big data, artificial intelligence, autonomous driving and other fields, the amount of data generated during its application is also growing rapidly. Faced with the increasing amount of data, how to manage these data reasonably and efficiently? In order to improve the efficiency of data query, it is particularly important. [0003] In the prior art, when performing data query, it is mainly to query all the stored data stored in the same storage area. When the data volume of the stored data in the storage area exceeds a certain range, the indexing performance of the data will be significantly reduced. , which in turn affects the query efficiency and query accuracy of the data, and when the amount of data in the storage area...

AI Technical Summary

Problems solved by technology

[0003] In the prior art, when performing data query, it is mainly to query all the stored data stored in the same storage area. When the data volume of the stored data in the storage area exceeds a certain range, the indexing performance of the data will drop significantly , which in turn affects the query efficiency and accuracy of the data, and when the amount of data in the storage area is too large, hardware with better storage performance is generally selected for storage, which will increase the cost of data storage to a certain extent

Images