Oracle International Corporation

Vijayakumar Ranganathan

Saugata Chowdhury

Dmitriy Gertsman

Ashish Mittal

Roger Bolsius

Alextair Dominico Mascarenhas

Samar Lotia

Kenneth Eng

Praful Hebbar

Mahadevan Rajagopalan

Yi Ge

David Wong

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 system and method for loading and transforming data to a cloud database, using a hybrid set-based extract, load, transform approach. During the loading and transforming of large amounts of data, from one or more data sources, a data synchronization application sends small batches of data, in parallel streams, to the database, which operates as a transformation engine to load the data. Each stream can be associated with a separate staging table in the database. For each staging table, the subset of data therein is transformed and loaded, before the next subset is processed. A transform and merge process operating at the database can then be used to transform and merge the data, from each of the staging tables, to the target table.

System and method for providing a hybrid set-based extract, load, and transformation of data

Growing community of inventors

Woodside, CA, United States of America

Vijayakumar Ranganathan