Cluster database system and data query processing method thereof

A processing method and data query technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of wasting more time, query speed reduction, user response speed reduction, etc., to reduce the overall execution time, The effect of reducing response time

Active Publication Date: 2013-06-05
DAWNING INFORMATION IND BEIJING +1
View PDF5 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the link of intermediate results obtained by the database system through subtask queries, for each intermediate result, it is necessary to wait for the completion of all subtask queries r

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
  • Cluster database system and data query processing method thereof
  • Cluster database system and data query processing method thereof
  • Cluster database system and data query processing method thereof

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0035] The present invention will be further described in detail below in conjunction with the drawings.

[0036] figure 2 It is a schematic structural diagram of a cluster database system according to an embodiment of the present invention. Such as figure 2 As shown, the cluster database system includes a query server 10 and multiple database systems 20.

[0037] After receiving the query task, the query server 10 parses the query task into at least one sub-query task. In an alternative embodiment, the number of sub-query tasks may be 1. Then, the query server 10 sends the at least one sub-query task to multiple database systems 20 respectively.

[0038] After receiving the sub-query task, multiple database systems 20 may execute the sub-query task in parallel. Among them, each database system can be assigned one or more sub-query tasks. In addition, for a database system in the process of executing a subquery task, it may sometimes need to use the query results of the previou...

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 data query processing method of a cluster database system. The data query processing method comprises that a query server enables a query task to be analyzed into at least one subquery task after receiving the query task; the query server sends the at least one subquery task to multiple database systems so as to execute in parallel the ate least one subquery task; first database systems in the multiple database systems carry out the subquery task while receiving relevant query result data which is obtained by executive relevant subquery tasks which are sent by other database systems; received relevant query result data are merged with query result data which is obtained by the first database system executive subquery task to form a query middle result; the query middle result serves as an input of a next subquery task, the next subquery task is carried out, or the query middle result is sent to the query server. The invention further discloses a cluster database system. By means of the cluster database system and the data query processing method thereof, overall execution time of the query can be reduced.

Description

technical field [0001] The present invention relates to the technical field of computer data processing, and more specifically, to a data query processing method of a cluster database system, a database system and a cluster database system. Background technique [0002] In the existing cluster database system, data is usually distributed in multiple database systems interconnected with a shared-nothing structure, and multiple database systems provide a single database image externally by way of framework middleware. The middleware system receives the user's SQL request, executes it in multiple underlying database systems, and then returns the final result to the user. Therefore, for users, using a cluster parallel database system is the same as using a single database. Usually, in a database, query statements are parsed (including lexical analysis, syntax analysis, and semantic decomposition and optimization) into query execution plans. The query execution plan may contain ...

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
IPC IPC(8): G06F17/30
Inventor 狄静舒宋怀明王颖苗艳超刘新春邵宗有
Owner DAWNING INFORMATION IND BEIJING
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