Data Warehousing Fundamentals A Comprehensive Guide for IT Professionals

Geared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations.
Market: IT Professionals, Consultants.

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.