By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: First Look – Oracle Data Mining Update
Share
Notification Show More
Latest News
big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > First Look – Oracle Data Mining Update
Business IntelligenceData MiningPredictive Analytics

First Look – Oracle Data Mining Update

JamesTaylor
Last updated: 2011/08/04 at 6:08 PM
JamesTaylor
5 Min Read
SHARE

I got an update from Oracle on Oracle Data Mining (ODM) recently. ODM is an in-database data mining and predictive analytics engine that allows you to build and use advanced predictive analytic models on data that can be accessed through your Oracle data infrastructure. I blogged about ODM extensively last year in this First Look – Oracle Data Mining and since then they have released ODM 11.2.

I got an update from Oracle on Oracle Data Mining (ODM) recently. ODM is an in-database data mining and predictive analytics engine that allows you to build and use advanced predictive analytic models on data that can be accessed through your Oracle data infrastructure. I blogged about ODM extensively last year in this First Look – Oracle Data Mining and since then they have released ODM 11.2.

The fundamental architecture has not changed, of course. ODM remains a “database-out” solution surfaced through SQL and PL-SQL APIs and executing in the database. It has the 12 algorithms and 50+ statistical functions I discussed before and model building and scoring are both done in-database. Oracle Text functions are integrated to allow text mining algorithms to take advantage of them.  Additionally, because ODM mines star schema data it can handle an unlimited number of input attributes, transactional data and unstructured data such as CLOBs, tables or views.

More Read

backing up oracle data

Ways for Data-Driven Organizations to Backup Oracle With 3rd Party Tools

Oracle CEO Larry Ellison Takes New Role: What Does it Really Mean?
Salesforce.com Is Full of Surprises
Salesforce Fills Out the “Marketing Cloud”
Oracle Brings Enhancements to Business Intelligence

This release takes the preview GUI I discussed last time and officially releases it. This new GUI is an extension to SQL Developer 3.0 (which is available for free and downloaded by millions of SQL/database people). The “Classic” interface (wizard-based access to the APIs) is still available but the new interface is much more in line with the state of the art as far as analytic tools go.

The GUI allows you to manage database Connections within which there are Projects that in turn contain Workflows. These look very much like those in SAS Enterprise Miner or IBM SPSS Modeler with a variety of action nodes that can be linked into a data mining flow. Workflows have immediate access to the database with tables, joins, views as well as to remote data being managed through the Oracle Database. Other nodes include those to create views, explore data, merge and clean data, transform and aggregate data, create models etc. A filter node allows you to take out noisy data elements, attributes that aren’t important, sample data and more. All the statistics needed by the analysis and reporting nodes are run inside the database too and all the steps in the workflow produce SQL breadcrumbs.

Nodes like Classification run multiple models at the same time and allow defaults to be overridden to play with different modeling approaches. There are also some power user features to allow tweaking of parameters. The user can select one or more models to push on through the workflow. Once a model is ready it can be applied to a database table or embedded in the database as a live column. With Exadata models are pushed to the storage level for execution for maximum performance.

The extension includes help for data miners to use the tool plus training “Cue Cards” and sample data as well as an embedded “infomercial” to introduce data mining concepts to DBAs and others who might come across it while using SQL Developer. There are also an increasing number of training classes available online.

One of the most interesting facts about ODM remains its use in other Oracle solutions. As noted previously it is being embedded in various applications – from Fusion Human Capital Management to Oracle Business Intelligence Enterprise Edition (OBIEE). There is also some ongoing work with Oracle Real Time Decisions (RTD) – see my review of the most recent version of RTD. This plus sharing the BI sales team is increasing take up and broadening the reach of ODM both within Oracle and its customer base.

In-database analytics is a hot topic these days and the ability of ODM to build and execute models completely in-database makes it a good candidate for anyone interested in using predictive analytics to make the most of the operational data they have.

Don’t forget the Decision Management Technology Map

Copyright © 2011 http://jtonedm.com James Taylor

TAGGED: oracle
JamesTaylor August 4, 2011
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

backing up oracle data
Data Management

Ways for Data-Driven Organizations to Backup Oracle With 3rd Party Tools

5 Min Read

Oracle CEO Larry Ellison Takes New Role: What Does it Really Mean?

4 Min Read
salesforce
Business IntelligenceCloud ComputingData ManagementInside CompaniesNews

Salesforce.com Is Full of Surprises

6 Min Read

Salesforce Fills Out the “Marketing Cloud”

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?