Oracle International Corporation

Jagdish Chand

Ananth Venkata

Saugata Chowdhury

Renu Chintalapati

Ispati Nautiyal

Dirk Reinshagen

Akshay Satyendranath

Saurav Mohapatra

Krishnan Ramanathan

Aman Madaan

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. 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. 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.

System and method for data analytics with an analytic applications environment

Systems and methods for providing a universal format driven data transformation. In conventional ETL operations, the transform process that transforms data from the source format to the destination format is based on a transformation program. Conventionally, transform logic is developed around the chosen transform program. In accordance with an embodiment, a universal, format-driven data transform can be achieved through the use of a data transformation format. In accordance with an embodiment, a method for providing a universal format driven data transformation can include providing a transformation format in a file, wherein the transformation format is in a human-readable form; and providing, in the transformation format, keywords defining a target table type, a dataset list, and dataset operations to be performed on a dataset from the dataset list.

System and method for universal format driven data transformation and key flex fields in an analytic applications environment

In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for determination of recommendations and alerts in such environments. A data pipeline or 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. When provided as part of a software-as-a-service (SaaS) or cloud environment, the data sourced from a plurality of organizations can be aggregated, to leverage information gleaned from the collective or shared data. The system can be used to generate semantic alerts, including obtaining permission from; and analyzing the collective data of; the plurality of organizations, to determine operational advantages indicated by the data, and providing alerts associated with those operational advantages.

System and method for determination of recommendations and alerts in an analytics environment

System and method for universal format driven data transformation and key flex fields in a analytic applications environment

Growing community of inventors

Dublin, CA, United States of America

Jagdish Chand