公开(公告)号：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.

公开(公告)号：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.