Data query method and device

Abstract

The invention provides a data query method and a data query device, which can dynamically analyze hot queries, improve the cache hit rate and reduce the delay of query response by adopting a mode of coexistence of a first-level cache and a second-level cache, and can improve the accuracy of cached data by utilizing a data updating form of combination of an active cache and a passive cache. The method comprises the following steps: querying data from a first-level cache according to a received query request, and returning the data if the data is queried; Otherwise, continuing to call the external query service interface to perform data query; if the query is not overtime, returning the queried data; updating the inquired data into a first-level cache and a second-level cache; and if the query is overtime, querying data from a second-level cache and returning the data, the first-level cache having a first preset data expiration deletion time, the second-level cache having a second presetdata expiration deletion time, and the first preset data expiration deletion time being less than the second preset data expiration deletion time.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data query method and device. Background technique [0002] With the continuous development of computer technology, more and more people choose to access business systems online to obtain the information they need. For an online data query system with a large number of accesses, its core business scenarios, such as online query of remaining train tickets, online query of remaining air tickets, online query of hotel room supply, etc., usually have the following commonalities: [0003] 1. The query request is much larger than the write request; 2. It is necessary to call the interface service of the external query system; 3. The processing capacity of the external query system is limited; 4. The input parameters of the query change greatly (for example, in the scene of querying remaining train tickets, the The site of the query is not fixed and changes a lot). [0004] For th...

AI Technical Summary

Problems solved by technology

[0007] Usually, in the application scenario of online data query, the data query information needs to have relatively high timeliness, and the cache time should not be too long. In daily life, under the design of the existing technical scheme, the hit rate of cached data is low and large Batch query requests will directly request the upstream query service, especially during the peak period of query and interest conversion, a large number of HTTP links will be established, which will greatly increase the burden on the business system, resulting in the inability to obtain data for some query requests, affecting the ease of use of the business system sex;

[0008] 2) Using a synchronization mechanism, the anti-risk ability is poor and basically unable to deal with "professional" malicious user attacks

At the same time, the usual data query scenarios do not limit the user's query authority. For example, the user must log in to query the remaining train tickets, so it is impossible to restrict the query based on the user ID, and the restriction based on the source IP is relatively limited.

Therefore, if a malicious user uses an automated program to simulate normal requests and generates a large number of query requests in a short period of time, it will cause the application server and supplier query services to fail to process normally, thereby affecting the availability of the business system

Images