Critical.
Authoritative.
Strategic.
Subscribe to CIO Magazine »

Data Mining with SQL Server 2005

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

Biography

ZhaoHui Tang is a Lead Program Manager in the Microsoft SQL Server Data Mining team. Joining Microsoft in 1999, he has been working on designing the data mining features of SQL Server 2000 and SQL Server 2005. He has spoken in many academic and industrial conferences including VLDB, KDD, TechED, PASS, etc. He has published a number of articles for database and data mining journals. Prior to Microsoft, he worked as a researcher at INRIA and Prism lab in Paris and led a team performing data-mining projects at Sema Group. He got his Ph.D. from the University of Versailles, France in 1996.

Jamie MacLennan is the Development Lead for the Data Mining Engine in SQL Server. He has been designing and implementing data mining functionality in collaboration with Microsoft Research since he joined Microsoft in 1999. In addition to developing the product, he regularly speaks on data mining at conferences worldwide, writes papers and articles about SQL Server Data Mining, and maintains data mining community sites. Prior to joining Microsoft, Jamie worked at Landmark Graphics, Inc. (division of Halliburton) on oil & gas exploration software and at Micrografx, Inc. on flowcharting and presentation graphics software. He studied undergraduate computer science at Cornell University.

Table of Contents

About the Authors.

Credits.

Foreword.

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.

Index.

rhs_login_lockGet exclusive access to Invitation only events CIO, reports & analysis.
Recent comments