Database12cOracle Advanced Analytics Option

The Fastest Way to Deliver Scalable Enterprise-wide Predictive Analytics 

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. 
Big Data and Bigger 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.

New:  Oracle Ranks #1 in Wisdom of Crowds® Series Advanced and Predictive Analytics Market Study  Big Analytics for Big Data 2014 Edition

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


Technical  Information

OTN Oracle Advanced Analytics Home Pages

red-arrow-boxOracle Data Mining OTN Homered-arrow-boxOracle R Enterprise OTN Home
red-arrow-boxOracle Data Miner "work flow" GUI, a SQL Developer Extension HomeNew 4.0 Release Available  Watch Demo

Data Sheet and Papers

red-arrow-boxOracle Advanced Analytics data sheetred-arrow-boxBig Data Analytics using Oracle Advanced Analytics white paper

Presentation and Additional Papers

red-arrow-boxOracle Advanced Analytics Database Option presentationred-arrow-boxAgile Advanced Analytic Platform white paper
red-arrow-boxNew Oracle Open World 2013 Presentation: Transform Big Data into Bigger Insight with Oracle Exadata and Oracle Advanced Analytics (pdf)


red-arrow-boxOracle Data Mining Blog red-arrow-boxOracle R Enterprise Blog

Discussion Forums

red-arrow-boxOracle Data Mining Discussion Forum red-arrow-boxOracle R Enterprise Discussion Forum


red-arrow-boxTake a Test Drive on the Amazon Cloud  
 Oracle Statistical Functions
red-arrow-boxSQL Developer
red-arrow-boxOracle Database BI Features
 Oracle Exalytics In-Memory Machine
red-arrow-boxOracle BI DW Technology Center
red-arrow-boxOracle R Technologies
red-arrow-boxOracle BI Home 

In-Memory Replay Banner