Query implementation method and device for database cluster
An implementation method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of long waiting time, shortening, and shortening the average waiting time of concurrent queries, so as to reduce response time and reduce mutual waiting , the effect of shortening the waiting time
Active Publication Date: 2017-03-29
DAWNING INFORMATION IND BEIJING +1
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] Aiming at the problem that the independent scheduling method in the related art causes the execution of the query task to always be limited to the slowest execution node, resulting in a long query waiting time, the present invention proposes a query implementation method and device for database clusters, It can well solve the problem of synchronous execution control between multiple database nodes, and can shorten the average waiting time of concurrent queries (up to 50%)
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0039] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments of the present invention belong to the protection scope of the present invention.
[0040] According to an embodiment of the present invention, a query implementation method for database clusters is provided, such as figure 2 As shown, the method includes:
[0041] Step S201, after receiving the query request, generate a unique query identifier corresponding to the query request, analyze the query request, and determine the query subtask;
[0042] Step S203, for each query subtask, send the query subtask and the query identifier to the database node capable of executing th...
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
Login to View More Abstract
The invention discloses an inquiry implementation method for a database cluster and a device. The inquiry implementation method comprises the following steps: receiving an inquiry request, then generating a uniqueness inquiry identifier corresponding to the inquiry request, analyzing the inquiry request, determining inquiry subtasks, sending each inquiry subtask and the inquiry identifier to a database node capable of implementing the inquiry subtask, and receiving inquiry results returned from the database node; moreover, receiving the inquiry request, then generating a parameter identifier corresponding to the inquiry request, sending the parameter identifier to the database node, and receiving each database node of the parameter identifier, and scheduling and implementing the inquiry subtask according to the received parameter identifier and a preset parameter window, so as to obtain inquiry results. The method can reduce the waiting time among a plurality of database servers and reduce the response time of inquiry processing.
Description
technical field [0001] The present invention relates to the field of communications, in particular to a query implementation method and device for database clusters. Background technique [0002] In a large-scale data cluster, the data of a table is usually distributed on multiple database nodes according to a certain strategy, so the query processing must be carried out on multiple database nodes at the same time, and the results returned by each node are aggregated or combined. Only then can the final query results be obtained. When multiple parallel query tasks are being executed in the system, since the scheduling of query tasks by each database node is independent of each other, it may cause the scheduling order of multiple query tasks on different nodes to be inconsistent. Different, usually the completion of a parallel query task always depends on the slowest one among all the nodes participating in the query processing. [0003] figure 1 It is an example of databas...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 宋怀明王勇苗艳超刘新春邵宗有
Owner DAWNING INFORMATION IND BEIJING