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

Analytical method for data query under cluster database system environment

A technology of data query and analysis method, which is applied in the field of data query analysis under the cluster database system environment, and can solve problems such as complex query algorithms and affecting query efficiency.

Inactive Publication Date: 2013-09-18
DAWNING INFORMATION IND BEIJING
View PDF2 Cites 36 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Existing nested queries will query and exchange multiple data tables and database nodes, which usually leads to complex query algorithms, which seriously affects query efficiency

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
  • Analytical method for data query under cluster database system environment
  • Analytical method for data query under cluster database system environment
  • Analytical method for data query under cluster database system environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0031] The logical structure of the cluster database query service is as follows: figure 1 As shown, the client submits a SQL (Structured Query Language, Structured Query Language) query statement to the query server 20 . Then the query server 20 parses and optimizes the SQL query statement to generate a parallel execution query task flow and submits it to the database node 30 . Each database node 30 executes the query after receiving the query task, and obtains the query result, and then each database node 30 sends the obtained query result to the query server 20 respectively. Finally, the query server 20 summarizes the query results and returns them to the client 10 .

[0032] figure 2 It is a schematic flowchart of a data query analysis method in a cluster database system environment according to an embodiment of the invention. Such as figure 2 Said...

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 an analytical method for data query under a cluster database system environment. The method comprises the following steps: analyzing a first SQL (Structured Query Language) sentence after receiving a query request of the first SQL sentence from a client-side, and enabling the first SQL sentence subjected to grammar analysis to be a syntax tree shown with a SelectStmt structure, analyzing the syntax tree and constructing a corresponding query task tree, and optimizing the query task tree according to pre-determined optimization rules and generating a query task stream, wherein the query task tree comprises a plurality of levels of query task nodes, the same level includes one or more query task nodes, one query task node corresponds to one query task, and a plurality of query task nodes in the same level are generated into query tasks in mutual parallel execution. With the adoption of the method, the parallel operation capacity of a cluster database system with a shared-nothing structure can be fully utilized.

Description

technical field [0001] The present invention relates to the technical field of data processing, and more specifically, relates to a data query analysis method under the environment of a cluster database system. Background technique [0002] A cluster database system usually consists of multiple database nodes interconnected using a shared-nothing structure (Shared-nothing), and data is stored in each database node in a distributed manner. [0003] Usually in a cluster database system, query statements are parsed (including lexical analysis, syntax analysis, and semantic decomposition and optimization), decomposed into query execution tasks, and submitted to the database nodes for execution to obtain query results. One existing method of executing queries is nested queries. For example, a query that nests another SELECT statement in the WHERE clause, FROM clause, or HAVING clause of a SELECT statement is called a nested query (also known as a subquery) . Existing nested que...

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