Data Warehousing Fundamentals

PAULRAJ PONNIAH, PhD, is a twenty--five year IT professional who specializes in the design and implementation of data warehouse and database systems. He also teaches database and data warehousing courses.

Foreword. Preface. PART 1: OVERVIEW AND CONCEPTS. The Compelling Need for Data Warehousing. Data Warehouse: The Building Blocks. Trends in Data Warehousing. PART 2: PLANNING AND REQUIREMENTS. Planning and Project Management. Defining the Business Requirements. Requirements as the Driving Force for Data Warehousing. PART 3: ARCHITECTURE AND INFRASTRUCTURE. The Architectural Components. Infrastructure as the Foundation for Data Warehousing. The Significant Role of Metadata. PART 4: DATA DESIGN AND DATA PREPARATION. Principles of Dimensional Modeling. Dimensional Modeling: Advanced Topics. Data Extraction, Transformation, and Loading. Data Quality: A Key to Success. PART 5: INFORMATION ACCESS AND DELIVERY. Matching Information to the Classes of Users. OLAP in the Data Warehouse. Data Warehousing and the Web. Data Mining Basics. PART 6: IMPLEMENTATION AND MAINTENANCE. The Physical Design Process. Data Warehouse Deployment. Growth and Maintenance. Appendix A: Project Life Cycle Steps and Checklists. Appendix B: Critical Factors for Success. Appendix C: Guidelines for Evaluating Vendor Solutions. References. Glossary. Index.