Data query method, device and system

Abstract

The embodiment of the invention provides a data query method, which comprises the following steps of: determining a query main key through an application server according to a query request sent by a client for querying data in accordance with certain query conditions, querying the value of the query main key in a database server, creating a temporary database table according to the query result item number in the query request and the value of the corresponding query main key, and finally querying the data identified by the value of the query main key in the temporary table, wherein the data are required by the client. The invention also provides a data query device and a data query system. The data query efficiency can be improved through the technical scheme provided by the embodiment of the invention.

Description

technical field [0001] The present invention relates to the field of communication technologies, and in particular, to a data query method, device and system. Background technique [0002] With the development of communication technology, in order to meet the needs of various services, more and more data are stored in the database server. For large-scale application systems (such as carrier-level application systems), the amount of data in the database server is often in the millions. , and querying and browsing data are the most common needs of users. How to quickly and reliably read the data required by the user from the huge data of the database server is particularly important. [0003] In the application system of B / S (Browser / Server) browser / server mode and C / S (Client / Server) client / server mode, the general query process in the prior art is: data is stored in the database server, when When the user needs to query data, the query conditions are sent to the applicatio...

AI Technical Summary

Problems solved by technology

[0004] The inventor found in the research that there are the following problems in querying data through the above method: the query operation in the prior art relies heavily on the database server, which is greatly affected by the processing speed of the database server, and the database server directly searches for data according to the query conditions. Filter out the data that meets the query conditions from the database with millions of data volumes, which puts a heavy load on the data database, and the query efficiency is also very low, which affects the customer's query experience

Images