Buyer's Guide

A buyer's guide to selecting the right big data analytics software

A collection of articles that takes you from defining technology needs to purchasing options
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Exploring Oracle Advanced Analytics

Oracle Advanced Analytics and other data analytics tools enable business users to explore large volumes of data.

Oracle offers several data analytics products that address a variety of analytical needs. Oracle Advanced Analytics is an option available with Oracle's Database Enterprise Edition 12c that provides business analysts or others without in-depth data analytic skills with an easy-to-use, scalable way to explore large volumes of data within an Oracle database. This option includes a variety of in-database data mining and data analysis algorithms.

An in-database architecture reduces complexity and improves performance, while eliminating the need for separate analytic servers to move data between servers. An in-database execution model also provides execution optimizations through an R-to-SQL in-database transparency layer. With this approach, R language functions are mapped to native SQL queries, providing further performance optimizations.

Other tools available from Oracle provide business and data analysts with additional predictive analysis capabilities. Examples include GUI and integrated development environment options for using SQL or the R language to invoke in-database analytic algorithms, such as open source R algorithms to uncover actionable insights and predictions. With these tools and capabilities, users can build analytic models that can integrate with existing business processes and systems

For example, Oracle Data Miner, an extension to Oracle SQL Developer, enables users to graphically explore data in the database and assess and select from a variety of data mining models that can be deployed throughout the enterprise. Oracle Data Miner includes an array of well-known machine learning approaches to support clustering, predictive mining and text mining. Data scientists familiar with R can write R scripts and integrate them with Oracle Data Miner.

For big data analytics support, products available include Oracle Big Data Discovery, Oracle Big Data Connectors and Oracle R Advanced Analytics for Hadoop (ORAAH). These products enable business users to work with Hadoop big data, as well provide a way for integrating and linking Apache Hadoop data with other enterprise data for integrated analysis.

Oracle Big Data Discovery provides users with an interactive GUI that enables them to more easily perform transformations, analytics and visualizations on raw data they've collected in Hadoop to discover insights. Visualization and other results can be shared throughout the organization. The tool is designed to reduce the need for specialized skills ordinarily required to work with data in Hadoop.

Oracle Big Data Connectors provides a suite of connectors that enable access to Hadoop Distributed File System from the Oracle database system. Users can use familiar Oracle tools to access and perform integrated analysis of both Oracle database data as well as data stored in Hadoop.

ORAAH provides users with a collection of R packages to perform predictive analytics. R libraries can interface with Apache Hive tables, Apache Hadoop compute infrastructure and Oracle database tables.

Oracle products function on a variety of operating systems, including Windows and various versions of Unix and Linux.

Oracle offers free downloadable versions of its software for nonproduction and prototyping purposes. Additionally, for big data support, Oracle offers Oracle Big Data Lite Virtual Machine, which is a nonproduction virtual machine appliance.

Oracle Advanced Analytics pricing

Oracle pricing models are based on a combination of the number of named users, the number of seats or number of processors of the server, as well as the number of years the license is purchased for use (or whether it's a perpetual license). Oracle products can be purchased directly from a company, or its vendor and partner resellers. Oracle also offers several support options.

Next Steps

The features and functions of Oracle Database12c

What is the predictive analytics ROI?

Text your predictive analytics knowledge with this quiz

This was last published in October 2015



Find more PRO+ content and other member only offers, here.

Buyer's Guide

A buyer's guide to selecting the right big data analytics software

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

How does the in-database architecture of Oracle Advanced Analytics improve your analytics performance?