The free Oracle Data Miner GUI is an extension to Oracle SQL Developer 3.1 that enables data analysts to work directly with data inside the database, explore the data graphically, build and evaluate multiple data mining models, apply Oracle Data Mining models to new data and deploy Oracle Data Mining’s predictions and insights throughout the enterprise. Oracle Data Miner work flows capture and document the user’s analytical methodology and can be saved and shared with others to automate advanced analytical methodologies.
Oracle Data Miner creates predictive models that application developers can integrate into applications to automate the discovery and distribution of new business intelligence-predictions, patterns and discoveries—throughout the enterprise. (To see details about the prior release of Oracle Data Miner, Oracle Data Miner Classic, click here.)
Oracle Data Miner is comprised of three components:
- Oracle Database 12c or Oracle Database 11g Release 2
- SQL Developer (client) which bundles the Oracle Data Miner work flow GUI
- Data Miner Repository – installed in the Oracle Database
Follow these steps to install Oracle Data Miner:
- Step 1: Install Oracle Database 12c or Oracle Database 11g Release 2
- Download the software from Oracle Database Software Downloads athttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html.
- To use Oracle Data Miner, you must connect to an Oracle database that satisfies these requirements:
- The Oracle Data Mining option is installed. Oracle Data Mining is installed automatically when you install Oracle Database Enterprise Edition.
- Oracle Text is installed. Oracle Text is installed automatically when you install Oracle Database Enterprise Edition.
- Oracle XML DB is installed. Oracle XML DB is installed automatically when you install Oracle Database Enterprise Edition.
- Data used by the cue card sets and the Oracle By Example tutorials requires the SH schema. If you install a starter database when you install Oracle Database Enterprise Edition, SH is automatically installed.
- Chapter 2 of Oracle Data Miner Administrator’s Guide athttp://download.oracle.com/docs/cd/E11882_01/datamine.112/e16807/toc.htm describes how to install Oracle Database Enterprise Edition on Microsoft Windows. For instructions for other platforms, see the Installing and Upgrading section of the Documentation Library.
- Step 2: Download the SQL Developer client from the SQL Developer Download site, following the instructions provided at this site: SQL Developer.
- Step 3: Install the Data Miner Repository by following the Oracle By Example “Setting Up Oracle Data Miner”
Install Data Miner Repository
- NEW: Oracle Data Miner Extension for SQL Developer 4.0 Release Notes for EA1
- Oracle Data Miner Extension for SQL Developer Release 3.1
Oracle Data Miner Tutorials
Oracle by Example (OBE) tutorials provide hands-on, step-by-step instructions on how to implement various technology solutions to business problems.There are four OBE Tutorials: Setting Up Oracle Data Miner, Using Oracle Data Miner, Star Schema Mining, and Text Mining. You can find them listed as a group in the Learning Library.
- Case Study – Data Mining with Star Schemas – A Telco Churn Analysis
- Update: The latest version of Oracle Data Miner is now available in SQL Developer Release 3.2.NEW: SQL Developer 4.0 Early Adopter Release 1 (EA1) is now available on OTN. See links below for download and release notes.