Oracle International Corporation

Praful Hebbar

Kenneth Eng

Ashish Mittal

Roger Bolsius

Alextair Dominico Mascarenhas

Samar Lotia

Vijayakumar Ranganathan

Yi Ge

Gilberto Monroy

David Wong

Mahadevan Rajagopalan

In accordance with an embodiment, described herein is a system and method for providing query acceleration 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 middle layer is provided as a long-term table data storage format; and one more acceleration formats, or acceleration tables, can be periodically regenerated from the middle layer, wherein a determination can be made as to whether an accelerated table exists for a dataset table, and if so, then the accelerated table is used to process the query.

System and method for query acceleration for use with data analytics environments

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.

Query execution debugger for use with business intelligence and data analytics environments

Growing community of inventors

Bengaluru, India

Praful Hebbar