Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

Inactive Publication Date: 2010-05-12
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of implementing the present invention, the inventor found that: since the database sends all the found data to the client, it takes a lot of transmission bandwidth
Since the found data needs to be stored in the cache, a large amount of cache is consumed when the amount of found data is large or there are many concurrent queries; when there are many concurrent queries, a large amount of cache and access to the cache are consumed and the system responds slowly

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Query method and system of database, client side, server and database
  • Query method and system of database, client side, server and database
  • Query method and system of database, client side, server and database

Examples

Experimental program
Comparison scheme
Effect test

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...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a query method and a system of database, a client side, a server and a database. The method realizing on the client side comprises the following steps: receiving a first query command input by users by providing a visual interface to a user, wherein the first query command comprises a filtering condition of data needing to be queried; sending the first query command to a server; receiving and displaying a major key listing returned by the server; receiving a second query command input by users by the visual interface provided for the user; sending the second query command to the server, wherein the second query command comprises a major key assembly needing to be queried in a major key listing; receiving and displaying data which corresponds to the major key assembly and is returned by the server. One query is divided into two stages, thus reducing sending data amount; because the data quantity queried in the second stage is less if compared with all data, occupied cache is less; because sending data quantity and occupied cache are decreased, the query speed is higher.

Description

technical field [0001] The invention relates to the technical field of data storage, in particular to a database query method and system, a client, a server and a database. Background technique [0002] The database is used to store various data, and the user can query the required data from the database when the data is needed. Existing query method: on the database side, the database receives the query command sent by the client, and the above query command includes the filtering conditions of the data to be queried; the database searches the data stored in the database according to the received filtering conditions, and sends All found data is sent to the client. On the client side, the client stores the received data in the cache in the form of a cursor; the client then receives the serial number of the display page input by the user, and then uses the cursor to find the data corresponding to the display page of the above serial number, and The data corresponding to th...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 李家才
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products