Data Mining with Microsoft SQL Server 2000

More about the book

The explosion of information in corporate databases necessitates effective data mining to uncover meaningful patterns, providing organizations with a competitive edge. This comprehensive reference from Microsoft is designed for those looking to leverage the robust data-mining capabilities of SQL Server 2000. It explores the Analysis Services architecture of SQL Server 2000 and illustrates how data mining integrates with its suite of information-extraction technologies. The book guides users on structuring and mining extensive databases using built-in algorithms to extract valuable insights, including creating a practice data-mining model with downloaded database data. Key topics include an introduction to data mining, clarifying its principles and methodologies, and the role of models, statistics, and algorithms. It details how data mining is incorporated within the SQL Server 2000 Analysis Services architecture, enhancing the relational database and OLAP engine. The text also covers selecting the appropriate data-mining methods, such as decision trees or clustering, and features user-friendly tools like the Mining Model Wizard and OLAP Mining Model Editor for model creation and training. Additionally, it addresses programming aspects, demonstrating how to utilize data-mining models alongside various tools and languages, including Data Transformation Services and XML, to effectively interact with the data-mining engine.