Powerful, Yet Simple: In-Database SQL Data Mining Functions

Rather than add data mining as a bolt-on process outside the database kernel, the Oracle Data Mining Technologies Dev. team, in collaboration with other Server Technology Dev. teams, has embedded data mining functionality within the Oracle Database.  A data mining model is a schema object in the database, built via a PL/SQL API and scored via built-in SQL functions.  When building models, leverage existing scalable technology (e.g., parallel execution, bitmap indexes, aggregation techniques) and add new core database technology (e.g., recursion within the parallel infrastructure, IEEE float, etc.)  The true power of embedding within the database is evident when scoring models using built-in SQL functions.  Note:  ODM model "scoring" runs on the storage layer when running on Exadata e.g.:

select cust_id
from customers
where region = 'US'
and prediction_probability(churnmod, 'Y' using *) > 0.8;
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Everything about Oracle Data Mining, a component of the Oracle Advanced Analytics Option - News, Technical Information, Opinions, Tips & Tricks. All in One Place

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today