Method and device for data query

Abstract

A data query method and device, the method comprising: obtaining a query statement, the query statement is used to query the N-level data in the data hierarchy structure of the data set to obtain the target data to be queried, and the data hierarchy structure is for storing the The hierarchical structure of the data in the data set, and the data set is stored in K files in order of the levels in the data hierarchy from high to low, and the K files include the first file and the second file, and the first file is all The file with the earliest creation time among the above K files, and the second file is the latest file with the creation time among the K files, wherein, N and K are positive integers greater than 1 (310); if the query statement satisfies the predetermined If the condition is set, the K files are queried according to the query sequence from the second file to the first file. The preset condition includes that the filter condition for querying the data set in the first sub-statement is empty, and the second sub-statement The filter condition used to query the data set in the statement is not empty, the first sub-statement is used to query the top-level data in the N-level data, and the second sub-statement is used to query the bottom-level data in the N-level data (320). This method is beneficial to improve the query data efficiency.

Description

technical field [0001] The present application relates to the computer field, and more specifically, to a data query method and device. Background technique [0002] Distributed database refers to the use of high-speed computer network to connect multiple physically dispersed data storage units to form a logically unified database. The basic idea of ​​a distributed database is to disperse and store the data in the original centralized database to multiple data storage nodes connected through the network to obtain larger storage capacity and higher concurrent access. In recent years, with the rapid growth of data volume, distributed database technology has also developed rapidly. Traditional relational databases have begun to develop from centralized models to distributed architectures. Relational-based distributed databases retain traditional databases. Under the data model and basic characteristics, from centralized storage to distributed storage, from centralized computin...

AI Technical Summary

Problems solved by technology

[0005] However, the above-mentioned querying of files in a fixed query order will result in low efficiency of querying data

For example, if the filter condition in the query statement is only for the attributes of the underlying data in the hierarchical structure storing the data of the target application, and the file query sequence is from the old file to the new file, since the old file stores Most of the data stored in the data set is near the top level of the data hierarchy structure, so when searching for data in the old file, because the filter condition for the top level data in the query statement is empty, a large number of Intermediate results that do not meet all filter conditions in the query statement, reducing the efficiency of query data

Images