公开(公告)号：US20190324952A1

公开(公告)日：2019-10-24

申请号：US16458684

申请日：2019-07-01

Applicant: Huawei Technologies Co., Ltd.

Inventor： Shanshan Ying ,  Junhua Zhu

IPC: G06F16/21 ,  G06F16/242 ,  G06F16/2455

Abstract: A stored-procedure execution method includes receiving an execution request, where the execution request is used to request to execute a task including at least two stored procedures, requesting at least two threads, and dispatching each stored procedure in the task to one of the at least two threads for execution, receiving Structured Query Language (SQL) statements sent by the at least two threads when the at least two threads execute the stored procedures included in the task, and grouping and caching the received SQL statements based on a same access characteristic, and for an SQL statement cache group that satisfies a preset trigger condition, calling an SQL statement execution engine to execute an SQL statement in the SQL statement cache group.

公开(公告)号：US11182353B2

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

申请号：US16458684

申请日：2019-07-01

Applicant: Huawei Technologies Co., Ltd.

Inventor： Shanshan Ying ,  Junhua Zhu

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/242

Abstract: A method includes receiving an execution request, where the execution request is used to request to execute a task including at least two stored procedures, requesting at least two threads, and dispatching each stored procedure in the task to one of the at least two threads for execution, receiving Structured Query Language (SQL) statements sent by the at least two threads when the at least two threads execute the stored procedures included in the task, and grouping and caching the received SQL statements based on a same access characteristic, and for an SQL statement cache group that satisfies a preset trigger condition, calling an SQL statement execution engine to execute an SQL statement in the SQL statement cache group.