| 作 者： | （美）Microsoft公司著 |
| 出版社： | 北京大学出版社 |
| 丛编项： | 微软指定MCDBA教材 |
| 版权说明： | 本书为公共版权或经版权方授权，请支持正版图书 |
| 标 签： | Sever |
| ISBN | 出版时间 | 包装 | 开本 | 页数 | 字数 |
|---|---|---|---|---|---|
| 未知 | 暂无 | 暂无 | 未知 | 0 | 暂无 |
About This Book
Intended Audience
Reference Materials
About The CD-ROMs
Features of This Book
Chapter and Appendix Overview
Finding the Best Starting Point for You
Getting Started
The Microsoft Certified Professional Program
Microsoft Certification Benefits
Requirements for Becoming a Micerosoft
Certified Professional
Technical Training for Computer Professionals
Technical Support
Chapter 1 Benefits of Data Warehousing
About This Chapter
Before You Begin
Lesson 1: Fundamental Data Warehousing Concepts
What Is a Data Warehouse
What Is a Data Mart
Lesson Summary
Lesson 2: Benefits of Data Warehousing
The Ability to Access Enterprisewide Data
The Ability to Have Consistent Data
The Ability to Perform Analysis Quickly
Recognition of Redundancy of Effort
Discovery of Gaps in Business Knowledge or Business Processes
Decreased Administration Costs
Empowering Members of an Enterprise by Providing Them with Information
Lesson Summary
Lesson 3: Data Warehousing Features of Microsoft SQL Server 7.0
Microsoft Data Warehousing Framework
SQL Server 7.0 Data Warehousing Framework
Lesson Summary
Review
Chapter 2 Applications of Data Warehousing
About This Chapter
Before You Begin
Lesson 1: What Is a Data Warehouse
History of Corporate Data Analysis
What Is Online Analytical Processing
OLAP Data Characteristics
Lesson Summary
Lesson 2: Data Warehousing Life Cycle
Introduction to the Northwind Database
The Data Warehousing Life Cycle
Source OLTP Systems
Transformation Tools
The Data Warehouse and Data Marts
Cubes
Lesson Summary
Lesson 3: Business Scenarios
Business Scenarios
Sales Tracking
Parts Tracking
Lesson Summary
Review
Chapter 3 Challenges of Data Warehousing
About This Chapter
Before You Begin
Lesson 1: The Data Warehousing Analysis Process
Comparison of System Architectures
Business Analysis
Business Drivers
Lesson Summary
Lesson 2: An Examination of Project Management Approaches
A Golden Rule of Data Warehousing
Data Warehouse or Data Mart
Data Warehousing Issues
Effcetive Development Practices
Building the Team
Lesson Summary
Lesson 3: Identifying Technical Requirements
Lesson Summary
Review
Chapter 4 Developing the Logical Design
About This Chapter
Before You Begin
Lesson 1: Review of OLTP System Design
Entity-Relationship Diagrams
Database Table Normalization
Normalization Example
OLTP System Design Issues
Lesson Summary
Lesson 2: OLAP System Design
Designing OLAP Systems
Dimensional Modeling: The Star(Join)Schema
Dimensional Hierarchies
Consolidated vs.Snowflakde hierarchies
Information Object Dimension Tables
Dimensional and E-R Models
Lesson Summary
Lesson 3: Dimensional Schema Design
Dimensional Schema Design Steps
Lesson Summary
Lesson 4: Dimensions
Establishing Dimensions
Lesson Summary
Lesson 5: Aggregations
Designing Aggregations
Aggregations Characteristics
Aggregations Design Issues
Aggregations Example
Lesson Summary
Review
Chapter 5 Defining the Technical Architecture for a Solution
About This Chapter
Before You Begin
Lesson 1: Microsoft Data Warehousing Framework
Data Warehousing Framework Components
Microsoft Components
Data Warehousing Framework
OLE DB,ODBC,and OLE DB for OLAP
Data Transformation Services and Replication
OLAP Services
PivotTable Service
ADO and ADO MD
Microsoft English Query
Microsoft Repository
Lesson Summary
Lesson 2: SQL Server 7.0 Data Warehousing Features
Types of Servers
Backup and Restore Features
Query Processor Enhancements
Other Enhancements
Lesson Summary
Lesson 3: Setting Up the Data Warehouse Source Database
Estimating Size of the Data Warehouse
Minimizing Fact Table Size
Balancing Size and Performance
Creating a Database
Creating Tables
Creating Indexes
Lesson Summary
Review
Chapter 6 SQL Server Data Services
About This Chapter
Before You Begin
Lesson 1: Overview of SQL Server Data Services
Transferring and Transforming Data
Loading the Data Warehouse
OLE DB,ODBC,and OLE DB for OLAP
Tools for Transferring Data in SQL Server
Other Tools for Transferring Data
Lesson Summary
Lesson 2: Introduction to Data Transformation Services
Overview of DTS
The DTS Process
DTS Tools
Lesson Summary
Review
Chapter 7 Replication
About this Chapter
Befor You Begin
Lesson 1: Introduction to Distributed Data
The Need for Distributing Data
Methods of Distributing Data with SQL Server
Lesson Summary
Lesson 2: Introduction to SQL Server Replication
The Publisher/Subscriber Metaphor
Publications and Articles
Filtering Data
Subscriptions
Lesson Summary
Lesson 3: SQL Server Replication Types
Snapshot Replication
The Snapshot Replication Process
Transactional Replication
The Transactional Replication process
The Immediate Updating Subscribers Option
Merge Replication
SQL Server Replication Agents
Lesson Summary
Lesson 4: Physical Replication Models
Overview of the Replication Models
Combining Replication Models and Types
Using Replication to Update Warehoused Data
Selecting a Data Population Mechanism
Rrplecation Exercises
Lesson Summary
Review
Chapter 8 Advanced DTS
About This Chapter
Befor You Begin
Lesson 1: Planning and Creating DTS Wordflows
Restructuring and Mapping Data
Creating a DTS Package
Defining Workflows
Executing and Scheduling a DTS Package
Lesson Summary
Lesson 2: Using Data-Driven Queries to Update the Data Warehouse
What Is a Data-Driven Query
When to Use a Data-Driven Query
Performance Issues
Data-Driven Query Examples
Creating Data-Driven Query Tasks
Lesson Summary
Lesson 3: DTS Programming
DTS Object Model
DTS Package Object Internals
Transacting DTS Packages
DTS Programming Samples
Lesson Summary
Review
Chapter 9 Microsoft SQL Server OLAP Services
About This Chapter
Before You Begin
Lesson 1: Moving from OLAP Data Warehouses to Cubes
Determining Requirements
Designing and Building the OLAP
Data Warehouse Database
Extracting, Cleaning, and Loading Data
Multidimensional Structure(Cube)
Lesson Summary
Lesson 2: Microsoft SQL Server OLAP Services
OLAP Services Features
OLAP Services COM Interface
OLAP Services System Requirements
Lesson Summary
Lesson 3: Designing and Building Cubes
Building Dimensions
Creating Calculated Members
Desiging and Building Aggregations
How OLAP Services Handles Data Explosion
Lesson Summary
Lesson 4: Managing Cubes Using Storage Types and Partitions
Soring in a MOLAP Structure
Soring in a ROLAP Structure
Soring in a HOLAP Structure
Comparing Storage Structure
MOLAP vs.ROLAP
Processing, Updating, and Refreshing Cubes
Virtual Cubes
Partitions
Security
Lesson Summary
Review
Chapter 10 Data Analysis Tools and Architecture
About This Chapter
Before You Begin
Lesson 1: Data Analysis Comcepts
Drilling into Data
Data Mining
Client and Server Caching
Analyzing Data Offline
Lesson Summary
Lesson 2: Data Analysis Tools
OLAP Manager
Learn about Data Warehouse Concepts
Excel 2000
Microsoft English Query
Third-Party Products
Lesson Summary
Lesson 3: OLAP Services and PivotTable Service Architecture
Microsoft SQL Server OLAP Services Architecture
PivotTable Service
OLAP Services: Client/Server Cache
Lesson Summary
Lesson 4: Introduxtion to Programming with ADO MD Objects
Client Interfaces for OLAP
Analyzing Existion Cubes
Local Cubes
Lesson Summary
Review
Chapter 11 Using Microsoft English Query to Query Warehouse Data
About This Chapter
Before You Begin
Lesson 1: Introduction to Microsoft English Query
Enables Plain-English Queries
Simple Design Environment
COM-Compliant Engine
The English Query Design Environment
Modeling the Domain
Flow of an English Query Application
Lesson Summary
Lesson 2: Creating an English Query Application
Creating or Importing Database Schema
Defining Entities
Creating Relationships between Entities
Testing the Application
Building the Application
Lesson Summary
Lesson 3: Deploying an English Query Application
The English Query Object Model
Deploying the Application in Other Environments
Recommended Practices
Lesson Summary
Review
Chapter 12 MDX Statements and ADO MD Objects
About This Chapter
Before You Begin
Lesson 1: Introduction to MDX
MDX vs.Transact-SQL
Working with Multidimensional Data
Accessing multidimensional Data
Lesson Summary
Lesson 2: Writing an MDX Query
Building an MDX Statement
Specifying the Axes
Defining the Contents of an Axis
Defining Sets
Generating Sets of Tuples
Specifying the WHERE Member
Defining a Calculated Member
Lesson Summary
Lesson 3: Prgramming with ADO MD Objects
Retrieving Multidimensional Data
How to Create a Local Cube
ADO MD Object Usage Summary
Lesson Summary
Review
Chapter 13 Maintaining a SQL Server Data Warehouse
About This Chapter
Before You Begin
Lesson 1: Developing a Maintenance Plan
Identifying Routine maintenance Tasks
Performing Maintenance Tasks Periodically
Automating Administrative Tasks
Lesson Summary
Lesson 2: Maintaining OLAP Services Data
Maintaining OLAQ Data
Processing Cubes
Updating Dimensions
Planning Data Updates
The DTS OLAP Services Processing Task
Lesson Summary
Lesson 3: Backing Up and Restoring Databases
Backing Up Databases
Types of Backup Methods
Verifying Backups
Restoring Databases
Lesson Summary
Lesson 4: Maintaining Data and Metadata
Archiving Enterprise Data
Archiving OLAP Data
Migrating the OLAP Services Repository
Lesson Summary
Review
Chapter 14 Manahing a SQL Server Data Warehouse
About This Chapter
Before You Begin
Lesson 1: Managing Slowly Changing Dimensions
Slowly Changing Dimensional Attributes
Type 1: Overwriting the Dimension Record
Type 2: Writing Another Dimension Record
Type 3: Values in the Dimension Record
Lesson Summary
Lesson 2: Manahing Resources
Optimizing Your Comfiguration
Optimizing Your Server Configuration
Lesson Summary
Lesson 3: Managing Security
Cube-Level and Database-Level Security
Cell-Level Security
Lesson Summary
Lesson 4: Managing Performance
Optimizing Data Warehouse Performance
Optimizing Cube Design
Creating Partitions
Optimizing Based on Usage
Lesson Summary
Review
Appendix A Questions and Answers
Appendix B Database Schemas
Appendix C Performing Basic Queries
Appendix D querying Multiple Tables
Appendix E Advanced Query Techniques
Appendix F Summarizing data
Glossary
Index
