Format:
Online-Ressource (xxvii, 674 p)
,
ill
,
23 cm
Edition:
Online-Ausg. 2009 Electronic reproduction; Available via World Wide Web
ISBN:
0471133051
Content:
Reviews planning and designing architecture and implementing the data warehouse.Includes discussions on how and why to apply IBM tools.Offers tips, tricks, and workarounds to ensure maximum performance.Companion Web site includes technical notes, product updates, corrections, and links to relevant material and training.
Content:
Reviews planning and designing architecture and implementing the data warehouse.Includes discussions on how and why to apply IBM tools.Offers tips, tricks, and workarounds to ensure maximum performance.Companion Web site includes technical notes, product updates, corrections, and links to relevant material and training
Note:
Description based upon print version of record
,
IBM Data Warehousing with IBM Intelligence Tools; Contents; Acknowledgments; About the Contributors; Introduction; How the Book Is Organized; Who Should Read This Book; WhatÌs on the Web Site?; Summary; Part One: Fundamentals of Business Intelligence and the Data Warehouse; Chapter 1: Overview of the BI Organization; Overview of the BI Organization Architecture; Providing Information Content; Justifying Your BI Effort; IBM and The BI Organization; Summary; Chapter 2: Business Intelligence Fundamentals; BI Components and Technologies; Warehouse Components; Analytical User Requirements
,
Dimensional Technology and BITouch Points; Zero-Latency and Your Warehouse Environment; Closed-Loop Learning; Historical Integrity; Summary; Chapter 3: Planning Data Warehouse Iterations; Planning Any Iteration; Planning the First Iteration; Identifying Opportunities with the DIF Matrix1; Planning Subsequent Iterations; Implementing a Project Approach; Summary; Part Two: Business Intelligence Architecture; Chapter 4: Designing the Data Architecture; Choosing the Right Architecture; Expected Deliverables; Modeling the Architecture; Operational Data Store; Data Architecture Strategy; Summary
,
Chapter 5: Technical Architecture and Data Management FoundationsBroad Technical Architecture Decisions; Technical Foundations for Data Management; DB2 Technical Architecture Essentials; Sizing Requirements; Summary; Part Three: Data Management; Chapter 6: DB2 BI Fundamentals; High Availability; Administration; SQL and Other Programming Features; Performance; Extensibility; Summary; Chapter 7: DB2 Materialized Query Tables; Initializing MQTs; MQT Refresh Strategies; Loading Underlying Tables; Using DB2 ALTER; Materialized View Matching; MQT Design; MQT Tuning; Materialized View Limitations
,
SummaryPart Four: Warehouse Management; Chapter 8: Warehouse Management with IBM DB2 Data Warehouse Center; IBM DB2 Data Warehouse Center Essentials; IBM DB2 Data Warehouse Center Launchpad; Process and Step Task Control; Monitoring Strategies with IBM DB2 Data Warehouse Center; Warehouse Tuning; Maintaining IBM DB2 Data Warehouse Center; DB2 Data Warehouse Center V8 Enhancements; Summary; Chapter 9: Data Transformation with IBM DB2 Data Warehouse Center; IBM DB2 Data Warehouse Center Process Model; IBM DB2 Data Warehouse Center Transformations; SQL Transformation Steps; DB2 Utility Steps
,
Warehouse Transformer StepsData Replication Steps; MQSeries Integration; User-Defined Program Steps; Vendor Integration; Microsoft OLE DB and Data Transformation Services; Summary; Chapter 10: Meta Data and the IBM DB2 Warehouse Manager; What Is Meta Data?; Classification of Meta Data; What Is the Meta Data Repository?; Feeding Your Meta Data Repository; Benefits of Meta Data and the Meta Data Repository; Attributes of a Healthy Meta Data Repository; Maintaining the Repository; Challenges to Implementing a Meta Data Repository; IBM Meta Data Technology; Meta Data Acquisition by DWC
,
Exchanging Meta Data between IBM DB2 Data Warehouse Center Instances
,
Electronic reproduction; Available via World Wide Web
Additional Edition:
Print version IBM Data Warehousing : with IBM Business Intelligence Tools
Language:
English
Bookmarklink