Data Mining Extensions Article Index for
Data 		Website Links For
Data Mining 		 

Information About

Data Mining Extensions
  CATEGORIES ABOUT DATA MINING EXTENSIONS
   
query languages
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...




DATA DEFINITION LANGUAGE

Data Definition Language (DDL) part of DMX can be used to
  • Create new data mining models and mining structures - CREATE MINING STRUCTURE, CREATE MINING MODEL

  • Delete existing data mining models and mining structures - DROP MINING STRUCTURE, DROP MINING MODEL

  • Export and import mining structures - EXPORT, IMPORT

  • Copy data from one mining model to another - SELECT INTO



DATA MANIPULATION LANGUAGE

Data Manipulation Language (DML) part of DMX can be used to
  • Train mining models - INSERT INTO

  • Browse data in mining models - SELECT FROM

  • Make predictions using mining model - SELECT ... FROM PREDICTION JOIN



EXAMPLE OF PREDICTION QUERY

This example is a singleton prediction query, which predicts for the given customer whether he will be interested in the home loan products.




SELECT

   Seeker ,

  PredictProbability( Seeker )

FROM

   Tree 

NATURAL PREDICTION JOIN

(SELECT 

   35 AS  {Link without Title} ,

   'Y' AS  Owner ,

   'M' AS  Status ,

   'F' AS  {Link without Title} ,

   2 AS  Cars Owned ,

   2 AS  Children ,

   18 AS  Years of Education 

)




EXTERNAL LINKS