Data Warehousing Fundamentals: A Comprehensive Guide for IT ProfessionalsEine Einführung in das Data Warehousing - speziell für IT-Fachleute, die sich in dieses Gebiet einarbeiten wollen. Behandelt werden alle wichtigen Themen wie Planung, Systemvoraussetzungen, Architektur, Infrastruktur, Design, Datenaufbereitung, Implementation und Wartung. Der Stoff wird anhand zahlreicher Beispiele, Fallstudien aus der Industrie und Übungsaufgaben anschaulich und nachvollziehbar dargestellt. Autor Paulraj Ponniah verfügt über 25 Jahre Erfahrung in Design und Implementation von Datenbanken und Data Warehousing Anwendungen. Er hat u.a. so namhafte Unternehmen wie Texaco, Sotheby's, Blue Cross/Blue Shield, NA Philips und Bantam-Doubleday-Dell betreut. "Data Warehousing Fundamentals" - ein topaktuelles Buch zu einem brisanten Thema. |
From inside the book
Page xii
... Options 150 1 Server Hardware 158 1 Database Software 164 1 Parallel Processing Options 1 Selection of the DBMS 166 1 Collection of Tools 167 1 Architecture First, Then Tools 1 Data Modeling 169 1 Data Extraction 169 1 Data ...
... Options 150 1 Server Hardware 158 1 Database Software 164 1 Parallel Processing Options 1 Selection of the DBMS 166 1 Collection of Tools 167 1 Architecture First, Then Tools 1 Data Modeling 169 1 Data Extraction 169 1 Data ...
Page xiii
... Options 1 2 Chapter Summary 200 1 2 Review Questions 201 1 2 Exercises 201 Part 4 DATA DESIGN AND DATA PREPARATION Principles of Dimensional Modeling 203 Chapter Objectives 203 From Requirements to Data Design 203 1 2 204 1 2 ...
... Options 1 2 Chapter Summary 200 1 2 Review Questions 201 1 2 Exercises 201 Part 4 DATA DESIGN AND DATA PREPARATION Principles of Dimensional Modeling 203 Chapter Objectives 203 From Requirements to Data Design 203 1 2 204 1 2 ...
Page xiv
... Options to Normalize 235 1 2 Advantages and Disadvantages 1 2 When to Snowflake 238 Aggregate Fact Tables 239 1 2 Fact Table Sizes 241 1 2 Need for Aggregates Large Dimensions 233 238 242 1 2 Aggregating Fact Tables 243 1 2 Aggregation ...
... Options to Normalize 235 1 2 Advantages and Disadvantages 1 2 When to Snowflake 238 Aggregate Fact Tables 239 1 2 Fact Table Sizes 241 1 2 Need for Aggregates Large Dimensions 233 238 242 1 2 Aggregating Fact Tables 243 1 2 Aggregation ...
Page xv
... Options 285 1 2 Reemphasizing ETL Metadata 286 1 2 ETL Summary andApproach 287 Chapter Summary 288 288 284 Review Questions Exercises 289 Data Quality: A Key to Success 291 Chapter Objectives 291 Why is Data Quality Critical? 292 1 2 ...
... Options 285 1 2 Reemphasizing ETL Metadata 286 1 2 ETL Summary andApproach 287 Chapter Summary 288 288 284 Review Questions Exercises 289 Data Quality: A Key to Success 291 Chapter Objectives 291 Why is Data Quality Critical? 292 1 2 ...
Page xviii
... Options 432 1 2 Prepare an Indexing Strategy 432 1 2 Assign Storage Structures 432 1 2 Complete Physical Model 433 Physical Design Considerations 433 1 2 Physical Design Objectives 433 1 2 From Logical Model to Physical Model 434 1 2 ...
... Options 432 1 2 Prepare an Indexing Strategy 432 1 2 Assign Storage Structures 432 1 2 Complete Physical Model 433 Physical Design Considerations 433 1 2 Physical Design Objectives 433 1 2 From Logical Model to Physical Model 434 1 2 ...
Contents
1 | |
Part 2 PLANNING AND REQUIREMENTS | 63 |
Part 3 ARCHITECTURE AND INFRASTRUCTURE | 127 |
Part 4 DATA DESIGN AND DATA PREPARATION | 203 |
Part 5 INFORMATION ACCESS AND DELIVERY | 315 |
Part 6 IMPLEMENTATION AND MAINTENANCE | 429 |
Appendix A Project Life Cycle Steps and Checklists | 493 |
Appendix B Critical Factors for Success | 497 |
Appendix C Guidelines for Evaluating Vendor Solutions | 499 |
References | 501 |
Glossary | 503 |
Index | 511 |
Other editions - View all
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals Paulraj Ponniah No preview available - 2004 |
Common terms and phrases
aggregate algorithms analysis applications architectural components attributes business dimensions capture changes chapter columns complex create data cleansing data elements data extraction data loading data marts data mining data model data quality data sources data staging data storage data structures data transformation data warehouse environment data warehouse project data warehousing database DBMS deployment dimension table dimensional model end-users enterprise example fact table Figure files functions hardware incremental loads integrated interface marketing MDDBs methods metrics MOLAP multidimensional OLAP system OLTP online analytical processing operational systems options package diagrams performance pilot platform predefined primary key product dimension programs project team queries and reports records relational requirements definition ROLAP selection server source data source systems specific staging area standards STAR schema summary techniques tion transaction types users values vendors ware Web-enabled data warehouse
Popular passages
Page 349 - Processing (OLAP) is a category of software technology that enables analysts, managers, and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user.
Page 18 - Inmon identified four characteristics of a data warehouse, which are represented in his formal definition: "... a data warehouse is a subject oriented, integrated, non-volatile and time variant collection of data in support of management's decisions.
Page 412 - Trees are normally drawn upside down, with the root at the top and the leaves at the bottom.
Page 501 - Kimball, Ralph, and Richard Merz. The Data Webhouse Toolkit: Building the WebEnabled Data Warehouse. New York: John Wiley & Sons, 2000.
Page 500 - Discovering Data Mining: From Concept to Implementation, Upper Saddle River, NJ: Prentice-Hall PTR, 1998.
Page 53 - It completes the process by providing users with knowledge to use the right information, at the right time, and at the right place.
Page 501 - Managing the Data Warehouse: Practical Techniques for Monitoring Operations and Performances, Administering Data and Tools, Managing Change and Growth, New York: Wiley, 1997.
Page 465 - ... but be careful not to bite off more than you can chew.
Page 5 - Web-enabled analysis tools enables merchants to gain insights into their customer base, manage inventories more tightly, and keep the right products in front of the right people at the right place at the right time.