Oracle Advanced Analytics

Scalable enterprise-wide predictive analytics

Architecture Overview

Oracle Advanced Analytics 12c delivers parallelized in-database implementations of data mining algorithms and integration with open source R. Data analysts use Oracle Data Miner GUI and R to build and evaluate predictive models and leverage R packages and graphs. Application developers deploy Oracle Advanced Analytics models using SQL data mining functions and R. With the Oracle Advanced Analytics option, Oracle extends the Oracle Database to an sclable analytical platform that mines more data and data types, eliminates data movement, and preserves security to anticipate customer behavior, detect patterns, and deliver actionable insights. Oracle Big Data SQL adds new big data sources and Oracle R Advanced Analytics for Hadoop provides algorithms that run on Hadoop. 

Oracle Advanced Analytics, a combination of
Oracle Data Mining and Oracle R Enterprise, delivers predictive analytics, data mining, text mining, statistical analysis, advanced numerical computations and interactive graphics inside the database. It brings powerful computations to the database resulting in dramatic improvements in information discovery, scalability, security, and savings. Data analysts, data scientists, statistical programmers, application developers and DBAs can develop and automate sophisticated analytical methodologies inside the database and gain competitive advantage.

Predictive Analytics and Actionable Insights 

  • Predict customer behavior and Identify cross/up-sell opportunities
  • Identify customers likely to churn
  • Analyze “market baskets” to discover associations, patterns and relationships
  • Detect anomalies and fight fraud 

Making Big Data + Analytics Simple

High performance in-database data-mining algorithms and statistical functions are accessible from SQL and R. Integration with open-source R adds the ability for users to write R scripts and use R packages while leveraging the strengths of the database. Oracle Advanced Analytics provides an R to SQL transparency layer that maps R functions and algorithms to native in-database SQL equivalents. When in-database equivalents are not available, Oracle Advanced Analytics can run them under embedded R mode allowing the database to manage the entire data management and analytical process.

Data Scientists, Business Analysts and IT

Graphical User Interfaces Oracle Data Miner an extension to Oracle SQL Developer, provides data analysts with a workflow environment for data exploration, model building and development of analytical methodologies. Once the data analyst is satisfied with their analytical methodology, Oracle Data Miner can generate SQL scripts for immediate in-database enterprise deployment—saving time and money.

SQL, PL/SQL and R APIs Algorithms are accessible by SQL and R APIs, Oracle Data Miner and IDEs (RStudio, etc.). Building and deploying predictive models within the enterprise is fast and easy.

Key Benefits

Performance and Scalability All data management, preparation and transformations, model building and model scoring run as database processes.

Fastest Way to Deliver Enterprise Predictive Analytics Applications The database becomes the scalable and secure platform for delivering predictions and insights to BI dashboards and Applications.

Lowest Total Costs of Ownership No need for separate analytical servers.


PDF Guide - Click here
iBook Guide - Click here

Oracle Database Cloud