Data Warehousing Fundamentals (eBook)

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.

"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)