Data warehousing : using the Wal-Mart model / Paul Westerman.

Format:

Book

Author/Creator:

Westerman, Paul.

Series:

The Morgan Kaufmann Series in Data Management Systems

Language:

English

Subjects (All):

Data warehousing.

Database management.

Physical Description:

1 online resource (313 p.)

Place of Publication:

San Francisco : Morgan Kaufmann Publishers, 2001.

Language Note:

English

Summary:

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 understandi

Contents:

Front Cover; Data Warehousing: Using the WaI-Mart Model; Copyright Page; Contents; Preface; Chapter 1. What is Data Warehousing?; Evolution Leading up to the Data Warehouse; Applying the Data Warehouse Concept; Beyond the Enterprise Data Warehouse; Chapter 2. Project Planning; Before you Start; Planning for the Project Life Cycle; Chapter 3. Business Exploration; The Business Exploration Process; Chapter 4. Business Case Study and ROI Analysis; Business Case Study; ROI Analysis; Chapter 5. Organizational Integration; Chapter 6. Technology; The Front-end Tool; The Database Tool

Chapter 7. Database MaintenanceCapturing, Extracting, and Transferring the Source Data; Update Frequency; Loading the Data Warehouse; Backup/Recovery; Messaging; Chapter 8. Technical Construction of the WaI-Mart Data Warehouse; Preconstruction; The First Implementation; Chapter 9. Postimplementation of the WaI-Mart Data Warehouse; The ROI Surrounded by Chaos; Integrating Operational Applications; Chapter 10. Store Operations Sample Analyses; Basic Store Operations Information Needs; Store Sales; Comparable Store Sales; Flash Store Sales; Departmental Store Sales; Planned Sales

Competitive Store SalesChapter 11. Merchandising Sample Analyses; Basic Merchandising Information Needs; Basic Article POS Analysis; Top 25, Bottom 25 Analysis; Article Inventory Analysis; Article Selling versus Planned Selling; Fast-Selling Article Analysis; Slow-Selling Articles; Vendor Performance Analysis; Category Performance Analysis; Article Selling by Geographic Locations; Comparative Article Sales; Store and Article Grouping; Basic Affinity Selling; Out-Of-Stock Analysis; Chapter 12. Conclusion; Focus on the Business; Build a Team; Communicate Openly and Effectively; Apply Technology

Appendix A: Retail FormulasAppendix B: Retail Data Model; Further Reading; Index

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

1-281-07806-9

9786611078065

0-08-050372-1

OCLC:

476108687