Skip to main content

Data Mining with SQL Server 2005

Data Mining with SQL Server 2005

ZhaoHui Tang, Jamie MacLennan

ISBN: 978-0-471-46261-3

Oct 2005

480 pages

Select type: Paperback

Product not available for purchase


Your in-depth guide to using the new Microsoft data mining standard to solve today's business problems

Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert guide, this book shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets. The authors explore the core concepts of data mining as well as the latest trends. They then reveal the best practices in the field, utilizing the innovative features of SQL Server 2005 so that you can begin building your own successful data mining projects.

You'll learn:

  • The principal concepts of data mining
  • How to work with the data mining algorithms included in SQL Server data mining
  • How to use DMX-the data mining query language
  • The XML for Analysis API
  • The architecture of the SQL Server 2005 data mining component
  • How to extend the SQL Server 2005 data mining platform by plugging in your own algorithms
  • How to implement a data mining project using SQL Server Integration Services
  • How to mine an OLAP cube
  • How to build an online retail site with cross-selling features
  • How to access SQL Server 2005 data mining features programmatically
About the Authors.



Chapter 1: Introduction to Data Mining.

Chapter 2: OLE DB for Data Mining.

Chapter 3: Using SQL Server Data Mining.

Chapter 4: Microsoft Naïve Bayes.

Chapter 5: Microsoft Decision Trees.

Chapter 6: Microsoft Time Series.

Chapter 7: Microsoft Clustering.

Chapter 8: Microsoft Sequence Clustering.

Chapter 9: Microsoft Association Rules.

Chapter 10: Microsoft Neural Network.

Chapter 11: Mining OLAP Cubes.

Chapter 12: Data Mining with SQL Server Integration Services.

Chapter 13: SQL Server Data Mining Architecture.

Chapter 14: Programming SQL Server Data Mining.

Chapter 15: Implementing a Web Cross-Selling Application.

Chapter 16: Advanced Forecasting Using Microsoft Excel.

Chapter 17: Extending SQL Server Data Mining.

Chapter 18: Conclusion and Additional Resources.

Appendix A: Importing Datasets.

Appendix B: Supported VBA and Excel Functions.


Download material from Chapter 7
Download material from Chapter 13
Download material from Chapter 14
Download material from Chapter 16
Download material from Appendix A
Chapter 14 Errata
Errata for Chapter 14 in Microsoft Word format.
ChapterPageDetailsDatePrint Run
14Chapter 14 Errata
To view the errata from this chapter, go to the downloads to access the errata in Microsoft Word format.

16Chapter 16 download file
The files for Chapter 16 ( have been updated on this site.

362Error in Code/Text
In Listing 14.9 on page 362, new code appears that contains the line:
"ExecuteScalar is not supported in the RTM version of"

This line should be removed all together.

423Datasets link
First paragraph, last sentence:

"The datasets are found at"

This should actually say:

"The datasets are found at"