本書是《微軟件指定MCDBA教材(影印版)》叢書中的一本,講述如何使用SQL Server 7.0設(shè)計(jì)和實(shí)現(xiàn)數(shù)據(jù)倉(cāng)庫(kù)解決方案,包括需求分析、體系結(jié)構(gòu)定義、邏輯設(shè)計(jì)、物理設(shè)計(jì)、創(chuàng)建數(shù)據(jù)服務(wù)、維護(hù)、監(jiān)控和優(yōu)化等。本書還指導(dǎo)您準(zhǔn)備MCP 70-019考試(面向微軟件認(rèn)證數(shù)據(jù)庫(kù)管理員和微軟件認(rèn)證系統(tǒng)工程師)。本書由微軟件公司專家編寫,技術(shù)深入,權(quán)威性強(qiáng),可作為信息系統(tǒng)的數(shù)據(jù)倉(cāng)庫(kù)專業(yè)人員和MCP考試應(yīng)試者的參考書。
作者簡(jiǎn)介
暫缺《Microsoft SQL Server 7.0數(shù)據(jù)倉(cāng)庫(kù)開發(fā)技術(shù):英文》作者簡(jiǎn)介
圖書目錄
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