Professional SQL Server 2000 Data Warehousing with Analysis Services

丛 书 名：Programmer to programmer

版本说明：1st

作     者：Chris Graves Mark Scott Mike Benkovich Paul Turley Robert Skoglund Robin Dewson Sakhr Youness Denny Lee Sam Ferguson Tony Bain Terrence Joubert 

I S B N：(纸本) 9781861005403 

出 版 社：Peer Information Inc. 

出 版 年：2001年

摘      要：From the Publisher: Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and optimize your data warehouse. There is also an in-depth discussion of the exciting new topic of Web Housing. By reading this book, you will learn how best to employ data warehousing and OLAP in your business, and how to leverage it to provide your organization with improved revenue and profitability. This book covers: Understanding Analysis Services Architecture Designing Data Warehouses and Data Marts Using Data Transformation Services (DTS) in Data Warehousing Techniques for Data Mining and Analysis Building OLAP cubes with Analysis Manager, and programmatically through DSO Securing, Administrating and Optimizing a Data Warehouse and OLAP system Using Multidimensional Expressions (MDX) to query OLAP cubes Building OLAP client applications with Visual Basic and ASP English Query, PivotTable Service This book is aimed at the SQL Server developer who wishes to learn about the enhanced data warehousing features and new services available in SQL Server 2000 Analysis Services, and IT professionals and managers who wish to investigate SQL Server s data warehousing capabilities. Author Biography: Christopher Graves is President of RapidCF, a ColdFusion development company in Canton Connecticut. Chris leads projects with Oracle 8i and SQL Server 2000 typically co