Oracle Advanced
Analytics Option

The fastest way to deliver scalable enterprise-wide predictive analysis

Architecture Overview

The Oracle Advanced Analytics Option turns the Oracle Database into an enterprise-wide analytical platform that can quickly deliver enterprise-wide predictive analytics and actionable insights.

Oracle Advanced Analytics empowers data and business analysts to extract knowledge, discover new insights and make predictions—working directly with large data volumes in the Oracle Database. Oracle Advanced Analytics, an option of Oracle Database Enterprise Edition, offers a combination of powerful in-database algorithms and open source R algorithms, accessible via SQL and R languages, and provides a range of GUI and IDE options targeting business users to data scientists.

The Oracle Advanced Analytics Option extends the database into a comprehensive advanced analytics platform for big data analytics. 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.

With Oracle, powerful analytics are performed directly on data in the database. Results, insights, and real-time predictive models are available and managed by the database. Oracle Advanced Analytics eliminates data movement to external analytical servers, accelerates information cycle times and reduces total cost of ownership. The power of Oracle Advanced Analytics is accessible through both SQL and the R programming language. Oracle Data Mining (ODM) provides data mining algorithms that run as native SQL functions for high performance in-database model building and model deployment. Oracle R Enterprise (ORE) tightly integrates the open source R language for statistical computing and graphics with the database. ORE extends the database’s analytical capabilities by leveraging R’s library of statistical functionality and pushes down computations to the database. Together, Oracle Data Mining and Oracle R Enterprise enhance the database with a comprehensive range of analytical functionality and sophisticated interactive visual analysis.

Making Better Decisions with Deeper Insights and Predictive Analytics

  • 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


Comprehensive Analytics on a Simple Architecture

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.

Easy to Use -- for 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.

Database 12c Innovation Online Forum RHS banner