Using Data Mining Extensions
So far in this chapter, you’ve seen how to use the data structure designer within Visual Studio to create, train, and view mining models. Now you’ll see how to use SQL Data Mining Extensions (DMX) to do those same tasks. DMX is an extension to the SQL language for creating and working with data mining models in Analysis Services.
As with conventional SQL, DMX has two categories of statements: data definition language (DDL) statements and data manipulation language (DML) statements. DDL statements are used to create mining structures and models. DML statements are used to train, browse, and predict using mining models.
It is true that you can avoid writing DDL queries in DMX by using the Analysis Services designers. It ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
