Method and device for executing query tasks on database

An execution method and a technology of an execution device, which are applied in the field of query task execution and can solve problems such as database resource preemption

Active Publication Date: 2015-03-25
BEIJING GRIDSUM TECH CO LTD
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The main purpose of the present invention is to provide a database query task execution method and device to solve the problem in the prior art that multiple time-consuming query operations preempt database resources when performing multiple time-consuming query operations on a database at the same time

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
  • Method and device for executing query tasks on database
  • Method and device for executing query tasks on database
  • Method and device for executing query tasks on database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0028] It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate ...

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 method and a device for executing query tasks on a database. The method for executing the query tasks includes acquiring to-be-executed first query tasks; storing the first query tasks into queues pointed by identification; acquiring task serial numbers of various query tasks stored in the queues; executing the various query tasks stored in the queues according to the task serial numbers. The first query tasks carry the identification of the database occupied by the first query tasks. The various query tasks stored in the queues include the first query tasks. The method and the device have the advantages that the problem of database resource preemption of a plurality of time-consuming queries when the time-consuming queries are simultaneously executed on the same database in the prior art can be solved by the aid of the method and the device, and an effect of executing various query operations in a serialized manner when the multiple time-consuming query operations are simultaneously executed on the single database can be realized.

Description

technical field [0001] The present invention relates to the field of data processing, in particular to a method and device for executing a query task of a database. Background technique [0002] When multiple applications perform query operations on a database at the same time, if the resources occupied by the query operations (such as: CPU calculation, IO read and write, etc.) It takes a long time to complete (it will exceed the time required for serial execution of all query operations), or even impossible to complete. [0003] Among them, IO is Input / Output, that is, input / output. [0004] In the prior art, for this situation, the general solution is to optimize the SQL query statement to maximize the performance of the database. This solution can only meet the requirements for query operations with a small amount of data. In the case of statistically querying a very large amount of data (on the order of billions), the existing solutions cannot solve the problem well. ...

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
CPCG06F16/24549G06F16/24578
Inventor 陈国兴
Owner BEIJING GRIDSUM TECH CO LTD
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