COPYRIGHT NOTICE

A portion of the disclosure of this patent document contains material which is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever.

TECHNICAL FIELD

Embodiments described herein are generally related to computer data analytics, and business intelligence, and are particularly related to systems and methods for providing an application analytics environment that enables the development of software analytic applications.

BACKGROUND

Generally described, within an organization, data analytics enables the computer-based examination or analysis of large amounts of data, in order to derive conclusions or other information from that data; while business intelligence tools provide an organization's business users with information describing their enterprise data in a format that enables those business users to make strategic business decisions.

Increasingly, there is an interest in developing software applications that leverage the use of data analytics within the context of an organization's enterprise software application or data environment, such as, for example, an Oracle Fusion Applications environment or other type of enterprise software application or data environment; or within the context of a software-as-a-service (SaaS) or cloud environment, such as, for example, an Oracle Analytics Cloud or Oracle Cloud Infrastructure environment, or other type of cloud environment.

Traditional SaaS (Software as a Service)/PaaS (Platform as a Service) billing systems generally charge customers/tenants for use of the SaaS/PaaS by the number of seats (e.g., users allowed to access the SaaS at any given moment) selected by the customer/tenant during the initial purchase/license agreement for the SaaS/PaaS. While this model traditionally works well for SaaS/PaaS, issues may arise when a customer/tenant requires or needs more resources above those already purchased. In such situations, for example, the only mechanism available to the customer/tenant would be to, for example, purchase a number of additional seats for the SaaS/PaaS.

SUMMARY

In accordance with an embodiment, an analytic applications environment enables data analytics within the context of an organization's enterprise software application or data environment, or a software-as-a-service or other type of cloud environment; and supports the development of computer-executable software analytic applications.

In accordance with an embodiment, a data pipeline or process, such as, for example, an extract, transform, load process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance.

In accordance with an embodiment, each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. The data pipeline or process populates their data warehouse instance and database tables with data as received from their enterprise software application or data environment, as defined by a combination of the analytic applications schema, and their customer schema.

In accordance with an embodiment, access to the analytic applications environment can be provided, e.g., as a Software-as-a-Service (SaaS) application or offering, that can be made accessible to customers of a cloud environment (e.g., an Oracle Cloud Infrastructure, OCI, or other cloud environment), or provided as a cloud service (e.g., an Oracle Analytics Cloud service, OAC, Oracle Fusion Analytics service, or other cloud service).

In accordance with an embodiment, the provisioning offered through cloud environments such as, for example, OCI, which enables support for features such as pipeline and data backup, restoration, and patching, can be integrated with other SaaS or Platform-as-a-Service (PaaS) components, including, for example, billing components that provide support for customer-specific limits on data processing, and hybrid (e.g., based on a combination of SaaS/PaaS) billing.

Described herein are systems and method for SaaS/PaaS resource usage and allocation in an analytic applications environment. An exemplary method can provide an application analytics environment, a control plane comprising a server, the control plane further comprises a provisioning component and a console interface, a data warehouse, and a monitoring agent. The method can provision an instance of the data warehouse in the context of a tenant, the provisioned instance of the data warehouse having an initial size. Upon the provisioning the instance of the data warehouse, the method can add adding an entry to a metrics repository of the monitoring agent, the added entry indicative of the initial size of the provisioned instance of the data warehouse, the added entry being tagged, the tag being indicative of the tenant. The method can monitor, by the monitoring agent, an amount of data stored at the provisioned instance of the data warehouse.

