Everything about Oracle Data Mining, a component of the Oracle Advanced Analytics Option - News, Technical Information, Opinions, Tips & Tricks. All in One Place

Friday Feb 22, 2013

I wanted to highlight a wonderful new resource provided by our partner Vlamis Software. Extremely easy! Fill out the form, wait a few minutes for the Amazon Cloud instance to start up and them BAM! You can login and start using the Oracle Advanced Analytics Oracle Data Miner work flow GUI. Demo data and online Oracle by Example Learning Tutorials are also provided to ensure your data mining test drive is a positive one, Enjoy!!

We have partnered with Amazon Web Services to provide to you, free of charge, the opportunity to work, hands-on, with the latest of Oracle's Business Intelligence offerings. By signing up to one of the labs below, Amazon's Elastic Cloud Computer (EC2) environment will generate a complete server for you to work with.

These hands on labs are working with the actual Oracle software running on the Amazon Web Services EC2 environment. They each take approximately 2 hours to work through and will give you hands-on experience with the software and a tour of the features. Your EC2 environment will be available for you for 5 hours, at which time it will self-terminate. If, after registration, you need additional time or need further instructions, simply reply to the registration email and we would be glad to help you.

Data Mining

This test drive walks through some basic exercises in doing predictive analytics within an Oracle 11g Database instance using the Oracle Data Miner extension for Oracle SQL Developer. You use a drag-and-drop "workflow" interface to build a data mining model that predicts the likelihood of purchase for a set of prospects. Oracle Data Mining is ideal for automatically finding patterns, understanding relationships, and making predictions in large data sets.

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, 11.2.0.1.0 DB is the minimum, 11.2.0.2 is better
and naturally 11.2.0.3 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.

Using Oracle Data Miner 4.0This 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.0.

Using Feature Selection and Generation with GLMThis tutorial covers the use of Oracle Data Miner 4.0 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 ModelThis tutorial covers the use of Oracle Data Miner 4.0 to leverage new text mining enhancements while applying a clustering model. In this lesson, you learn how to use the Expectation Maximization (EM) algorithm in a clustering model.

Using Oracle Data Miner 11g Release 2 This tutorial covers the use of Oracle Data Miner to perform data mining against Oracle Database 11g Release 2. In this lesson, you examine and solve a data mining business problem by using the Oracle Data Miner graphical user interface (GUI).