Search International and National Patent Collections

1. (WO2018120171) METHOD, DEVICE AND SYSTEM FOR EXECUTING STORED PROCEDURE

Pub. No.:    WO/2018/120171    International Application No.:    PCT/CN2016/113845
Publication Date: Fri Jul 06 01:59:59 CEST 2018 International Filing Date: Sat Dec 31 00:59:59 CET 2016
IPC: G06F 17/30
Applicants: HUAWEI TECHNOLOGIES CO., LTD.
华为技术有限公司
Inventors: YING, Shanshan
应珊珊
ZHU, Junhua
朱俊华
Title: METHOD, DEVICE AND SYSTEM FOR EXECUTING STORED PROCEDURE
Abstract:
A method for executing a stored procedure, relating to the technical field of databases, in particular to a technique for processing a stored procedure (SP) in a database. The method for executing comprises: receiving an execution request used for requesting execution of a task comprising at least two stored procedures; applying for at least two threads, and assigning 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 executing the stored procedures comprised in the task, and grouping and caching the received SQL statements according to the same access characteristics; and calling an SQL statement execution engine to execute an SQL statement in an SQL statement cache group that meets a preset triggering condition. Applying the described solution to the execution of a plurality stored procedures may improve the efficiency in executing the plurality of stored procedures.