Database query method and system

A query method and query system technology, which can be used in electrical digital data processing, special data processing applications, instruments, etc., and can solve problems such as database congestion.

Inactive Publication Date: 2016-01-13
ULTRAPOWER SOFTWARE
View PDF4 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the above problems, the embodiment of the present invention provides a database query method and system, which compresses multiple SQL requests into one, which can reduce the burden on the database, thereby solving the technical problem of database congestion caused by multiple database requests

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
  • Database query method and system
  • Database query method and system
  • Database query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] In order to make the object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0058] The technical problem to be solved by the embodiment of the present invention: when the same SQL requests the database at the same time, it only requests once and returns the result, and other requests obtain the result of this request.

[0059] see figure 1 , the embodiment of the present invention provides a database query method, which specifically includes the following steps:

[0060] S101: Receive a database query request.

[0061] There are multiple types of database query requests, such as URL requests and SQL requests.

[0062] S102: Determine whether the database query request is an initial request.

[0063] As preferably, in this step, judging whether the database query request is an initial request may specifically ...

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 invention discloses a database query method and system, and relates to the technical field of databases. The method of the embodiment of the invention comprises the following steps: receiving a database query request; judging whether the request is a primary request or not; if the request is the primary request, executing a corresponding database query operation, and storing a query result into a cache; and if the request is not the primary request, obtaining the query result of the database query request in the cache. When the same SQLs simultaneously query the database, the SQLs only query one time and return a result, other requests obtain the result of the first request, i.e., under a certain condition, only first-time SQL language query takes effect within a period of time, and the rest waits for the query result. Multiple-time SQL requests are compressed into one-time SQL request, the burden of the database can be lightened so as to solve the technical problem of database congestion caused by the multiple-time database requests, the result set returning speed of SQL query can be improved, the result set which is subsequently requested to use is the result set which is requested the first time, and query time is greatly shortened.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database query method and system. Background technique [0002] Many common systems on the market now have one or more database requests attached to one page, such as catalog pages, tree node pages, query condition pages, reports, and so on. Accessing such a page is often accompanied by a database request, and multiple refreshes of the same page corresponding to the database request will also use the same SQL to query the database multiple times. [0003] When the existing database SQL is queried, every time the user requests a page, there will be an SQL to query the database. When the same page is refreshed multiple times, multiple identical SQL requests will be issued and the database will be queried multiple times. All queries will be sent to the database to increase congestion and cause unnecessary burden on the database. Therefore, there is an urgent need for a solutio...

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 ULTRAPOWER SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap