O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required