Business Intelligence – Oracle

Oracle Data Mining and Business Intelligence

Posted by Venkatakrishnan J on July 25, 2007

I believe Oracle Data Mining is one of the most under utilized tools/database options in the BI space. There are so many Oracle Data Warehouse implementations out there but hardly few use Oracle Data Mining (but yes the market share is growing recently). Is there any reason for such a low adoption rate? Is it due to the lack of capabilities of Oracle Data Miner? Or is it due to the perceived notion that Data Mining is for statisticians and the like? Or is it because the management does not believe in the value of Data Mining?

I think it’s primarily due to the perceived notion rather than the lack of features because ODM indeed has a very rich set of functionality (a lot!!!). Of course statisticians can much appreciate the value of a data-mining tool. But again, as a person who has been involved in some DW implementations, I believe we understand the data better than anyone else. To use data mining Statistical knowledge would be an absolute plus but not mandatory. I am planning to put together a series of articles that would elucidate the various models that are used in Oracle Data Miner with examples. Its more of an education for me too since I myself would be getting my hands dirty for the first time with this tool. It is a bit too ambitious but let me see how far I can go. I will try to put together some relevant day-to-day examples as and when I get time (I will try as much as possible to deviate from the Beer bottle and Baby diaper example J). For more detailed analysis and inputs we always have the documentation and the ODM PM Marcos Campos’s blog. Actually the ODM PM is Charlie Berger. Thanks for correcting me Charlie. But some usual caveats here. Data Mining is a huge and a vast topic. I plan to just cover the models that might make sense for all those who use Business Intelligence. If you have any feedback do let me know since I think I am being too opinionated here!!!

Before we get into the details, lets go through an overview of datamining types. There are 2 types of datamining.

       1. Supervised Data Mining
       2. Un-Supervised Data Mining

Supervised is also called as Predictive data mining wherein the process is used to predict some outcomes. For example, a credit card company can use this to predict whether a customer is going to default on his payments.

Un-Supervised Datamining, also known as descriptive datamining involves finding out intrinsic patterns within the data. Again, how the pattern is identified depends on the model.

Following are some of the models supported by Oracle Data Miner.

Supervised Data Mining:

        1. Classification
        2. Regression
        3. Attribute Importance
        4. Anomaly Detection

Un-Supervised Data Mining:

        1. Clustering
        2. Association
        3. Feature Extraction

With that I would like to close this with some interesting articles on datamining

        1. Crime Detection
        2. Credit Card Fraud Detection

2 Responses to “Oracle Data Mining and Business Intelligence”

  1. Mimi Tam said

    I’m looking for a CRM / BI Data Mining (DM) solution for Wireless Carriers. Having a DM tool is good but I need expertise to build up Models relevant to Wireless carriers as well as stats knowledge to know which algorithms best used for what.

    So, I think the easiest way may be to find CRM with BI Applications for Wireless carriers that support DM. Can you receommend some Vendors that do this?

    Also, I download Oracle Data Miner 11g but I need Oracle Data Mining 11g to actually do some predictive analysis, correct? Can I get Oracle Data Mining 11g somewhere to do an evaluation of DM? I currently do not have anything Oracle installed on the laptop except Orcale Data Miner 11g.

    Any info would be greatly appreciated.

  2. ISO 13485 Implementation…

    What does this worldwide standardization mean to you and me? Well, thanks to ISO, we can get cash from an automated teller machine (ATM) in New York City, Hong Kong, Buenos Aires or Moscow. The format of the credit cards, phone cards and smart cards is…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: