Data inquiry method, data inquiry device, equipment and storage medium

Abstract

The invention discloses a data inquiry method, a data inquiry device, equipment and a storage medium, wherein the method comprises the following steps of generating a filtering condition according toa data inquiry request; obtaining a target document in the database; determining a target data block influenced by a second increment document in the target file, wherein the second increment documentcomprises an increment document of modification operation information; filtering data blocks beyond the target data blocks in the target document to obtain a filtering result; directly reading the documents except for the target documents in the database and the target data blocks to obtain a reading result; filtering the filtering result and the reading result again according to the filtering condition to generate a final inquiry result. By using the technical scheme provided by the embodiment, the document can be filtered according to the modification information in the data inquiry document reading stage; the inquiry result correctness is ensured; meanwhile, the unnecessary data reading is reduced; the inquiry performance is improved.

Description

technical field [0001] The embodiments of the present invention relate to data processing technologies, and in particular to a data query method, device, equipment, and storage medium. Background technique [0002] A common storage method for transaction tables in distributed databases is incremental storage. The original version of the data is stored in the base file. The data related to the addition, deletion and modification of each transaction operation will be stored in an incremental file as a new version. When reading a row in a transaction table, all versions of the data need to be merged to obtain the actual content of the current row in the transaction table. Therefore, when the database detects a query request from a user, it first reads all the contents of each basic file and incremental file. Then filter the results according to the filter conditions generated by the user's query request, filter the data that does not meet the filter conditions, and generate ...

AI Technical Summary

Problems solved by technology

[0004] In the process of implementing the present invention, the inventor found that the existing technology has the following defects: since the content in the incremental file only represents the information of the current version, it cannot be confirmed whether there are other versions and the content

If the filter conditions are directly applied to the stage of reading the content of each basic file and incremental file, the actual content of each row of the transaction table will not be confirmed, and wrong query results may be generated

Images