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 analytics 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, Oracle R Enterprise 1.5 enables data analysts to develop and execute R language functions and scripts that are automatically mapped to native SQL queries, providing further scalability and performance optimizations, while reducing their need to learn SQL.
Predictive analytics tools
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.
Tools for managing big data analysis
For exploring, transforming and analyzing big data, Oracle offers Oracle Big Data Discovery, which leverages Apache Spark in support of analytics requiring large scale and fast speed. Along with 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 as 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 the specialized skills ordinarily required to work with data in Hadoop.
Oracle Big Data Connectors provides a suite of connectors that join Hadoop with Oracle Database. They enable fast loading of data from a variety of input formats and sources, including Oracle NoSQL, Apache HBase, and Apache Parquet and JSON files.
ORAAH 2.7.0 provides users with a collection of R packages to perform big data and predictive analytics. Data scientists comfortable using an R environment can more easily interface with a variety of platforms, including Hadoop Distributed File System, Hive, Spark 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 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 for which the license is purchased for use or whether it's a perpetual license. Oracle products can be purchased directly from the company or from its vendor and partner resellers. Oracle also offers several support options.
The features and functions of Oracle Database 12c
What is the predictive analytics ROI?
Test your predictive analytics knowledge with this quiz