Data Warehouse{0}

Making wine has come a long way from the days of crushing grapes in an oak barrel.  Today, a wine maker in Sonoma now uses technology to aid in his wine making.  Leo McCloskey uses an off-site data warehouse to store digital recipes of the wines he produces.  It has about 35,000 different wines on file and he holds the keys to the largest wine database ever.  The data warehouse stores the unique information about the color, compounds, and fragrance about each wine.

“Data warehouse is a logical collection of information-gathered from many different operational databases- that supports business analysis activities and decision-making tasks” (Baltazan, Phillips 2009).  The article relates to the section of the chapter by showing an example of how businesses use off-site databases to store crucial information about their businesses and the information needed to run their businesses.  They use information based on marketing, inventory, sales, billing, competitor, industry, mailing list, and stock market analysis to make decisions based on the company’s needs.  In the case of the winery, the owner has broken down the elements based on color, fragrance, and the flavor of each wine.  He stores all of this information on each wine for later use if a winery wants the recipe or would like to know how to blend the wine the best way.  The winery has award winning combinations on file to use at their leisure to make even better wine combinations.  All of this combined helps to make their business a success. 

References:

Neuman, William (2001) The Grapes of Math. Issue 9 Volume 11.  Retrieved at 10.1.10 from

http://www.wired.com/wired/archive/9.11/wine.html

Baltzan, Paige; Phillips, Amy (2009). Business Driven Information Systems, Second Edition.