Datamining- how its different from datawarehouse.

User_4NU9S

What tools we have for datamining ..

If some one wants to start leaning datamining , does data warehouse is a must?

I am new to these , and want to explore , what would be best way to get along with all these.

Mark Kelly-Oracle

Hi,

Data mining is part of the Oracle Advanced Analytics option for the DB.

You don't need a data warehouse to perform data mining, just data

Here is the link to a description of the OAA option:

Advanced Analytics

Here is the link to Oracle Data Miner which is a UI for building mining workflows:

Oracle Data Mining

You can download Oracle 12.2 DB and  SQL Dev 4.0 (this contains Data Miner UI ) onto your own machine and do some mining and explore the features.

The Data Miner OTN page has links to the Oracle By Example Tutorials - which explain how to use Data Miner.

Good Luck, Mark

User_4NU9S

Thanks Mark

Syswizard

Here is a good tutorial.....

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/datamining/ODM11gR2.htmhttp://

User_4NU9S

Content Server Request Failed

Unable to retrieve content. Unable to open folder.

Mark Kelly-Oracle

Here is a more up to date link to the OBE SQL Dev 4.0 Tutorials

Mark

Charlie Berger-Oracle

abroshan - That's a pretty wide open question.  I can respond by saying that Oracle's Advanced Analytics & Data Mining is all about mining the data in-place inside the Database.  By "moving the algorithms to the data" and not the reverse, it dramatically reduces the amount of time to turn "data" to "actionable insights" - from days/weeks to mins/hours.  Hopefully, these OAA links/resources are helpful.

1. Oracle Advanced Analytics Overview: 
   1. Link to presentation—Big Data Analytics using Oracle Advanced Analytics In-Database Option
   2. OAA data sheet on OTN
   3. Oracle Internal OAA Product Management Wiki and Workspace
2. YouTube recorded OAA Presentations and Demos:
   1. Oracle Advanced Analytics and Data Mining at the YouTube Movies (6 + OAA “live” Demos on ODM’r 4.0 New Features, Retail, Fraud, Loyalty, Overview, etc.)
3. Getting Started:
   1. Link to Getting Started w/ ODM blog entry
   2. Link to New OAA/Oracle Data Mining 2-Day Instructor Led Oracle University course. 
   3. Link to OAA/Oracle Data Mining 4.0 Oracle by Examples (free) Tutorials on OTN
   4. Take a Free Test Drive of Oracle Advanced Analytics (Oracle Data Miner GUI) on the Amazon Cloud
   5. Link to SQL Developer Days Virtual Event w/ downloadable Virtual Machine (VM) images of Oracle Database + ODM/ODMr and e-training for Hands on Labs
   6. Link to OAA/Oracle R Enterprise (free) Tutorial Series on OTN
4. Additional Resources:
   1. Oracle Advanced Analytics Option on OTN page
   2. OAA/Oracle Data Mining on OTN page, ODM Documentation & ODM Blog
   3. OAA/Oracle R Enterprise page on OTN page, ORE Documentation & ORE Blog
   4. Oracle SQL based Basic Statistical functions on OTN
   5. Business Intelligence, Warehousing & Analytics—BIWA Summit’15, Jan 27-29, 2015 at Oracle HQ Conference Center