O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Data Mining Prediction Queries

Data mining prediction queries can be understood as conceptually similar to relational database queries. That is, this type of query can be performed ad hoc (or on demand) using the GUI query-generation tools included in BIDS (or SSMS), or by writing the DMX query statement by hand. A more interesting use of DMX prediction queries is, however, in application integration. Just as database queries, whether relational or multidimensional, can be integrated into client applications, so too can mining model prediction queries.

An example of a business use of such capability is viability for a bank loan. The SQL Server 2008 Data Mining Add-ins for Office 2007 introduces a Prediction Calculator to the Table Tools Analyze ...

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