Cover image for Microsoft data warehousing : building distributed decision support systems
Microsoft data warehousing : building distributed decision support systems
Craig, Robert S., 1948-
Personal Author:
Publication Information:
New York : John Wiley, [1999]

Physical Description:
xv, 368 pages : illustrations ; 24 cm
General Note:
"Wiley computer publishing."
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D37 C73 1999 Adult Non-Fiction Central Closed Stacks

On Order



Microsoft(r) Data Warehousing, Building Distributed Decision Support Systems, Robert S. Craig Joseph A. Vivona, David Bercovitch.

Foreword by Judith Hurwitz, Robert S. Craig, Joseph A. Vivona, David Bercovitch.

Foreword by Judith Hurwitz, SQL Server 7.0's exciting new features and components make it the data warehousing tool par excellence. In Microsoft Data Warehousing, experts Robert Craig, Joseph Vivona, and David Bercovitch show database administrators and developers how to use Microsoft's new generation of powerful DSS technologies to create dynamic, highly scalable data marts and warehouses tailored to their companies' current and future decision support requirements.

In the first part of the book, the authors provide a detailed description of the data warehouse process based on the five environments that make up an integrated DSS. In Part II, they acquaint you with SQL Server 7.0 components and related Microsoft tools and then show you, step-by-step, how to best utilize them to design, develop, implement, and manage a multi-tier distributed decision-support application within each environment. You get detailed hands-on guidance for:
* Data extraction processes and tools.
* How to define the most appropriate decision support architecture.
* Different DSS tools for the Desktop including EIS, Data Mining, Extended Reporting, and Managed Query.
* Configuring SQL Server 7.0 for implementation, table definition, indexing strategies, query processing, and managing and enhancing performance.
* The role of Microsoft Repository in design, development, and management and its support of UML.
* How to achieve integration across the environments with OLE DB for OLAP and its key APIs.
* Client access using Excel, Visual Basic, Java, English Query, and other query and analysis tools with SQL Server 7.0.
* How to leverage the data in the data warehouse once it's built with various analysis scenarios such as customer relationship management, market basket, and market share.

Author Notes

Robert S. Craig is the former Director of Data Warehousing for the Hurwitz Group. He is also the author of the monthly "Database" column for ENT magazine. Craig is currently Vice President of Marketing for WebEngine, Inc., an Internet Application Server company.
Joseph A. Vivona is Vice President of Applications Development and Delivery at KPI Technologies Inc., which specializes in the development and deployment of Decision Support applications using various OLAP tools. He has more than ten years of experience in BRP and product development, focusing on how technology can be applied to help organizations reduce their amount of manual analysis and report generation for their data warehouse.
David Bercovitch has over eight years of experience working with decision-support technology and is currently a partner in The Sierra Consulting Group which specializes in creating the information-centric office, an environment where information is at the hub of corporate decision-making.

Table of Contents

Forewordp. iii
Prefacep. ix
Part I The 5 Environmentsp. 1
Chapter 1 Decision Support Architecturesp. 3
Establishing Competitive Advantagep. 3
Why Decision Support?p. 4
The Role of OLAPp. 9
The Role of Metadatap. 11
Microsoft Data Warehouse Frameworkp. 14
Chapter 2 The Source Environmentp. 17
ETML Tool Architecturesp. 18
The ETML Processp. 19
ETML Development Processp. 27
Metadatap. 39
Chapter 3 The Storage Environmentp. 41
Financial Data Warehousesp. 42
Product Data Warehousesp. 43
Customer Data Warehousesp. 44
Transactional Data Warehousesp. 46
Data Warehouse or Data Mart?p. 47
Decision Support Databasesp. 51
Chapter 4 The Desktop Environmentp. 75
The Users' Domainp. 75
Quality Reports for Consumersp. 76
Quality Tools for Providersp. 77
Tools for the Desktop Environmentp. 77
Chapter 5 The Data Warehouse Life Cyclep. 101
The Decision Support System Implementation Life Cyclep. 103
Planningp. 116
Designp. 119
Development, Testing, and Documentationp. 129
Installationp. 151
Trainingp. 161
Operational Managementp. 164
Part II Building a Microsoft-Based Decision Support Systemp. 171
Chapter 6 Design Process and Toolsp. 173
Source Environmentp. 173
Storage Environmentp. 184
Desktop Environmentp. 204
Summaryp. 212
Chapter 7 Developmentp. 213
SQL Server 7p. 213
SQL Server 7 OLAP Servicesp. 224
Data Transformation Servicesp. 239
Replicationp. 242
Microsoft Repositoryp. 244
Accessing Data with OLE DBp. 245
Desktop Tools for Data Accessp. 249
Chapter 8 Implementationp. 253
SQL Server and Client Toolsp. 253
Installationp. 256
Data Warehousep. 258
End-User Tools and Applicationsp. 260
Data Conversionp. 261
Trainingp. 264
Documentationp. 267
Summaryp. 272
Chapter 9 Operations and Managementp. 273
Protecting Data Integrityp. 273
Data Securityp. 284
System Performancep. 288
Summaryp. 313
Chapter 10 Analytical Applicationsp. 315
What Is a Data Warehouse?p. 315
A Data Warehouse Business Justificationp. 317
What Users Can Do with a Data Warehousep. 320
Myths About Average Usersp. 325
Information-Centric Analysisp. 327
Multi-Dimensional Data Analysisp. 338
Summaryp. 353
Bibliographyp. 355
Indexp. 360