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

Method and system of execution plan information generation in distributed database

An execution plan and execution information technology, applied in the field of data processing, can solve problems such as not being able to understand DBproxy execution plan information, and achieve high execution efficiency

Active Publication Date: 2018-03-13
金篆信科有限责任公司
View PDF4 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, the explain technology of the MySQL database can only understand the execution plan information of the query statement in the MySQL database, but cannot understand the execution plan information at the DBproxy level

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 system of execution plan information generation in distributed database
  • Method and system of execution plan information generation in distributed database
  • Method and system of execution plan information generation in distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0025] The execution plan information generation method and system in the distributed database provided by the embodiments of the present invention, specifically, the method and system realize the generation of query statements (hereinafter referred to as SQL statements) in the distributed database database middleware (hereinafter referred to as " DBproxy layer") execution plan information (hereinafter referred to as "explain"), and...

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 system of execution plan information generation in a distributed database. The method is applied to database middleware in the distributed database, and includes: receiving a query statement sent by a client, and generating an execution plan tree of the query statement; and encapsulating execution information in the execution plan tree according to a set output format of execution plan information to generate the execution plan information of the query statement in the database middleware. The execution plan information generated by the scheme of the invention can help a developer in writing more optimized query statements.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and system for generating execution plan information in a distributed database. Background technique [0002] The distributed database system divides the data according to certain rules, distributes them to different database nodes, and finally summarizes the data at the DBproxy (database middleware) level. Since the amount of data stored in the database is very large, it is very important to write query statements with high execution efficiency in order to quickly query the qualified data information. At present, the explain (execution plan information) technology of the MySQL database is used to obtain the query execution plan of the query statement, return a row of information for each table in the query statement, and allow developers to understand how the MySQL database processes query statements and table connections , to help make tuning decisions and wri...

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
CPCG06F16/2433G06F16/24542G06F16/27G06F16/284Y02D10/00
Inventor 赵永辉
Owner 金篆信科有限责任公司