Data Warehousing

1st Edition

Using the Wal-Mart Model

Authors: Paul Westerman
Paperback ISBN: 9781558606845
eBook ISBN: 9780080503721
Imprint: Morgan Kaufmann
Published Date: 18th August 2000
Page Count: 297
60.95 + applicable tax
48.99 + applicable tax
7100.00 + applicable tax
79.95 + applicable tax
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access

Table of Contents

FOREWORD ACKNOWLEDGMENTS CHAPTER 1 - WHAT IS DATA WAREHOUSING? EVOLUTION LEADING UP TO THE DATA WAREHOUSE Executive Information Systems Direct SQL Access Data Warehouse Data Mart Enterprise Data Warehouse Operational Data Store Data Warehouse is a Tool APPLYING THE DATA WAREHOUSE CONCEPT BEYOND ENTERPRISE DATA WAREHOUSE CHAPTER 2 - PROJECT PLANNING BEFORE YOU START Clear Focus on the Business Business Sponsorship Long-Term Vision Short-Term Plan Assigning a Responsible Leader Effective Communications Providing Something New Partnership Planning PLANNING FOR THE PROJECT LIFE CYCLE Analytical Phase Gathering and documenting the business requirements Logical Design of the Database and Processes Determine the Source of the Data Determine Technical Readiness Select Tools Create an Implementation Timeline and Resources Required Construction Phase Post-Production CHAPTER 3 - BUSINESS EXPLORATION THE BUSI


At 70 terabytes and growing, Wal-Mart's data warehouse is still the world's largest, most ambitious, and arguably most successful commercial database. Written by one of the key figures in its design and construction, Data Warehousing: Using the Wal-Mart Model gives you an insider's view of this enormous project. Continuously drawing from this example, the author teaches you the general principles and specific techniques you need to understand to be a valuable part of your organization's own data warehouse project, however large or small. You'll emerge with a practical understanding of both the business and technical aspects of building a data warehouse for storing and accessing data in a strategically useful way.

What further sets this book apart is its focus on the informational needs of retail companies-including both market and organizational issues that affect the data's collection and use. If retail is your field, this book will prove especially valuable as you develop and implement your company's ideal data warehouse solution.

Key Features

  • Written by a member of the team of four engineers who designed and built the Wal-Mart Data Warehouse database, a team whose database design was recognized internally in 1991 by Wal-Mart with the company's Team Innovational Technical award.
  • Provides essential information for project managers, consultants, data warehouse managers, and data architects.
  • Takes an in-depth look at a wide range of technical issues, including architecture, construction approaches, tool selection, database system selection, and maintenance.
  • Addresses issues specific to retail business: vendors, inventory, sales analysis, geography, article categories, and more.
  • Explains how to determine business requirements at the outset of the project-and how to develop return on investment analyses after the warehouse has been brought online.


Data warehouse managers, and data architects, consultants, and project Managers.


No. of pages:
© Morgan Kaufmann 2001
Morgan Kaufmann
eBook ISBN:
Paperback ISBN:

About the Authors

Paul Westerman Author

Paul Westerman is a Global Marketing Manager for Compaq Computers, Inc. He began his retail career with Wal-Mart, where he was one of the four people responsible for designing and building the Wal-Mart data warehouse-still the world's largest. Since then, Paul has played a key role in many very large data warehouses projects around the world-in the retail industry, telephone industry, and other areas-and has spoken to audiences around the world about the benefits of applying the data warehouse technology to business. He holds a BS in Computing and Information Sciences from Oklahoma State University.