公开(公告)号：US11169994B2

公开(公告)日：2021-11-09

申请号：US16157752

申请日：2018-10-11

Applicant: Huawei Technologies Co., Ltd.

Inventor： Lei Qiu ,  Maozeng Li ,  Haiyan Huang

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/2455

Abstract: A query method and a query device, where the method includes determining N execution plans respectively corresponding to N query requests according to the received N query requests, determining at least two same first sub-plans, generating a first sub-query result corresponding to any one of the at least two same first sub-plans, and in a process of generating, according to the N query requests, a query result corresponding to each of the N query requests, the same first sub-query result corresponding to any one of the first sub-plans is used for all the same first sub-plans. Hence, a large amount of repeated calculation can be reduced, database system resources are reduced, and query efficiency and a throughput of a database system in a large-scale concurrent query application scenario are improved.

公开(公告)号：US20190042621A1

公开(公告)日：2019-02-07

申请号：US16157752

申请日：2018-10-11

Applicant: Huawei Technologies Co., Ltd.

Inventor： Lei Qiu ,  Maozeng Li ,  Haiyan Huang

IPC: G06F17/30

Abstract: A query method and a query device, where the method includes determining N execution plans respectively corresponding to N query requests according to the received N query requests, determining at least two same first sub-plans, generating a first sub-query result corresponding to any one of the at least two same first sub-plans, and in a process of generating, according to the N query requests, a query result corresponding to each of the N query requests, the same first sub-query result corresponding to any one of the first sub-plans is used for all the same first sub-plans. Hence, a large amount of repeated calculation can be reduced, database system resources are reduced, and query efficiency and a throughput of a database system in a large-scale concurrent query application scenario are improved.

公开(公告)号：US10901976B2

公开(公告)日：2021-01-26

申请号：US15495569

申请日：2017-04-24

Applicant: Huawei Technologies Co., Ltd.

Inventor： Huijun Liu ,  Yang Ren ,  Maozeng Li ,  Feng Han

IPC: G06F17/00 ,  G06F7/00 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2453

Abstract: A method and an apparatus for determining a structured query language (SQL) execution plan are provided to optimize determining of the SQL execution plan and improve execution efficiency of the SQL execution plan. The SQL execution plan corresponds to at least one relation table. During an Nth iteration, the method includes obtaining a first iteration parameter generated after a first plan tree is executed on the at least one relation table during an (N−1)th iteration, where N is a natural number greater than 1, establishing a second plan tree according to the first iteration parameter, and determining the first plan tree or the second plan tree as the SQL execution plan when a difference between the second plan tree and the first plan tree is not greater than a first threshold.

公开(公告)号：US20170242884A1

公开(公告)日：2017-08-24

申请号：US15495569

申请日：2017-04-24

Applicant: Huawei Technologies Co., Ltd.

Inventor： Huijun Liu ,  Yang Ren ,  Maozeng Li ,  Feng Han

IPC: G06F17/30

CPC classification number: G06F16/235 ,  G06F16/2246 ,  G06F16/24542 ,  G06F16/24545

Abstract: A method and an apparatus for determining a structured query language (SQL) execution plan are provided to optimize determining of the SQL execution plan and improve execution efficiency of the SQL execution plan. The SQL execution plan corresponds to at least one relation table. During an Nth iteration, the method includes obtaining a first iteration parameter generated after a first plan tree is executed on the at least one relation table during an (N−1)th iteration, where N is a natural number greater than 1, establishing a second plan tree according to the first iteration parameter, and determining the first plan tree or the second plan tree as the SQL execution plan when a difference between the second plan tree and the first plan tree is not greater than a first threshold.