Westerman Data Warehousing

Using the Wal-Mart Model
1. Auflage 2000
ISBN: 978-0-08-050372-1
Verlag: Elsevier Science & Techn.
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 297 Seiten, Web PDF

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.

* 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.

Autoren/Hrsg.

Westerman, Paul

Inhaltsverzeichnis

1;Front Cover;1
2;Data Warehousing: Using the WaI-Mart Model;4
3;Copyright Page;5
4;Contents;6
5;Preface;12
6;Chapter 1. What is Data Warehousing?;16
6.1;Evolution Leading up to the Data Warehouse;18
6.2;Applying the Data Warehouse Concept;34
6.3;Beyond the Enterprise Data Warehouse;42
7;Chapter 2. Project Planning;46
7.1;Before you Start;47
7.2;Planning for the Project Life Cycle;57
8;Chapter 3. Business Exploration;74
8.1;The Business Exploration Process;76
9;Chapter 4. Business Case Study and ROI Analysis;92
9.1;Business Case Study;94
9.2;ROI Analysis;101
10;Chapter 5. Organizational Integration;106
11;Chapter 6. Technology;120
11.1;The Front-end Tool;122
11.2;The Database Tool;126
12;Chapter 7. Database Maintenance;142
12.1;Capturing, Extracting, and Transferring the Source Data;143
12.2;Update Frequency;149
12.3;Loading the Data Warehouse;152
12.4;Backup/Recovery;162
12.5;Messaging;163
13;Chapter 8. Technical Construction of the WaI-Mart Data Warehouse;168
13.1;Preconstruction;169
13.2;The First Implementation;174
14;Chapter 9. Postimplementation of the WaI-Mart Data Warehouse;188
14.1;The ROI Surrounded by Chaos;189
14.2;Integrating Operational Applications;195
15;Chapter 10. Store Operations Sample Analyses;212
15.1;Basic Store Operations Information Needs;213
15.2;Store Sales;214
15.3;Comparable Store Sales;217
15.4;Flash Store Sales;219
15.5;Departmental Store Sales;224
15.6;Planned Sales;226
15.7;Competitive Store Sales;228
16;Chapter 11. Merchandising Sample Analyses;232
16.1;Basic Merchandising Information Needs;233
16.2;Basic Article POS Analysis;233
16.3;Top 25, Bottom 25 Analysis;237
16.4;Article Inventory Analysis;238
16.5;Article Selling versus Planned Selling;244
16.6;Fast-Selling Article Analysis;247
16.7;Slow-Selling Articles;248
16.8;Vendor Performance Analysis;249
16.9;Category Performance Analysis;254
16.10;Article Selling by Geographic Locations;256
16.11;Comparative Article Sales;259
16.12;Store and Article Grouping;261
16.13;Basic Affinity Selling;265
16.14;Out-Of-Stock Analysis;266
17;Chapter 12. Conclusion;270
17.1;Focus on the Business;270
17.2;Build a Team;271
17.3;Communicate Openly and Effectively;271
17.4;Apply Technology;272
18;Appendix A: Retail Formulas;274
19;Appendix B: Retail Data Model;280
20;Further Reading;298
21;Index;302