UDDATED for Oracle Database 12c & SQLDEV 4.0: Evaluating Oracle Data Mining Has Never Been Easier - Evaluation "Kit" Available
By Charlie Berger, Advanced Analytics-Oracle on Mar 23, 2012
UPDATED (October 2015) for ORACLE DATABASE 12c & SQL DEVELOPER 4.1 (with ORACLE DATA MINER 4.1) Extension
The Oracle Advanced Analytics Option turns the 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 integration with open source R algorithms accessible via SQL and R languages and provides a range of GUI (Oracle Data Miner) and IDE (R client, RStudio, etc.) options targeting business users, data analysts, application developers and data scientists.
Now you can quickly and easily get set up to starting using Oracle Data Mining, the SQL API & GUI component of the Oracle Advanced Analytics Database Option for evaluation purposes. Just go to the Oracle Technology Network (OTN) and follow these simple steps.
Oracle Data Mining Evaluation "Kit" Instructions
- Anyone can download and install the Oracle Database for free for evaluation purposes. Read OTN web site http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html for details.
- Oracle Database 12c is the latest release and contains many new features. See Oracle Advanced Analytics 12c Dcoumentation's New Features and this recent Oracle Data Mining Blog posting. NOTE: A major new feature of the 12c Oracle Database is multi-tenant and the ability to set up multiple Container databases. However, to keep things simpler, UNCHECK the "create as Container database" option. This makes your SQLDEV database connections simpler and then you can use the simpler case Oracle Data Miner tutorials. If you create the Container database(s), your connection details get a bit more complicated.
- For Oracle Database Release 11g, 18.104.22.168.0 DB is the minimum, 22.214.171.124 is better and naturally 126.96.36.199 is best if you are a current customer and on active support.
- Either 32-bit or 64-bit is fine. 4GB of RAM or more works fine for SQL Developer and the Oracle Data Miner GUI extension.
- Downloading the database and then installing it should take just about an hour or so at most, depending on your network and computer.
- For more instructions on setting up Oracle Data Mining see: http://www.oracle.com/technetwork/database/options/odm/dataminerworkflow-168677.html
- When you install the Oracle Database, the Oracle Data Mining Examples including sample data is available as part of the total Database installation. See link.
Step 2: Install SQL Developer 4.1 (the Oracle Data Miner GUI Extension installs automatically but additional post installation Set Up in required. See Setting Up Oracle Data Miner )
- Setting Up Oracle Data Miner 4.1 This tutorial covers the process of setting up Oracle Data Miner for use within Oracle SQL Developer 4.0.
- Using Oracle Data Miner 4.1 This tutorial covers the use of Oracle Data Miner 4.0 to perform data mining against Oracle Database 12c. In this lesson, you examine and solve a data mining business problem by using the Oracle Data Miner graphical user interface (GUI). The Oracle Data Miner GUI is included as an extension of Oracle SQL Developer, version 4.1.
- Star Schema Mining Using Oracle Data Miner 4.1 This tutorial covers the use of Oracle Data Miner 4.1 to perform star schema mining activities against Oracle Database 12c Release 188.8.131.52. Oracle Data Miner 4.1 is included as an extension of Oracle SQL Developer, version 4.1.
- Using the SQL Query Node With Oracle Data Miner 4.1 This tutorial covers the use of the new SQL Query Node in an Oracle Data Miner 4.1 workflow.
- Using Logistic Regression Models (GLM) to Predict Customer Affinity This tutorial covers the use of Oracle Data Miner 4.1 to leverage enhancements to the Oracle implementation of Generalized Liner Models (GLM) for Oracle Database 12c. These enhancements include support for Feature Selection and Generation.
- Text Mining with an EM Clustering Model Using Data Miner 4.1 In this lesson, you learn how to use the EM algorithm in a clustering model while leveraging text mining enhancements that are included in Oracle Data Miner 4.1.
- Using Predictive Queries With Oracle Data Miner 4.1 This tutorial covers the use of Predictive Queries against mining data by Oracle Data Miner 4.1.
- Mining JSON Data Using Oracle Data Miner 4.1 This tutorial covers the use of the JSON Query Node in an Oracle Data Miner 4.1 workflow in order to mine this Big Data format.
That’s it! Easy, fun and the fastest way to get started evaluating Oracle Advanced Analytics/Oracle Data Mining. Enjoy!