Data Mining with Microsoft SQL Server 2000 Technical Reference - Hardcover

Seidman, Claude

Hardcover

ISBN 10: 0735612714 ISBN 13: 9780735612716

Publisher: Microsoft Press US, 2001

Synopsis

The amount of information stored in corporate databases is exploding exponentially. Data mining—finding meaningful patterns in all that data—can give any organization a competitive advantage. This book is the in-depth reference from Microsoft® for anyone who wants to take full advantage of the powerful data-mining features in SQL Server™ 2000. It examines the SQL Server 2000 Analysis Services architecture and shows how data mining fits into its complete suite of information-extraction technologies. Then it demonstrates how to structure and mine large databases with the algorithms included with SQL Server 2000 to find nuggets of useful information. It even shows how to create a practice data-mining model using data downloaded from a database. Coverage includes:

• INTRODUCTION TO DATA MINING: What data mining is and isn’t, plus important principles and definitions behind data-mining methodologies, including the role of data-mining models, statistics, and algorithms
• SQL SERVER 2000 ARCHITECTURE: How data mining fits into the SQL Server 2000 Analysis Services architecture and how it builds on the SQL Server 2000 relational database and its embedded online analytical processing (OLAP) engine
• DATA-MINING METHODS: How to choose the best data-mining method for the job—decision trees or clustering
• EASE OF USE FEATURES: How to use the Mining Model Wizard and the OLAP Mining Model Editor to simplify creating, training, and processing a model
• PROGRAMMING THE DATA-MINING SERVICES: How to use data-mining models and Data Transformation Services, PivotTable® Services, decision-support objects (DSO), PERL, Visual Basic®, Scripting Edition, XML, and other tools and languages to work with the data-mining engine

About this title

Review

According to Data Mining with Microsoft SQL Server 2000 Technical Reference, your organisational database is only as good as the strategic data you can extract from it. Do customers who buy breakfast cereal typically buy bananas as well? Is there a correlation between rainfall in a particular region and the prevalence of a particular illness there? Data Mining with Microsoft SQL Server 2000 Technical Reference shows how to use Microsoft's analysis tools for large databases. Author Claude Seidman offers advice on the data-modelling engineering process as a whole, including designing strategies likely to yield meaningful results, designing data warehouses, growing decision trees, spotting clusters and anomalies in data and automating mining processes with code.

Despite its designation as a reference, this book is largely a tutorial--you'll refer to it for advice on how to make Analysis Services do something in particular. Seidman uses a classic and effective tutorial technique, sticking with an example throughout the book and adding to previous examples as he explores additional aspects of Microsoft data mining. His illustration involves identifying edible mushrooms, based on a database of facts about known mushrooms, and he's combined how-to prose with screen shots and accumulated wisdom to great effect. If your organisation has gone with Microsoft SQL Server 2000 for data storage, read this book for advice on knowledge extraction. --David Wall

Topics covered: Microsoft Analysis Services, including the proper use of Data Transformation Services (DTS), PivotTable Services, Decision-Support Objects (DSO), and the Microsoft implementation of Online Analytical Processing (OLAP ).

From the Back Cover

With its state-of-the-art capabilities for rapidly processing and retrieving huge quantities of data, Microsoft(r) SQL Server 2000 is quickly growing in popularity among large corporations. But learning how to take advantage of the powerful, built-in data-mining services in SQL Server to turn all that data into meaningful information takes time and effort. Data Mining with SQL Server 2000 Technical Reference is the ideal, in-depth reference guide for any database developer, administrator, or IT professional who needs comprehensive information about these powerful new data-mining services. In particular, it fully examines the data-warehousing architecture in SQL Server 2000 to show how to take full advantage of the data-mining services in this RDBMS. This is the only Microsoft-approved technical guide to the data mining services in SQL Server 2000.

Edition details

• Publisher: Microsoft Press US
• Publication date: 2001
• ISBN 10: 0735612714
• ISBN 13: 9780735612716
• Binding: Hardcover
• Language: English
• Edition number: 1
• Number of pages: 384