Granted Patent B2

US 12,405,962 · App. 16/868,081 · Granted Sep 2, 2025

Inventors: Balaji Krishnan (Fremont, CA); Matthew Bedin (Denver, CO); Saurabh Verma (Cupertino, CA); Ananth Venkata (San Ramon, CA); Joseph Kuttikat (Bengaluru, IN); Pavan Ananthamurthy (Bengaluru, IN)

Assignee: ORACLE INTERNATIONAL CORPORATION

G06F16/254G06F8/65

Abstract

Claims (53)

1. A system for providing extensibility and customization in an analytic applications environment, comprising:

a computer including one or more processors, that provides access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants;

wherein each tenant of the plurality of tenants is associated with a customer tenancy, and with a tenant-specific customer schema maintained within their customer tenancy, for use in populating a data warehouse instance;

wherein the system performs an extract, transform, load or other data pipeline or process as defined by a combination of an analytic applications schema shared by the plurality of tenants and the tenant-specific customer schema associated with a tenant, to receive data from the tenant's enterprise software application or data environment, for loading into a data warehouse instance, and populate the data warehouse instance with the data received from the tenant's enterprise software application or data environment as defined by the combination of the analytic applications schema and the tenant-specific customer schema; and

a semantic layer that enables use of custom semantic extensions to extend a packaged semantic model, and provides custom content at a presentation layer, wherein the semantic layer includes:

an initial version of a semantic model usable to provide a packaged content, to access the data loaded from the tenant's enterprise software application or data environment, as defined by the combination of the analytic applications schema and the tenant-specific customer schema, into their data warehouse instance, and provide a packaged content to the presentation layer; and

one or more semantic extensions that when merged with the initial version of the semantic model, operate to modify operation of the semantic model and provide a custom content to the presentation layer, wherein each of a plurality of users are provided with an instance of the semantic model to provide modifications as extensions or customizations thereto as a separate branch, wherein the extensions or customizations provided by the plurality of users are then merged into the semantic model;

wherein the custom content is customized on a per tenant basis, for different tenants of the plurality of tenants, as determined by the semantic model including the extensions or customizations thereto;

wherein the presentation layer provides access to data in the data warehouse instance for each of the different tenants using the tenant's custom content at the presentation layer;

wherein an extension wizard provides instructions indicative of guided steps through customization and use of the custom semantic extensions and enables the user to edit or create a customization branch to extend or customize the semantic model, wherein selection of the branch provides the user with an instance of the semantic model to work with and incorporate their particular customizations or extensions, which customizations or extensions can then be promoted to a production environment;

wherein in response to immutable aspects of the semantic model being patched or updated, customizations provided as the custom semantic extensions are retained and automatically applied following the patch or update.

2. The system of claim 1 , wherein customizations or extensions developed by the multiple users can then be promoted to a production environment.

3. The system of claim 1 , wherein the analytic applications environment is provided within a cloud environment, and the semantic layer includes a physical layer that maps to a physical data model or data plane, a logical layer that operates as a mapping or transformation layer where calculations are defined.

4. The system of claim 1 , wherein the branch operates as an atomic work unit and includes one or more customization steps associated with customization types and corresponding extensions, and wherein the extension wizard is data-aware and provides a preview of underlying data as the branch is customized.

5. The system of claim 1 , wherein the customization branch is merged into the semantic model and wherein the semantic terms are business terms.

6. The system of claim 1 , wherein the extension wizard is configured to guide users in using the custom semantic extensions to extend or customize the semantic model through a definition of branches and steps, wherein different types of branches are associated with different extension wizards, and different versions of the semantic model are supported.

7. The system of claim 1 , wherein in response to a user specifying the branch to customize, the extension wizard presents a table of example data to a user and thereafter guides the user though customizing definitions or aggregations for use with the data.

8. The system of claim 1 , wherein the analytic applications environment provides:

for a first tenant of the plurality of tenants, a first tenant-specific customer schema maintained within a first customer tenancy; and

for a second tenant of the plurality of tenants, a second tenant-specific customer schema maintained within a second customer tenancy;

wherein each tenant's resultant data warehouse instance contents are:

partly-controlled by their customer schema; and

partly-controlled by the analytic applications schema in pre-populating their data warehouse instance with data retrieved from the tenant's enterprise software application or data environment.

9. A method for providing extensibility and customization in an analytic applications environment, comprising:

providing, at a computer including one or more processors, an analytic applications environment that provides access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants;

wherein each tenant of the plurality of tenants is associated with a customer tenancy, and with a tenant-specific customer schema maintained within their customer tenancy, for use in populating a data warehouse instance;

