Tuesday, May 23, 2006

Great Data Mining blog post on DM SQL

Marcos has a great post on "The SQL of Analytics 1 - Data Mining" on the Oracle Data Mining blog (link to blog):

"What do we get when we combine the power of SQL with advanced analytics? The answer: a revolution. The Oracle RDBMS has added, over recent releases, support for advanced analytics to the SQL vocabulary..."

Simple Prediction Query
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


Follow this link for the full post.