Oracle Advanced Analytics Option

Extending the Database into a Comprehensive Advanced Analytics Platform

The digital world is creating data at an ever increasing pace now surpassing Moore’s Law. However, data without analysis, is just data. Big Data Analytics is needed to extract information from Big Data for faster, better decision making and to enable enterprises to:

Better understand and anticipate customer behavior
Develop greater insight and understanding
Perform statistical analyses
Detect anomalies and potential fraud

Big Analytics for Big Data

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:

Data mining, text mining and predictive analytics
Summary and descriptive statistics, exploratory data analysis and graphics
Comparative statistics, correlations and multivariate statistics
Advanced numerical techniques

Oracle Advanced Analytics eliminates data movement, accelerates information latency times required to transform “raw data” into “new insights and actionable information.” As part of Oracle’s database technology stack, Oracle Advanced Analytics helps to reduce IT’s total cost of ownership for data analysis and delivers significant advantages:

10-100x Performance Gains
10x Lower Total Cost of Ownership

SQL Users

Oracle Data Mining—Find Patterns and Insights—Build Predictive Analytics Applications
Oracle Data Mining provides users SQL access to high performance algorithms in the database. ODM can mine tables, views, star schemas, transactional and unstructured data to represent a complete 360 degree view of the customer for better customer understanding. ODM leverages database parallelism, Real Application Clusters (RAC) and other database features for fast in-database model building and scoring, thus avoiding time consuming data movement. Exadata smart scans execute ODM models at the storage tier, while parallel query, Exadata and cursors support ODM in Decision Support System (DSS) and OLTP environments (e.g., real-time call centers).

Oracle Data Miner, a graphical user interface extension to SQL Developer, helps data analysts explore their data, build and evaluate data mining models, and share analytical workflows for churn prediction, response modeling, segmentation, fraud and anomaly detection, sentiment analysis and market basket analysis problems. Oracle Data Miner generates SQL and PL/SQL code to accelerate model deployment. Developers can leverage the code to build predictive applications that automate knowledge discovery.

R Users

Oracle R Enterprise— Integrates Open Source R with the Oracle Database
Oracle R Enterprise is the most integrated and complete suite of advanced analytics available to R users for enterprise environments. Designed for problems involving large amounts of data, it gives R programmers tight integration with the database for rapid development of sophisticated analytical methods and unprecedented support for big data analytics in Oracle Database and Oracle Big Data Appliance environments. Data analysts can use R to analyze billion row data sets, test a variety of sophisticated numerical techniques in seconds, thus making iterative, speed of thought numerical analysis on big data practical and feasible. R users can develop, refine and deploy R scripts that leverage the parallelism and scalability of the database for data preparation, model development and model deployment. R users can develop and deploy R scripts in one step—without having to learn SQL. Because it runs as an embedded component of the database, ORE can run any CRAN open source R package either by ORE R to SQL function pushdown for native in-database execution or via embedded R mode where the database manages the data flows to multiple R engines. Oracle R Enterprise exposes Oracle Data Mining’s high-performance native SQL based algorithms through R. DBAs can productionize R scripts for in-database execution eliminating model translation to other languages such as SQL or C. Oracle also integrates R with Hadoop running on Oracle’s Big Data Appliance for complex computations performed on data with low value information density such as social network, sensor and web log data managed in Hadoop servers prior to ingestion into the database for further analysis.

Technical Information

OTN Home Pages

Oracle R Enterprise OTN Home

Oracle Data Mining OTN Home

Data and Component Sheets

	Oracle Advanced Analytics Data Sheet		Oracle Data Mining Component Sheet
	Oracle R Enterprise Component Sheet

Related Technologies

	Oracle BI Home
	Oracle Database BI Features
	SQL Developer
	Oracle Exalytics In-Memory Machine

	Oracle BI DW Technology Center
	Oracle R Offerings
	Oracle Statistical Functions
	Oracle OLAP

	Popular Downloads
Untitled Document Berkeley DB Enterprise Manager Database EE and XE Developer VMs Enterprise Pack for Eclipse Java JDeveloper and ADF Oracle Linux and Oracle VM MySQL NetBeans IDE NoSQL Database Solaris SQL Developer VirtualBox WebLogic Server

	More Database Downloads
Database Express Edition Database Instant Client Database Mobile Server JDBC Drivers SQL Developer Data Modeler TimesTen In-Memory Database VM Templates for Database .NET Data Access Components