The Enterprise Data Warehouse, Volume I
Planning, Building and Implementation
Published on 4. May 1999
Book
Paperback/Softback
368 pages
978-0-13-905845-5 (ISBN)
Description
This is an "in-the-trenches" guide to deploying data warehouses that align tightly with your business objectives. From Joint Application Development (JAD) techniques that maximize bang for the buck, to choosing the best hardware, software and end-user access components, Eric Sperley delivers field-tested techniques you can rely on. Coverage includes enterprise data modeling, including Transactional ER and Analytical Star approaches; key architectural tradeoffs; how to build metadata repositories that illuminate your data resources, and more. Discover how to improve data quality without breaking the bank; and learn sophisticated data mining techniques, including genetic algorithms, neural networks and clustering. Sperley delivers a practical, business-focused methodology that's flexible enough for any enterprise--and so detailed it'll never leave you wondering what to do next. The accompanying CD-ROM contains high-level project plans, sample data models, state-of-the-art data warehouse trialware, data warehousing Web links, and a demo you can use to show the practical value of data warehousing.
More details
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 245 mm
Width: 185 mm
Thickness: 30 mm
Weight
887 gr
ISBN-13
978-0-13-905845-5 (9780139058455)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Eric Sperley is Technical Consultant at Hewlett-Packard Company, based in Bellevue, Washington.
Content
(NOTE: Each chapter begins with an Introduction and concludes with Questions and Projects.)
Preface.
1. Brief History of Information Technology.
History of IT.
Silos of Business Information.
What a Data Warehouse Is. Answering Business Questions. The Enterprise Data Model. Methodology Outline: Scope, Pilot, Production.
Spiral Process. Rapid Application Development.
Data Warehouse Architecture. Information Worker Access.
2. Business and IT Alignment for the Data Warehouse.
Development Tutorial. Business Process Reengineering. Business and IT Alignment.
Positional Assessment. Capabilities Position. Situational Assessment. Value Chain Assessment.
The Flexible IT Department. Open System. ROI and Justification. IT Service Management.
3. How to Plan and Build a Data Warehouse.
Business Needs Analysis. IT Readiness Evaluation. Project Selection. Warehouse Conceptual Architecture. Warehouse Logical Architecture. Warehouse Physical Architecture. Data Architecture. Implementation.
4. Project Selection and Scope.
Business Requirements Discovery: Executive Interviews. Business Requirements Definition: JAD Sessions. Scoping and Estimation. Planning.
Define the Project. Plan the Project. Manage the Project.
Team Members and Skill Sets.
5. Data Modeling.
Entities.
Enterprise Data Modeling.
Just-Enough Enterprise Data Model.
Star Schema Analysis: Creating the Dimensional Model.
Model Development Methods. Granularity. Time. Events.
Developing the Dimensional Model. Snowflakes. Physical Modeling. Ten Commandments of Dimensional Data Modeling. Two Faces of the Pyramid: Transactional ER and Analytical Star.
6. The Metadata Repository.
Introduction: What is Metadata? The Metadata Usage Model.
Implementation-Time Metadata. Active Run-Time Metadata. Passive Run-Time Metadata.
The Metadata Dimensions Model.
Activities Metadata. Locations Metadata. Entities Metadata. People Metadata. Motivation Metadata. Time Metadata. Metadata Capture and Maintenance. Initial Metadata Creation. Large Warehouse or Multiple-Subject- Area.
The Information Users' Guide.
7. Achieving Quality Information in the Data Warehouse.
The Value of Quality Information. Difficulty of Obtaining Quality Data. Methods to Evaluate the Value of Quality Data. For What Quality Should We Strive? Methods to Evaluate the Data. Tools to Evaluate the Data. The Data Evaluation or Audit.
8. The Conceptual and Logical Data Warehouse.
Why Principle-Centered? Metaprinciples: Principles About the Principles. The Principles.
General Principles. Data Principles. Query Principles. Working Store Principles. Metadata Principles. Scalability Principles. Warehouse Management Principles. Architectural Principles and the Zachman Framework. Architectural Principles Summary.
Conceptual Models.
Unplanned Decision Support. Virtual Data Warehouse. Semantic Integration of Subject Areas. Query Managed Subject Areas. Monolithic Warehouse. Standard Data Archive.
Architecture Selection.
Unplanned Decision Support. Virtual Data Warehouse. Semantic Integration of Subject Areas. Query Managed Subject Areas. Monolithic Warehouse. Standard Data Archive.
Logical Models.
9. The Physical Data Warehouse.
Physical Storage. Database Considerations. The Database Server Hardware. Operating Systems.
Performance. Resilience. Integration. Security. Manageability.
The Query Server and the Application Server. Networks and Connectivity. Middleware.
Usage Tracker. Intelligent Warehouse. Transaction Processing Monitors. Middleware Selection.
Knowledge Engineering Workstations. Deploying the Architecture.
10. Data Transformation.
Planning. Data Extraction and Movement Methods. Data Transformation. Data Loading.
11. Data Access.
Tool Selection.
Information Consumer Types. All That FLAP. Vendor Selection Criterion.
Information Distribution. Web Access. Spreadsheets. Visualization Tools. Query Tools.
Technical Functionality. Query Functionality. Presentation Functionality. Interface Functionality.
EIS and DSS Tool Types.
Query Management.
Data Mining Introduction.
12. Data Mining.
Data Preparation. Neural Networks. The Genetic Algorithm. Clustering and Classification. Decision Trees. Statistics.
Regression Modeling. Discriminant Analysis.
Software Products. Software Example.
Glossary.
Bibliography.
References.
Index.
Preface.
1. Brief History of Information Technology.
History of IT.
Silos of Business Information.
What a Data Warehouse Is. Answering Business Questions. The Enterprise Data Model. Methodology Outline: Scope, Pilot, Production.
Spiral Process. Rapid Application Development.
Data Warehouse Architecture. Information Worker Access.
2. Business and IT Alignment for the Data Warehouse.
Development Tutorial. Business Process Reengineering. Business and IT Alignment.
Positional Assessment. Capabilities Position. Situational Assessment. Value Chain Assessment.
The Flexible IT Department. Open System. ROI and Justification. IT Service Management.
3. How to Plan and Build a Data Warehouse.
Business Needs Analysis. IT Readiness Evaluation. Project Selection. Warehouse Conceptual Architecture. Warehouse Logical Architecture. Warehouse Physical Architecture. Data Architecture. Implementation.
4. Project Selection and Scope.
Business Requirements Discovery: Executive Interviews. Business Requirements Definition: JAD Sessions. Scoping and Estimation. Planning.
Define the Project. Plan the Project. Manage the Project.
Team Members and Skill Sets.
5. Data Modeling.
Entities.
Enterprise Data Modeling.
Just-Enough Enterprise Data Model.
Star Schema Analysis: Creating the Dimensional Model.
Model Development Methods. Granularity. Time. Events.
Developing the Dimensional Model. Snowflakes. Physical Modeling. Ten Commandments of Dimensional Data Modeling. Two Faces of the Pyramid: Transactional ER and Analytical Star.
6. The Metadata Repository.
Introduction: What is Metadata? The Metadata Usage Model.
Implementation-Time Metadata. Active Run-Time Metadata. Passive Run-Time Metadata.
The Metadata Dimensions Model.
Activities Metadata. Locations Metadata. Entities Metadata. People Metadata. Motivation Metadata. Time Metadata. Metadata Capture and Maintenance. Initial Metadata Creation. Large Warehouse or Multiple-Subject- Area.
The Information Users' Guide.
7. Achieving Quality Information in the Data Warehouse.
The Value of Quality Information. Difficulty of Obtaining Quality Data. Methods to Evaluate the Value of Quality Data. For What Quality Should We Strive? Methods to Evaluate the Data. Tools to Evaluate the Data. The Data Evaluation or Audit.
8. The Conceptual and Logical Data Warehouse.
Why Principle-Centered? Metaprinciples: Principles About the Principles. The Principles.
General Principles. Data Principles. Query Principles. Working Store Principles. Metadata Principles. Scalability Principles. Warehouse Management Principles. Architectural Principles and the Zachman Framework. Architectural Principles Summary.
Conceptual Models.
Unplanned Decision Support. Virtual Data Warehouse. Semantic Integration of Subject Areas. Query Managed Subject Areas. Monolithic Warehouse. Standard Data Archive.
Architecture Selection.
Unplanned Decision Support. Virtual Data Warehouse. Semantic Integration of Subject Areas. Query Managed Subject Areas. Monolithic Warehouse. Standard Data Archive.
Logical Models.
9. The Physical Data Warehouse.
Physical Storage. Database Considerations. The Database Server Hardware. Operating Systems.
Performance. Resilience. Integration. Security. Manageability.
The Query Server and the Application Server. Networks and Connectivity. Middleware.
Usage Tracker. Intelligent Warehouse. Transaction Processing Monitors. Middleware Selection.
Knowledge Engineering Workstations. Deploying the Architecture.
10. Data Transformation.
Planning. Data Extraction and Movement Methods. Data Transformation. Data Loading.
11. Data Access.
Tool Selection.
Information Consumer Types. All That FLAP. Vendor Selection Criterion.
Information Distribution. Web Access. Spreadsheets. Visualization Tools. Query Tools.
Technical Functionality. Query Functionality. Presentation Functionality. Interface Functionality.
EIS and DSS Tool Types.
Query Management.
Data Mining Introduction.
12. Data Mining.
Data Preparation. Neural Networks. The Genetic Algorithm. Clustering and Classification. Decision Trees. Statistics.
Regression Modeling. Discriminant Analysis.
Software Products. Software Example.
Glossary.
Bibliography.
References.
Index.