Oracle International Corporation

Venugopal Surendran

Ananth Venkata

Raghuram Venkatasubramanian

Saugata Chowdhury

Roger Bolsius

Jacques Vigeant

Alextair Dominico Mascarenhas

Harvard Pan

Ashish Mittal

Nikhil Surve

A computer-implemented method includes providing a fixed portion of a data model, uploading external files to an extended portion of the data model, matching at least some parts of the external files to the fixed portions of the data model, and using data from both the fixed and extended portions of the data model together. A computer-implemented method includes receiving a query from a user to a data model that includes a stored subject area portion and a stored extended subject area portion, accessing at least one storage to retrieve the subject area portion and the extended subject area portion, joining relevant portions of the subject area and extended subject area, extracting answers to the query from the joined portions, and reporting the answers to the user.

Uploading external files and associating them with existing data models

An administration tool can be used to provide data flexibility in a business intelligence (BI) server that is associated with a data warehouse. The administration tool can display one or more data objects that are adapted to be imported from an application framework into a physical model maintained on the BI server. The administration tool can further map the one or more data objects in the physical model into a logical model, also maintained on the BI server, which corresponds to at least one target table in the data warehouse. Additionally, the administration tool can publish an extension input to an extender associated with the data warehouse based on the logical model, wherein the extender operates to generate one or more metadata extensions based on the extension input.

System and method for providing data flexibility in a business intelligence server using an administration tool

An input extension specification can be generated, via an administration tool on a business intelligence (BI) server, for an extender associated with a data warehouse in order to extend the data warehouse. The administration tool can request for data flow information of the data warehouse from the extender. The data flow information indicates the mapping relationship between one or more source data objects and one or more target tables in the data warehouse. The administration tool further allows a user to select said one or more target tables in the data warehouse to be extended based on the data flow information, and builds the input extension specification for the extender.

System and method for specifying metadata extension input for extending data warehouse

An extender associated with a data warehouse can support metadata extension for the data warehouse. The extender can create an ETL extension plan for extending the data warehouse. The ETL extension plan includes one or more ETL plan elements that indicate extensions on ETL metadata objects. The one or more ETL plan elements within the ETL extension plan can be ordered, and ETL metadata extension can be performed based on the ETL extension plan.

Growing community of inventors

Santa Clara, CA, United States of America

Venugopal Surendran