US 12,248,464 B2
Query execution debugger for use with business intelligence and data analytics environments
Kenneth Eng, Redwood City, CA (US); Praful Hebbar, Bangalore (IN); and Gilberto Monroy, Atizapán (MX)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Aug. 6, 2021, as Appl. No. 17/395,816.
Claims priority of provisional application 63/108,152, filed on Oct. 30, 2020.
Prior Publication US 2022/0138189 A1, May 5, 2022
Int. Cl. G06F 16/242 (2019.01); G06Q 10/067 (2023.01)
CPC G06F 16/2448 (2019.01) [G06Q 10/067 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system for providing a query execution debugger for use with business intelligence and data analytics environments, comprising:
a computer that serves analytical queries, including processing queries against a database according to query execution plans that include query execution plan components, wherein each query execution plan component is associated with one or more query statements that when executed access data at the database;
wherein during debugging of a query execution plan associated with the database, the system creates a plurality of query execution debugger files including, for a query execution plan component of the query execution plan:
receiving an indication of one or more filters to be used with the query execution plan component; and
executing the query statement as filtered, to retrieve from the database a sample of data, and store the sample of data in a query execution debugger file that includes as contents stored therein:
a record metadata portion or section, and
a data portion or section,
representing an intermediate result associated with the query execution plan as it executes the plan component, including a description of a data type associated with the plan component and the associated sample of data as retrieved from the database; and
wherein the system processes the contents of a query execution debugger file in debugging the processing of the query execution plan against the database, including:
receiving a modification to the record metadata or the sample of data as retrieved from the database and contained within the query execution debugger file; and
processing the contents of the query execution debugger file as modified, to simulate processing of the query execution plan against the database.