Oracle International Corporation

Pavan Ananthamurthy

Ananth Venkata

Balaji Krishnan

Joseph Kuttikat

Saurabh Verma

Matthew Bedin

In accordance with an embodiment, described herein is a system and method for providing support for extensibility and customization in an analytic applications environment. An extract, transform, load (ETL) or other data pipeline or process provided by the analytic applications environment, can operate in accordance with an analytic applications schema and/or a customer schema associated with a customer (tenant), to receive data from the customer's enterprise software application or data environment, for loading into a data warehouse instance. A semantic layer enables the use of custom semantic extensions to extend a semantic model, and provide custom content at a presentation layer. Extension wizards or development environments can guide users in using the custom semantic extensions to extend or customize the semantic model, through a definition of branches and steps, followed by promotion of the extended or customized semantic model to a production environment.

System and method for customization in an analytic applications environment

In accordance with an embodiment, described herein is a system and method for providing extensibility in an analytic applications environment, including a semantic layer that enables the use of custom semantic extensions to extend a semantic data model (semantic model). In accordance with an embodiment, when customizations are made to the semantic model, the system stores changes to the semantic model as an action-set, rather than as a changed-state. This allows the system to replay changes on the factory model, to get back to a desired end state, much as an operating system update does not affect the underling setup.

System and method for semantic model action sets and replay in an analytic applications environment

In accordance with an embodiment, described herein is a system and method for providing extensibility in an analytic applications environment, including a semantic layer that enables the use of custom semantic extensions to extend a semantic data model (semantic model). In accordance with an embodiment, the system enables use of a fragmented query model—when customizations are made to the semantic model, the system can dynamically merge the changes from the various deltas when queries are generated at runtime, to dynamically surface appropriate data based on the extended semantic model.

System and method for use of a fragmented query model in an analytic applications environment

In accordance with an embodiment, described herein is a system and method for providing extensibility in an analytic applications environment, including a semantic layer that enables the use of custom semantic extensions to extend a semantic data model (semantic model). In accordance with an embodiment, customizations to the out-of-the-box semantic model are performed using a layered approach, wherein the factory code for the semantic model remains intact, with changes/delta editable by the customer layered on top of that model, such that the changes can be patched/reversed if necessary.

Growing community of inventors

Bengaluru, India

Pavan Ananthamurthy