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

Query plan converting method and device

A technology of query planning and planning, applied in the computer field, can solve problems such as application scene restrictions, and achieve the effect of reducing the number

Inactive Publication Date: 2016-06-01
HUAWEI TECH CO LTD +1
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] However, this technique requires that the two query operators have exactly the same partition attributes and have a direct predecessor-successor relationship, which limits the application scenarios of this technique.

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 plan converting method and device
  • Query plan converting method and device
  • Query plan converting method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0063] An embodiment of the present invention provides a query plan conversion method, which can be applied to the process of converting a logical query plan into a physical query plan, such as figure 1 As shown, the query plan transformation method includes:

[0064] S101. The query plan conversion device extracts a first query operator and a second query operator from a logical query plan, where the first query operator is a predecessor operator of the second query operator.

[0065] Wherein, the method for the query plan conversion device to extract the first query operator and the second query operator from the logical query plan may include: the query plan conversion device searches the logical query plan for two query operators that have a predecessor-successor relationship, And respectively determine the partition attributes of the two query operators with the predecessor-successor relationship; when the partition attribute of the predecessor query operator in the two q...

Embodiment 2

[0083] An embodiment of the present invention provides a query plan conversion method, which can be applied in the process of converting a logical query plan to a physical query plan. The query plan conversion method includes:

[0084] S201. The query plan conversion device extracts a first query operator and a second query operator from a logical query plan, where the first query operator is a predecessor operator of the second query operator.

[0085] The first query operator being the predecessor operator of the second query operator may specifically include: the first query operator being the direct predecessor operator of the second query operator, the interval between the first query operator and the second query operator There is a third query operator.

[0086] In the first application scenario of the embodiment of the present invention, such as image 3 As shown, after the query plan conversion device extracts the first query operator and the second query operator, t...

Embodiment 3

[0152] An embodiment of the present invention provides a query plan conversion device, such as Figure 8 As shown, it includes: an extracting unit 31 , a first rewriting unit 32 , a deleting unit 33 and a generating unit 34 .

[0153] The extracting unit 31 is configured to extract a first query operator and a second query operator from the logical query plan, where the first query operator is a predecessor operator of the second query operator.

[0154] The first rewriting unit 32 is used to rewrite the second query operator in the logical query plan if the partition attribute of the first query operator extracted by the extraction unit 31 is the prefix of the partition attribute of the second query operator extracted by the extraction unit. A partition attribute such that the partition attribute of the second query operator is the same as the partition attribute of the first query operator.

[0155] The deleting unit 33 is configured to delete the partition operator of the ...

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 embodiment of the invention discloses a query plant converting method and a query plan converting device, relates to the field of computers, which can greatly reduce the quantity of physical query tasks constituting a physical query plan. The query plan converting method specifically comprises the steps of extracting a first query operator and a second query operator from a logic query plan; if the partition property of the first query operator is the prefix of the partition property of the second query operator, rewriting the partition property of the second query operator in the logic query plan, thus allowing the partition property of the second query operator to be the same as the partition property of the first query operator; deleting the partition operator of the second query operator in the logic query plan, and generating a physical query task according to the second query operator, the first query operator and the partition operator of the first query operator to constitute the physical query plan. The query plant converting method is applied to the process of converting the logic query plan into the physical query plan.

Description

technical field [0001] The invention relates to the field of computers, in particular to a query plan conversion method and device. Background technique [0002] A logical query plan is a tree-like query structure that is parsed from a query statement and uses query operators in the query statement as nodes. Each query operator in the logical query plan has partition attributes and partition operators, partition attributes It is an attribute value common to all the data that the query operator needs to operate on. A partition operator is placed between this query operator and another query operator to separate the two query operators. A logical query plan can be transformed into a physical query plan. [0003] The specific process of transforming a logical query plan into a physical query plan is as follows: a partition operator is used as an identifier to generate a physical query task, and the query operator between the partition operator and the next partition operator ...

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 HUAWEI TECH CO LTD