Unlock instant, AI-driven research and patent intelligence for your innovation.

Query scheduling method and query scheduler

A scheduling method and scheduler technology, applied in the computer field, can solve the problems of wasting database resources, out of control, and not knowing how long the query will take to complete, and achieve the effects of improving operating performance, reducing space complexity, and reducing query space

Pending Publication Date: 2022-06-21
AGRICULTURAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the database administrator terminates the query, the running results of the batch query will not be obtained, and database resources will be wasted. If you choose to continue waiting, the database administrator will not know how long it takes for these queries to complete, and the entire operation is in a state of "out of control"

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 scheduling method and query scheduler
  • Query scheduling method and query scheduler
  • Query scheduling method and query scheduler

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0057] In order to facilitate the understanding of the technical solutions of the present invention, the relevant terms of the present invention are explained as follows:

[0058] Query: SQL statement. According to different application scenarios, it is divided into transactional query and analytical query. The research object of the present invention is analytical query.

[0059] TPC-H: Business Intelligence Computing Test, a set of...

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

According to the query scheduling method and the query scheduler provided by the invention, the influence of two factors, namely the query independent response time and the emergency degree of the query, on the query priority is considered at the same time, only the query with the high priority is added into the query space, the query with the low priority is delayed to be executed, the query space is reduced, and the complexity of the query combination space is reduced. Then, by determining query interaction of each query in the query space added into a query combination formed by the current query queue, the query with smaller query interaction of the query combination is preferentially added into the current query queue, so that the query combination with smaller query interaction is preferentially executed, and the query optimization scheduling is realized; the database operation performance is effectively improved.

Description

technical field [0001] The invention relates to the field of computer technology, and more particularly, to a query scheduling method and a query scheduler. Background technique [0002] In a database system, query is its main workload, and the efficiency of query execution determines the performance of the database. [0003] In online analytical database systems, when queries are run individually, their response times range from minutes to hours. However, when a query with a long response time when running alone is added to the query combination, its response time will be longer, prolonging the running time of other queries, and continuously consuming database system resources. In some cases, there is even a "deadlock" of query execution. If the database administrator terminates the query, the running result of the batch query cannot be obtained, and database resources are wasted. If the database administrator chooses to continue to wait, the database administrator cannot...

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): G06F16/2457G06F16/2455G06F16/2453
CPCG06F16/24578G06F16/2455G06F16/2453
Inventor 裴泽锋张强强薛锴
Owner AGRICULTURAL BANK OF CHINA