Query method and system of database, client side, server and database
A query method and database technology, which is applied in the field of database query, can solve the problems of consuming cache and accessing cache, consuming a large amount of cache, slow system response, etc., so as to reduce the amount of data, increase the query speed, and reduce the amount of sent data Effect
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0074] Embodiment 1. The embodiment of the present invention provides a database query method, which is implemented on the terminal side, such as figure 1 shown, including:
[0075] 101: Receive a first query command input by the user through a visual interface provided for the user, where the first query command includes filter conditions for querying data;
[0076] 102: Send the above-mentioned first query command to the server;
[0077] 103: Receive and display the primary key list returned by the server;
[0078] Since there may be many items in the primary key list, it can be transmitted in an asynchronous manner, specifically: in the above 103, receiving and displaying the primary key list returned by the server includes: receiving a sub-list sent in an asynchronous manner, and the above-mentioned sub-list is separated from the primary key list Divided into a set length.
[0079] 104: Receive a second query command input by the user through a visual interface provided...
Embodiment 2
[0095] Embodiment 2. The embodiment of the present invention provides a specific example to illustrate the query method of the database. In this embodiment, the query of an order is taken as an example. The filter conditions include: "amount" (amount) > 100, such as Figure 4 shown, including the following steps:
[0096] 401: The user first needs to determine the primary key of the order query, such as the FID in the order table example 1;
[0097] Table 1. Order form example
[0098]
[0099] 402: if Figure 5As shown, the client provides the user with a visual interface to receive the filter conditions entered by the user; according to the filter conditions entered by the user, the query statement of this query is obtained: select FID Fromorder Where amount > 100, and the query statement is sent to server;
[0100] 403: The server forwards the query statement from the client to the database;
[0101] 404: The database obtains all primary key IDs according to the quer...
Embodiment 3
[0113] Embodiment three, as Figure 7 As shown, the embodiment of the present invention also provides a client, including:
[0114] The query command receiving unit 701 is used to receive the first query command input by the user through the visual interface provided for the user, and the above-mentioned first query command includes the filtering conditions for querying data; receive the second query command input by the user through the visual interface provided for the user. query command;
[0115] A query command sending unit 702, configured to send the above-mentioned first query command to the server; send the above-mentioned second query command to the server, and the above-mentioned second query command includes a set of primary keys that need to be queried in the primary key list;
[0116] The receiving and displaying unit 703 is configured to receive and display the primary key list returned by the server; receive and display the data corresponding to the set of prim...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com