Data query method, device and equipment and computer readable storage medium

Abstract

The invention discloses a data query method, device and equipment and a computer readable storage medium, and belongs to the technical field of computers. The method comprises the following steps: determining a batch condition of data query, wherein the batch condition is used for indicating the sequence of the data query; determining a first step length based on the batch condition, and querying based on the first step length to obtain first data; determining a second step length based on a first index in response to the fact that the end condition of the data query is not met, the first index being used for indicating the query condition of the first data obtained based on the first step length query; and obtaining a data query result based on the second step length. Batch query is carried out through a method of determining the step length of the next batch based on the index of the batch, and the data query efficiency is adjusted by continuously adjusting the step length, so that low data query efficiency caused by too small first step length is avoided, and slow data query caused by too large first step length is also avoided; and the external overall service performance and quality of the database are influenced.

Description

technical field [0001] The embodiments of the present application relate to the field of computer technology, and in particular to a data query method, device, equipment, and computer-readable storage medium. Background technique [0002] A database is a computer software system that stores and manages data according to its data structure. With the continuous growth of data in the database, the data range and data volume are getting larger and larger, how to query data is an urgent problem to be solved. [0003] In related technologies, a data query method is to query the largest ID (IdentityDocument, identity identification number) and the smallest ID in the data that meets the conditions, and then use a fixed step to perform batch query from the data with the smallest ID. The query ends when the data with the largest ID is reached, and then the data queried in batches is aggregated to obtain the final data query result. [0004] When using the above related technologies ...

AI Technical Summary

Problems solved by technology

[0004] When using the above related technologies for data query, when the data that meets the conditions are distributed according to ID, if the fixed step size is small, it will lead to too many batches and the efficiency of data query is low; when the data that meets the conditions is distributed according to ID In relatively concentrated cases, if the fixed step size is large, too much data will be queried in each batch, resulting in slow data query, which will affect the quality of database external services

Images