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

By Paul Westerman

At 70 terabytes and growing to be, Wal-Mart's information warehouse continues to be the world's biggest, such a lot bold, and arguably such a lot winning advertisement database. Written by way of one of many key figures in its layout and building, info Warehousing: utilizing the Wal-Mart version delivers an insider's view of this huge, immense undertaking. always drawing from this instance, the writer teaches you the final rules and particular thoughts you want to comprehend to be a worthwhile a part of your organization's personal information warehouse undertaking, even though huge or small. you will emerge with a realistic realizing of either the company and technical points of establishing an information warehouse for storing and having access to facts in a strategically worthy approach.

What extra units this e-book aside is its specialize in the informational wishes of retail companies-including either industry and organizational concerns that impact the data's assortment and use. If retail is your box, this publication will turn out particularly helpful as you advance and enforce your company's perfect facts warehouse resolution. * Written by means of a member of the staff of 4 engineers who designed and outfitted the Wal-Mart facts Warehouse database, a group whose database layout was once well-known internally in 1991 by means of Wal-Mart with the company's staff Innovational Technical award. * offers crucial info for undertaking managers, experts, facts warehouse managers, and knowledge architects. * Takes an in-depth examine a variety of technical matters, together with structure, building ways, instrument choice, database method choice, and upkeep. * Addresses matters particular to retail enterprise: proprietors, stock, revenues research, geography, article different types, and extra. * Explains easy methods to verify enterprise requisites on the outset of the project-and the best way to improve 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

Polynomial Algorithms in Computer Algebra

For numerous years now i've been educating classes in machine algebra on the Universitat Linz, the collage of Delaware, and the Universidad de Alcala de Henares. within the summers of 1990 and 1992 i've got geared up and taught summer time faculties in laptop algebra on the Universitat Linz. steadily a collection in fact notes has emerged from those actions.

Data Dissemination and Query in Mobile Social Networks

With the expanding popularization of non-public hand held cellular units, extra humans use them to set up community connectivity and to question and percentage information between themselves within the absence of community infrastructure, developing cellular social networks (MSNet). seeing that clients are just intermittently attached to MSNets, person mobility could be exploited to bridge community walls and ahead info.

Big Practical Guide to Computer Simulations

"This precise publication is a musthave for any scholar trying first steps in laptop simulations. Any new scholar becoming a member of my computational physics crew is anticipated to first paintings via Hartmann's advisor sooner than beginning a learn undertaking. " Helmut Katzgraber affiliate Professor Texas A&M collage "This e-book is choked with important details for everybody doing machine simulations.

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

Sample text

Finally, the manipulator code tells you who or what changed the record. These key fields in your design allow you to determine who changed what data element, when, and why. For the OLTP systems that need the most up-to-date record, the largest value for a transaction sequence code or the use of a null date value in the timestamp can identify the most current record. This should not be confused with database recovery. Database recovery is used to recover the database to a consistent and stable state.

The new information could be the presentation of the data in a graph instead of as a string of numbers. This is new presentation functionality, and it can be a very powerful tool. The new information could be easier to obtain, in three minutes on-line instead of five weeks for tape. The new information could be the combination of different systems, like sales, inventory, and purchase orders. It may actually be new data! Even better, the new data may be created from the data warehouse and then fed into another system.

Provide value to the I would suggest not having too much technology company in the future. detailed in this long-term vision, although there can be some technology visions defined. This is a good place to integrate the information technology (IT) department's vision with the data warehouse concept. Knowing you are going to build an enterprise data warehouse as opposed to a data mart is a simple longterm technical vision. The technical department may be the driving force, so my advice to them is to avoid providing in-depth technical details of the data warehouse to the business people.

Download PDF sample

Rated 4.79 of 5 – based on 33 votes