Oracle International Corporation

Balaji Krishnan

Ananth Venkata

Pavan Ananthamurthy

Joseph Kuttikat

Saurabh Verma

Ajai Joy

Matthew Bedin

Junsheng Du

Prasenjit Gayen

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 are systems and methods for automatic generation of business intelligence (BI) data models using data introspection and curation, as may be used, for example, with enterprise resource planning (ERP) or other enterprise computing or data analytics environments. The described approach uses a combination of manually-curated artifacts, and automatic generation of a model through data introspection, of a source data environment, to derive a target BI data model. For example, a pipeline generator framework can evaluate the dimensionality of a transaction type, degenerate attributes, and application measures; and use the output of this process to create an output target model and pipeline or load plan. The systems and methods described herein provide a technical improvement in the building of new subject areas or a BI data model within much shorter periods of time.

System and method for automatic generation of BI models using data introspection and curation

Techniques for transitioning between message infrastructure platforms are disclosed. A platform manager transmits a data stream using a first message infrastructure platform. A platform monitor monitors transmission characteristics associated with the transmission of the data stream using the first message infrastructure platform. A platform selector selects a second message infrastructure platform based on the transmission characteristics. A platform transitioner transitions from transmitting the data stream using the first message infrastructure platform to transmitting the data stream using the second message infrastructure platform seamlessly.

Message infrastructure platform transitions based on subscription heuristics

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 unique identifiers for use with enterprise software application environments. A unique ID server (service) operates to provide calling applications with unique identifiers, for use by the applications in storing, accessing, or using data stored at a database or data warehouse. A database sequence provided by the database can be leveraged for issuing unique ID sequences for use by the applications. A calling application can reserve and/or request, via the unique ID service, sequences of unique IDs, ahead of time, either as a single sequence or bulk sequence. The unique ID can be subsequently used within the enterprise application environment for various purposes.

System and method for providing unique identifiers for use with enterprise application environments

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

Pleasanton, CA, United States of America

Balaji Krishnan