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

GREAT

User Review - Flag as inappropriate

Its is great work
thank you very much

All 5 reviews »

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