公开(公告)号：US12248464B2

公开(公告)日：2025-03-11

申请号：US17395816

申请日：2021-08-06

Applicant: Oracle International Corporation

Inventor： Kenneth Eng ,  Praful Hebbar ,  Gilberto Monroy

IPC: G06F16/242 ,  G06Q10/067

Abstract: In accordance with an embodiment, described herein is a query execution debugger, for use with a computing environment such as, for example, a business intelligence environment, database, data warehouse, or other type of environment that supports data analytics. A query engine, for example a business intelligence server instance, serves analytics queries or requests from clients, directed to data stored at a database, in accordance with a query execution plan, wherein a logical query can include query language statements received from the clients; while a physical query includes database-specific statements that the query engine sends to the database to retrieve data when processing the logical query. The system can create a query execution debugger file that includes a record metadata portion or section, and a data portion or section, and which can be used to review, simulate, or debug the processing of queries against the database.

公开(公告)号：US20220138189A1

公开(公告)日：2022-05-05

申请号：US17395816

申请日：2021-08-06

Applicant: Oracle International Corporation

Inventor： Kenneth Eng ,  Praful Hebbar ,  Gilberto Monroy

IPC: G06F16/242 ,  G06Q10/06

Abstract: In accordance with an embodiment, described herein is a query execution debugger, for use with a computing environment such as, for example, a business intelligence environment, database, data warehouse, or other type of environment that supports data analytics. A query engine, for example a business intelligence server instance, serves analytics queries or requests from clients, directed to data stored at a database, in accordance with a query execution plan, wherein a logical query can include query language statements received from the clients; while a physical query includes database-specific statements that the query engine sends to the database to retrieve data when processing the logical query. The system can create a query execution debugger file that includes a record metadata portion or section, and a data portion or section, and which can be used to review, simulate, or debug the processing of queries against the database.