C. Online Data Warehousing Resources
by Michelle C. Dy, Michael W. Hawkins, Mark Humphries
Data Warehousing: Architecture and Implementation
- Copyright
- Preface
- 1. Introduction
- 1. The Enterprise IT Architecture
- The Past: Evolution of Enterprise Architectures
- The Present: The IT Professional's Responsibility
- Business Perspective
- Technology Perspective
- Architecture Migration Scenarios
- Migration Strategy: How Do We Move Forward?
- In Summary
- 2. Data Warehouse Concepts
- 1. The Enterprise IT Architecture
- 2. People
- 3. The Project Sponsor
- How Will a Data Warehouse Affect our Decision-Making Processes?
- How Does a Data Warehouse Improve My Financial Processes? Marketing? Operations?
- When Is a Data Warehouse Project Justified?
- What Expenses Are Involved?
- What Are the Risks?
- Risk-Mitigating Approaches
- Is My Organization Ready for a Data Warehouse?
- How Do I Measure the Results?
- In Summary
- 4. The CIO
- How Do I Support the Data Warehouse?
- How Will My Data Warehouse Evolve?
- Who Should Be Involved in a Data Warehouse Project?
- Steering Committee
- User Reference Group
- Warehouse Driver
- Warehouse Project Manager
- Business Analyst(s)
- Warehouse Data Architect
- Metadata Administrator
- Warehouse DBA
- Source System Database Administrators (DBAs) and System Administrators (SAs)
- Conversion and Extraction Programmer(s)
- Technical and Network Architect
- Trainer
- What Is the Team Structure Like?
- What New Skills Will My People Need?
- How Does Data Warehousing Fit into My IT Architecture?
- How Many Vendors Do I Need to Talk to?
- What Should I Look for in a Data Warehouse Vendor?
- How Does Data Warehousing Affect My Existing Systems?
- Data Warehousing and Its Impact on Other Enterprise Initiatives
- When Is a Data Warehouse Not Appropriate?
- How Do I Manage or Control a Data Warehouse Initiative?
- In Summary
- 5. The Project Manager
- How Do I Roll Out a Data Warehouse Initiative?
- How Important Is the Hardware Platform?
- What Technologies Are Involved?
- Do I Still Use Relational Databases for Data Warehousing?
- How Long Does a Data Warehousing Project Last?
- How Is a Data Warehouse Different from Other IT Projects?
- What Are the Critical Success Factors of a Data Warehousing Project?
- In Summary
- 3. The Project Sponsor
- 3. Process
- 6. Warehousing Strategy
- Strategy Components
- Determine Organizational Context
- Conduct Preliminary Survey of Requirements
- Conduct Preliminary Source System Audit
- Identify External Data Sources (If Applicable)
- Define Warehouse Roolouts (Phased Implementation)
- Define Preliminary Data Warehouse Architecture
- Evaluate Development and Production Environment and Tools
- In Summary
- 7. Warehouse Management and Support Processes
- 8. Data Warehouse Planning
- Assemble and Orient Team
- Conduct Decisional Requirements Analysis
- Conduct Decisional Source System Audit
- Design Logical and Physical Warehouse Schema
- Produce Source-to-Target Field Mapping
- Select Development and Production Environment and Tools
- Create Prototype for This Rollout
- Create Implementation Plan of This Rollout
- Warehouse Planning Tips and Caveats
- In Summary
- 9. Data Warehouse Implementation
- Acquire and Set Up Development Environment
- Obtain Copies of Operational Tables
- Finalize Physical Warehouse Schema Design
- Build or Configure Extraction and Transformation Subsystems
- Build or Configure Data Quality Subsystem
- Build Warehouse Load Subsystem
- Set Up Warehouse Metadata
- Set Up Data Access and Retrieval Tools
- Perform the Production Warehouse Load
- Conduct User Training
- Conduct User Testing and Acceptance
- In Summary
- 6. Warehousing Strategy
- 4. Technology
- 10. Hardware and Operating Systems
- 11. Warehousing Software
- 12. Warehouse Schema Design
- OLTP Systems Use Normalized Data Structures
- Dimensional Modeling for Decisional Systems
- Two Types of Tables: Facts and Dimensions
- A Schema Is a Fact Table Plus Its Related Dimension Tables
- Facts Are Fully Normalized, Dimensions Are Denormalized
- Dimensional Hierarchies and Hierarchical Drilling
- The Time Dimension
- The Granularity of the Fact Table
- The Fact Table Key Concatenates Dimension Keys
- Aggregates or Summaries
- Dimensional Attributes
- Multiple Star Schemas
- Core and Custom Tables
- In Summary
- 13. Warehouse Metadata
- 14. Warehousing Applications
- 5. Where to Now?
- 15. Warehouse Maintenance and Evolution
- Regular Warehous Loads
- Warehouse Statistics Collection
- Warehouse User Profiles
- Security and Access Profiles
- Data Quality
- Data Growth
- Updates to Warehouse Subsystems
- Database Optimization and Tuning
- Data Warehouse Staffing
- Warehouse Staff and User Training
- Subsequent Warehouse Rollouts
- Chargeback Schemes
- Disaster Recovery
- In Summary
- 16. Warehousing Trends
- Continued Growth of the Data Warehouse Industry
- Increased Adoption of Warehousing Technology by More Industries
- Increased Maturity of Data Mining Technologies
- Emergence and Use of Metadata Interchange Standards
- Increased Availability of Web-Enabled Solutions
- Popularity of Windows NT for Data Mart Projects
- Availability of Warehousing Modules for Application Packages
- More Mergers and Acquisitions Among Warehouse Players
- In Summary
- 15. Warehouse Maintenance and Evolution
- 6. Appendices
- A. R/OLAPXL® User's Manual
- Welcome to R/OLAPXL!
- Installation
- Tutorial
- User's Guide
- Working with R/OLAPXL Columns
- Adding a R/OLAPXL Column
- Moving a R/OLAPXL Column
- Deleting R/OLAPXL Columns
- Using Derived Columns
- Using Functions
- Drilling Up and Down Using R/OLAPXL Columns
- Ad Hoc Drills
- Hierarchical Drills
- Drilling Up Hierarchically
- Drilling Down Hierarchically
- Drilling To Hierarchically
- Constraining Your R/OLAPXL Worksheet
- Constraint Sets in R/OLAPXL
- Setting R/OLAPXL Options
- Rerun Report After Drilling
- Start Cell
- Suppress Repeating Values
- Cascading User Formulas in the Report Body
- Running a R/OLAPXL Report
- Using Subtotals
- Subtotals and Column Suppressing
- Subtotals and Sorting
- Sorting R/OLAPXL Reports
- Sorting and Column Suppressing
- Sorting and Subtotals
- Using Pivot Tables with your R/OLAPXL Reports
- Pivot Table Data Sources
- Commands for R/OLAPXL Pivot Table Reports
- New or View R/OLAPXL Pivot Report
- View R/OLAPXL Pivot Report Source
- Refresh R/OLAPXL Pivot Report
- Other Pivot Table Commands
- Viewing R/OLAPXL SQL Statements
- The R/OLAPXL Toolbars
- Macro Programming
- R/OLAPXL Messages
- B. Warehouse Designer® User's Manual
- C. Online Data Warehousing Resources
- D. Tool and Vendor Inventory
- E. Software License Agreement
- A. R/OLAPXL® User's Manual
A number of data warehousing resources are freely available on the World Wide Web. Aside from the data warehousing material available online from various data warehousing vendors, readers might find it helpful to visit the online resources listed below.
| International Data Warehousing Association | (http://www.idwa.org/) |
| The Data Warehousing Institute | (http://www.dw-institute.com/) |
| The Meta Data Coalition | (http://www.he.net/~metadata/) |
| The Data Warehousing Information Center | (http://www.pwp.starnetinc.com/larryg/index.html) |
| Data Warehousing on the World Wide Web | (http://www.datawarehousing.com) |
| The Data-Warehouse.Com Site | (http://www.data-warehouse.com/) |
| The Data Warehousing Knowledge Center | (http://www.datawarehouse.org/) |
| DBMS Magazine | (http://www.dbmsmag.com/) |
| CIO Magazine | (http://www.cio.com/cio) |
| Datamation Magazine | (http://www.datamation.com/) |
| Data Management Review | (http://www.dmreview.com/) |
To subscribe to the list: Send e-mail to [email protected]. The first line of your message must be "subscribe datawarehousing." No subject line is required.
Comp.databases.olap
Note that online resources constantly change and that there is no guarantee the ones listed above will continue to be available. Readers may want to visit the website of Intranet Business Systems, Inc. (URL: http://www.intranetsys.com), where links to online warehousing resources will be continuously updated.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.