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

Inquiry request processing method and device

A technology of query request and processing method, which is applied in the field of data processing, can solve the problems of slow query response speed and low query efficiency, and achieve the effect of improving query response time and query efficiency

Active Publication Date: 2018-12-14
BEIJING OCEANBASE TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In related technologies, large queries and small queries have the same priority, resulting in slow response speed and low query efficiency under the concurrency control strategy of the database storage engine

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
  • Inquiry request processing method and device
  • Inquiry request processing method and device
  • Inquiry request processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] Embodiments of the present application are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary, and are only for explaining the present application, and should not be construed as limiting the present application. On the contrary, the embodiments of the present application include all changes, modifications and equivalents falling within the spirit and scope of the appended claims.

[0018] The method and device for processing query requests according to the embodiments of the present application are described below with reference to the accompanying drawings.

[0019] figure 1 It is a schematic flowchart of a method for processing a query request proposed by an embodiment of the present application, and the method includes:

[0020] ...

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 provides a query request processing method and device. The query request processing method comprises the following steps: receiving a thread which applies for entering a storage engine, wherein the thread is used for processing a current statement; after a situation that the thread applies for entering the storage engine is determined, distributing the current frequency of access permit for the thread; and distributing a first access permit numerical value for the thread, wherein the first access permit numerical number is inversely proportional to the current frequency. The method can shorten query response time based on a concurrency control strategy and improve the query efficiency of the storage engine.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a query request processing method and device. Background technique [0002] When online applications use databases, for OLTP (On-Line Transaction Processing) type applications, the result set of the query is generally small, that is, it needs only a few interactions with the storage engine to complete A query request, this type of query can be called a small query; however, online applications also have queries with large result sets or queries that do not use indexes correctly. The latter two queries require more interactions with the storage engine to Complete a query, this type of query can be called a large query. In related technologies, large queries have the same priority as small queries, resulting in slow query response speed and low query efficiency under the concurrency control strategy of the database storage engine. Contents of the invention ...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 刘浩刘辉
Owner BEIJING OCEANBASE TECH 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