Method and device for querying data in database, electronic equipment and storage medium

Abstract

The invention discloses a method and device for querying data in a database, electronic equipment and a storage medium, and relates to the technical field of computers. One specific embodiment of themethod is applied to a first node, and comprises: receiving a query request sent by a client, the query request comprising a query strategy; judging whether a target index strategy the same as the query strategy is queried or not; if yes, determining a target storage position corresponding to the target index strategy from the full index based on the target index strategy, wherein the full index is used for recording a mapping relationship between an index strategy and a data storage position; and sending the target data stored in the target storage position to the client. According to the embodiment, the time consumption of distributed database query, especially deep paging query, can be reduced, the waste of resources is reduced, and the query performance is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method, device, electronic equipment and storage medium for data query in a database. Background technique [0002] Distributed database usually executes the query mechanism as follows: the master node first receives the query request, the query request usually includes the starting position (from) and the size (size) of the query data, and then distributes the query request to each node, each node According to the query request, the size pieces of local data are retrieved and returned to the master node, and the master node then determines the size pieces of data queried by the query request from the data received from each node. For distributed databases, when the starting position of the query request is small, it does not consume too much resources. However, when deep paging query (starting position is very large, such as 100,000, million levels), each node needs to quer...

AI Technical Summary

Problems solved by technology

[0005] Because the number of scans that can be scanned by each query cursor is certain, for deep paging query scenarios, sometimes multiple scans are required to meet the data query requirements, so the number and time of data query will be longer, and the temporarily generated data Snapshots need to be kept for a relatively long time, which will also cause a lot of consumption and waste of resources and reduce query performance

Images