A data query method and system

Abstract

The invention discloses a data query method, which comprises the following steps: the client creates an xmlhttp request object and a callback object; the xmlhttp request object asynchronously sends the http request distributed by the client to the server; the server receives and processes all The http request, after interacting with the database, returns the operation result of the database to the xmlhttp request object; the callback object calls the operation result from the xmlhttp request object, sends the operation result to the client, and updates the client . The invention also discloses a data query system. By introducing an asynchronous communication mechanism, the present invention avoids the interaction between a large number of databases at the same time, reduces the overhead of the application system, lowers the operating pressure of the server side, reduces the access pressure of the database, and improves the efficiency of data query.

Description

technical field [0001] The invention relates to the field of computers, in particular to a data query method and system. Background technique [0002] The tree structure is a kind of nonlinear data structure, which is a set with a hierarchical relationship composed of a finite number of nodes, and there are branches between the nodes. In the query of a large amount of data, especially when the data is stored in a tree structure, the efficiency of the query is more concerned. [0003] Existing methods for querying data stored in a tree structure such as figure 1 As shown, it submits the page in units of forms. The process of this method is as follows: [0004] Step 101, the client sends an http (Hypertext Transfer Protocol) request to the server. [0005] The client can be specific software or a general browser, such as Internet Explorer, Firefox, Opera, etc. The client triggers an http request through a button or key operation and sends it to the server. [0006] Step...

AI Technical Summary

Problems solved by technology

[0011]First of all, if only the data of a certain part of the page needs to be updated, after the client sends an http request, the database will query all the data related to this part on the page and By returning the response information of the http request from the server, the client will refresh the entire page, causing additional overhead for data query and wasting a lot of bandwidth;

[0012]Secondly, the client triggers an http request by clicking a button, then waits for the server to respond, clicks another button to trigger another http request, and then waits for the server to respond Response, such an iterative process, the client must wait for the response of the http request before proceeding to the next step, resulting in low operation efficiency;

[0013] Furthermore, if there are multiple parts on the page that need to update data, the database will perform query operations sequentially in the same time period, causing a large transient query to the database The pressure makes this method less practical for large batches of data queries

Images