wherein the system performs an extract, transform, load or other data pipeline or process as defined by a combination of an analytic applications schema shared by the plurality of tenants and the tenant-specific customer schema associated with a tenant, to receive data from the tenant's enterprise software application or data environment, for loading into a data warehouse instance, and populate the data warehouse instance with the data received from the tenant's enterprise software application or data environment as defined by the combination of the analytic applications schema and the tenant-specific customer schema; and

providing a semantic layer that enables use of custom semantic extensions to extend a packaged semantic model, and provide custom content at a presentation layer, wherein the semantic layer includes:

an initial version of a semantic model usable to provide a packaged content, to access the data loaded from the tenant's enterprise software application or data environment, as defined by the combination of the analytic applications schema and the tenant-specific customer schema, into their data warehouse instance, and provide a packaged content to the presentation layer; and

one or more semantic extensions that when merged with the initial semantic model, operate to modify operation of the semantic model and provide a custom content to the presentation layer, wherein each of a plurality of users are provided with an instance of the semantic model to provide modifications as extensions or customizations thereto as a separate branch, wherein the extensions or customizations provided by the plurality of users are then merged into the semantic model;

wherein the custom content is customized on a per tenant basis, for different tenants of the plurality of tenants, as determined by the semantic model including the extensions or customizations thereto;

wherein the presentation layer provides access to data in the data warehouse instance for each of the different tenants using the tenant's custom content at the presentation layer;

wherein an extension wizard provides instructions indicative of guided steps through customization and use of the custom semantic extensions and enables the user to edit or create a customization branch to extend or customize the semantic model, wherein selection of the branch provides the user with an instance of the semantic model to work with and incorporate their particular customizations or extensions, which customizations or extensions can then be promoted to a production environment;

wherein in response to immutable aspects of the semantic model being patched or updated, customizations provided as the custom semantic extensions are retained and automatically applied following the patch or update.

10. The method of claim 9 , wherein the analytic applications environment is provided within a cloud environment.

11. The method of claim 9 , wherein the analytic applications environment provides:

for a first tenant of the plurality of tenants, a first tenant-specific customer schema maintained within a first customer tenancy; and

for a second tenant of the plurality of tenants, a second tenant-specific customer schema maintained within a second customer tenancy;

wherein each tenant's resultant data warehouse instance contents are:

partly-controlled by their customer schema; and

partly-controlled by the analytic applications schema in pre-populating their data warehouse instance with data retrieved from the tenant's enterprise software application or data environment.

12. A non-transitory computer readable storage medium having instructions thereon, which when read and executed by a computer including one or more processors cause the computer to perform a method comprising:

providing, at a computer including one or more processors, an analytic applications environment that provides access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants;

wherein each tenant of the plurality of tenants is associated with a customer tenancy, and with a tenant-specific customer schema maintained within their customer tenancy, for use in populating a data warehouse instance;

wherein the system performs an extract, transform, load or other data pipeline or process as defined by a combination of an analytic applications schema shared by the plurality of tenants and the tenant-specific customer schema associated with a tenant, to receive data from the tenant's enterprise software application or data environment, for loading into a data warehouse instance, and populate the data warehouse instance with the data received from the tenant's enterprise software application or data environment as defined by the combination of the analytic applications schema and the tenant-specific customer schema; and

providing a semantic layer that enables use of custom semantic extensions to extend a packaged semantic model, and provide custom content at a presentation layer, wherein the semantic layer includes:

an initial version of a semantic model usable to provide a packaged content, to access the data loaded from the tenant's enterprise software application or data environment, as defined by the combination of the analytic applications schema and the tenant-specific customer schema, into their data warehouse instance, and provide a packaged content to the presentation layer; and

one or more semantic extensions that when merged with the initial semantic model, operate to modify operation of the semantic model and provide a custom content to the presentation layer, wherein each of a plurality of users are provided with an instance of the semantic model to provide modifications as extensions or customizations thereto as a separate branch, wherein the extensions or customizations provided by the plurality of users are then merged into the semantic model;

wherein the custom content is customized on a per tenant basis, for different tenants of the plurality of tenants, as determined by the semantic model including the extensions or customizations thereto;

wherein the presentation layer provides access to data in the data warehouse instance for each of the different tenants using the tenant's custom content at the presentation layer;

wherein an extension wizard provides instructions indicative of guided steps through customization and use of the custom semantic extensions and enables the user to edit or create a customization branch to extend or customize the semantic model, wherein selection of the branch provides the user with an instance of the semantic model to work with and incorporate their particular customizations or extensions, which customizations or extensions can then be promoted to a production environment;

wherein in response to immutable aspects of the semantic model being patched or updated, customizations provided as the custom semantic extensions are retained and automatically applied following the patch or update.

13. The non-transitory computer readable storage medium of claim 12 , wherein the analytic applications environment is provided within a cloud environment.

Assignments (1)

Continuity (2)

References Cited (101)