US 12,105,721 B2
Enterprise resource planning system, server and supervision method of SQL queries in such a system or server
Arnaud Khuat-Duy, Massy (FR); and Nicolas Souquet, Massy (FR)
Assigned to Ivalua SAS, Massy (FR)
Filed by Ivalua SAS, Massy (FR)
Filed on Oct. 8, 2021, as Appl. No. 17/497,716.
Application 17/497,716 is a continuation of application No. PCT/EP2020/060173, filed on Apr. 9, 2020.
Claims priority of application No. 19305464 (EP), filed on Apr. 10, 2019.
Prior Publication US 2022/0027365 A1, Jan. 27, 2022
Int. Cl. G06F 16/2458 (2019.01); G06F 11/34 (2006.01); G06Q 10/0631 (2023.01)
CPC G06F 16/2458 (2019.01) [G06F 11/3495 (2013.01); G06Q 10/06315 (2013.01)] 16 Claims
OG exemplary drawing
 
10. A method of supervising SQL queries in an enterprise resource planning system, comprising:
executing an SQL query based on an execution plan to access the SQL database;
generating execution data relative to the execution of each SQL query;
receiving an SQL query from a user terminal;
determine an estimated execution plan metric associated with executing the SQL query according to the execution plan, the estimated execution plan metric indicating the number of lines, rows or tuples issued from the SQL database for the SQL query when using the execution plan;
determining whether a hardware performance metric associated with executing the query plan exceeds a hardware performance metric threshold, the hardware performance metric indicating hardware resources used to execute the execution plan;
in response to determining that the hardware performance metric exceeds the hardware performance metric threshold, determining whether an execution plan metric associated with executing the execution plan exceeds the estimated execution plan metric;
in response to determining the execution plan metric exceeds the estimated execution plan metric, determine that the SQL query is invalid.