Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals

Front Cover
John Wiley & Sons, Apr 7, 2004 - Computers - 544 pages
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.

From inside the book

What people are saying - Write a review

User ratings

5 stars
7
4 stars
1
3 stars
2
2 stars
0
1 star
0

User Review - Flag as inappropriate

Suggested for all data warehousing aspirants. I have seen several corporate EDW environments for over 10 years and over a dozen books talking about 'advanced' stuff. But it all boils down to the fundamentals and then applying your own tweaks and customizations to see what is best for the client. DWH is not an exact science.
I recommend this book to all beginners, it is plain, simple and interesting to read. And it covers almost all aspects in warehousing fundamentals.
 

User Review - Flag as inappropriate

This is an untimate book for understanding the funda. In a nutshell, this book give a clean and clear path to understand data warehousing concepts. I would advise anybody to read this book before attending a data warehouse interview (DW concepts).

Contents

Part 1 OVERVIEW AND CONCEPTS
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
Copyright

Other editions - View all

Common terms and phrases

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.

About the author (2004)

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.

Bibliographic information