US 12,332,884 B2
Analysis of temporary queries in a relational statement
Chanakya Kaspa, Mckinney, TX (US)
Assigned to Capital One Servicees, LLC, McLean, VA (US)
Filed by Capital One Services, LLC, McLean, VA (US)
Filed on Jul. 21, 2023, as Appl. No. 18/356,440.
Prior Publication US 2025/0028717 A1, Jan. 23, 2025
Int. Cl. G06F 16/245 (2019.01); G06F 11/34 (2006.01); G06F 16/2452 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24534 (2019.01) [G06F 11/3419 (2013.01); G06F 16/24524 (2019.01); G06F 16/24552 (2019.01)] 19 Claims
OG exemplary drawing
 
1. A system for analysis of temporary queries in a relational statement, the system comprising:
one or more memories; and
one or more processors, communicatively coupled to the one or more memories, configured to:
obtain a structured query language (SQL) statement associated with one or more operations associated with a database;
identify one or more common table expression (CTE) queries included in the SQL statement,
wherein the one or more CTE queries are associated with temporary query results that exist for a duration of an execution of the SQL statement;
modify the SQL statement to include segment indicators for respective segments of the SQL statement associated with respective CTE queries from the one or more CTE queries;
execute the SQL statement to perform the one or more CTE queries;
determine, during the execution of the SQL statement and based on the segment indicators, one or more execution performance parameters for each segment included in the SQL statement, wherein the one or more execution performance parameters indicate performance levels of the one or more CTE queries;
generate, based on the determined one or more execution performance parameters, a CTE database indicating the determined one or more execution performance parameters for the each segment; and
provide, to a device, the CTE database.