Data warehousing is revolutionizing the way businesses in a wide variety of industries perform analysis and make strategic decisions. This volume offers IT professionals comprehensive coverage of every significant topic in data warehousing systems.

The author provides a complete overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals will gain a clear understanding of techniques for extraction of data from source systems, data transformations, data staging, data warehouse architecture and infrastructure, and the various methods for information delivery.

Data Warehousing Fundamentals includes review questions and exercises appropriate for self-study or classroom work, industry examples applicable to real-world situations, and an appendix containing valuable guidelines for evaluating vendor solutions. Specifically written for professionals designing, implementing, or maintaining data warehousing systems, this practical book spans the entire landscape of the subject.

Designed as a basic textbook, with the requisite true-and-false questions, chapter summary, and review exercises at the conclusion of each chapter, Ponniah's work will appeal to IT professionals who already design, implement, or maintain data warehousing systems as well as novices to the subject. The basic elements of data warehousing are described before Ponniah turns to topics of project management, defining business requirements, the architecture and infrastructure, the role of metadata, implementation, growth, and maintenance. Ponniah first developed this course at a community college in North Branch, New Jersey.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

"Ponniah's work will appeal to IT professionals who already design, implement, or maintain data warehousing systems as well as novices to the subject." (SciTech Book News, Vol. 25, No. 4, December 2001)

Eine Einführung in das Thema Data Warehousing - speziell für IT-Fachleute, die sich in dieses Gebiet einarbeiten wollen. Planung, Systemvoraussetzungen, Architektur, Infrastruktur, Design, Datenaufbereitung, Implementation und Wartung - anhand vieler Beispiele, Fallstudien aus der Industrie und Übungsaufgaben werden alle wichtigen Aspekte des Data Warehousing besprochen.

Includes bibliographical references (p. 501-502) and index.

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.