System for implementing network search caching and search method

Abstract

The invention provides a caching system for realizing network inquiry, which comprises an inquiry binder, an inquiry resolver, an inquiry descriptor manager, an inquiry scheduler and an inquiry buffer. The query binder is used for binding virtual view meta-information relating to the examples of inquiry requests to a system memory and setting in sequence time marks of write operation of virtual views from a lower layer to an upper layer; the inquiry resolver is used for resolving the virtual views into a querying tree according to the validity of the examples of the inquiry requests; the inquiry descriptor manager is used for storing a queue of the examples of the inquiry requests imposed on the virtue views, determining examples of the inquiry requests to enter and exit the queue, and judging the validity of the examples of the inquiry requests; the inquiry scheduler is used for dispatching the inquiry nodes of the querying tree so as to execute inquiry; the inquiry buffer is used for establishing and deleting temporary tables, managing data set in the temporary tables, updating time characteristics making of examples of the inquiry requests in the inquiry descriptor and outputting inquiry result. The cache of the system of the invention is carried out based on increment, thereby improving inquiring performance and throughout rate, and providing transparent support for the implementation process of the inquiry requests.

Description

technical field [0001] The invention relates to the technical field of computer applications, in particular to a system and a query method for realizing network query cache for database applications in a network environment. Background technique [0002] As the processing and calculation of business logic in the network application layer become more and more complex, a query request may involve instant access to multiple distributed data sources on the network. Affected by factors such as network bandwidth, request load, and data volume, access performance is often the bottleneck of this type of application. Therefore, the research on performance optimization technology for this type of application mode has always been a hot spot. [0003] From the perspective of technical methods, so far, there are mainly two ideas to implement this type of distributed query caching mechanism to improve access performance. [0004] The first idea is to create a cache in the memory, and rea...

AI Technical Summary

Problems solved by technology

The disadvantages of this approach are: 1) data objects are cached in memory, therefore, subject to the constraints of memory size, it is impossible to support the caching needs of a large number of data query result sets; 2) memcache memory data organization is in memory object mode, not In relational data mode, therefore, a dedicated access interface is provided for application development, and standard SQL statements are not accepted

The disadvantages of this approach are: 1) It is also constrained by the size of the memory; 2) The replacement strategy of cached data is based on the entire data table as a unit, rather than a finer-grained query request as a unit; 3) The query must be verbatim Only the same section can be considered the same, and the same conditions but different field sets are considered different requests; 4) The cached data only exists on the server where the database is located, and currently does not support multi-node in a distributed network environment cache between servers

The disadvantages of this approach are: 1) The replacement strategy of the materialized view is based on the entire data table, rather than a finer-grained query request; 2) It is difficult to ensure a relatively high timeliness of the materialized view in the network environment sex

This method can improve the efficiency of data query processing, but it is not convenient to solve the following requirements: 1) the sharing of result data sets between multi-user query requests; 2) it is difficult to ensure relatively high buffer timeliness in a distributed network environment, and at the same time It is easy to cause periodic high load on the network

Images