Data Warehousing: Using the Wal-Mart Model by Paul Westerman

By Paul Westerman

At 70 terabytes and growing to be, Wal-Mart's facts warehouse continues to be the world's biggest, such a lot bold, and arguably so much profitable advertisement database. Written through one of many key figures in its layout and building, information Warehousing: utilizing the Wal-Mart version can provide an insider's view of this huge, immense undertaking. constantly drawing from this instance, the writer teaches you the overall ideas and particular ideas you must comprehend to be a precious a part of your organization's personal info warehouse undertaking, although huge or small. you will emerge with a realistic figuring out of either the enterprise and technical features of establishing a knowledge warehouse for storing and having access to info in a strategically valuable approach.

What additional units this publication aside is its concentrate on the informational wishes of retail companies-including either marketplace and organizational concerns that have an effect on the data's assortment and use. If retail is your box, this e-book will end up specially necessary as you strengthen and enforce your company's perfect facts warehouse resolution. * Written through a member of the group of 4 engineers who designed and outfitted the Wal-Mart information Warehouse database, a staff whose database layout was once famous internally in 1991 through Wal-Mart with the company's staff Innovational Technical award. * offers crucial details for undertaking managers, experts, info warehouse managers, and knowledge architects. * Takes an in-depth examine a variety of technical concerns, together with structure, building methods, instrument choice, database method choice, and upkeep. * Addresses concerns particular to retail company: owners, stock, revenues research, geography, article different types, and extra. * Explains find out how to ascertain company requisites on the outset of the project-and the best way to boost go back on funding analyses after the warehouse has been introduced on-line.

Show description

Read Online or Download Data Warehousing: Using the Wal-Mart Model PDF

Similar data modeling & design books

Medical Imaging and Augmented Reality Second International Workshop

This scholarly set of well-harmonized volumes presents vital and whole insurance of the fascinating and evolving topic of scientific imaging structures. best specialists at the foreign scene take on the most recent state of the art recommendations and applied sciences in an in-depth yet eminently transparent and readable method.


Metaheuristics show fascinating homes like simplicity, effortless parallelizability, and prepared applicability to sorts of optimization difficulties. After a finished creation to the sphere, the contributed chapters during this e-book comprise causes of the most metaheuristics strategies, together with simulated annealing, tabu seek, evolutionary algorithms, synthetic ants, and particle swarms, by way of chapters that reveal their purposes to difficulties reminiscent of multiobjective optimization, logistics, automobile routing, and air site visitors administration.

Additional info for Data Warehousing: Using the Wal-Mart Model

Example text

This is an important part of the business sponsor's job. He needs to understand the problem and the impact, in terms of the project implementation, of the decisions he will make. He may know the answer immediately, he may need to call someone else, or he may never resolve the problem. In any case, a decision must be made so the development can continue at a rapid pace. Making no decision can cause huge delays in the project. Such delays will result in real costs. To minimize the project costs, the business sponsor will have to facilitate business issues and provide quick resolutions.

Like WalMart, you should be obsessed with providing business value to your company. The reason to build a Like WaI-Mart, you should be data warehouse is to have the ability to make better decisions faster based on information using current obsessedwith providing and historic data. A data warehousing application can present data in a way that will provide inforbusinessvalue to your mation to individuals so they can make better decicompany. sions. If you can focus on the business decisions that need to be made and deliver the information that is needed to make better decisions, you should be able to call the system whatever you like.

How can a data warehouse earn money? Let's use an inventory management example. A merchandise manager, through the use of the data warehouse, is able to graphically view inventory levels, sales, and deliveries. 6), she can see that the order frequency for a particular article is too long because there is a continual out-of-stock situation happening. The clear spikes and valleys of this chart, as opposed to smooth curves, visually illustrate an inventory flow problem. Knowing this, she takes action to increase the order review frequency from 14 days to 7 days, orders are placed more frequently, and the consequence is increased sales and profits!

Download PDF sample

Rated 4.89 of 5 – based on 45 votes

About the Author