Clickstream

Nice Description of Oracle's BI Offerings, Also Data Mining Inside a Query

Mark Rittman wrote a good article earlier this month explaining Oracle's BI offerings. WOrth reading through if you're at all interested in where they're going. Link.

While I'm at it, check out this extension to Oracle to allow data mining to be part of a query's WHERE clause:

Question:

Select all customers who have a high propensity to attrite (> 80% chance)

SQL Query:

      SELECT A.cust_name, A.contact_info
     FROM   customers A
      WHERE  PREDICTION_PROBABILITY(tree_model, ‘attrite’
                                   USING A.*) > 0.8

Pretty powerful stuff. Read the full post to see where it goes from there. A few months back someone had done something similar with categorization as an Ingres/Postgres extension. Looks like the folks at Oracle were paying attention.

Posted by Mark Wednesday, May 24, 2006 1:04:00 PM | permalink |

Comments:

Sure. They call it "query by example". The project home page is at http://pgfoundry.org/projects/qbe/

and there's a how-to at http://pgfoundry.org/docman/view.php/1000137/83/howto.html

# posted by  Mark : 10:43 AM

 

Post a Comment