Oracle Corporation
QUERY EXECUTION DEBUGGER FOR USE WITH BUSINESS INTELLIGENCE AND DATA ANALYTICS ENVIRONMENTS

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.