Data Warehouses

by Robert D
Data warehouses are large stores of raw data. They collect information relevant to a business and store them in a central, lesser-normalized database. The result is one big collection of data, that can be processed through queries. They’re used more for business practices, rather than keeping information on a business’s doings.

The important components of a data warehouse are the data, which pertain to anything and everything the business may want to know (this can include data on similar businesses as well), data collection, or the methods to collect the data (which is best performed through an automated service, which collects information out of other databases and similar sources), and the queries used to process the large amounts of information into something businesses can use.

Jigeesh, Kondabolu, and Santhi. “Creating a Virtual Data Warehouse for Manufacturing Industry” Journals of Operation Management. May 2011. http://0-search.proquest.com.opac.library.csupomona.edu/abicomplete/docview/869509886/1334D62BEAB100DE8D6/24?accountid=10357

Image from Cyber International, LLC. http://www.google.com/imgres?q=data+warehouse&um=1&hl=en&client=firefox-a&sa=N&rls=org.mozilla:en-US:official&biw=1280&bih=959&tbm=isch&tbnid=KOvY5JxXv9DSiM:&imgrefurl=http://cyber-international.com/Services_DM_DW.aspx&docid=RJJBnJ9zTj3VQM&imgurl=http://cyber-international.com/images/data_warehouse_1.gif&w=369&h=281&ei=hPrSTq7TD-jViALRnLHLCw&zoom=1&iact=hc&vpx=353&vpy=185&dur=737&hovh=196&hovw=257&tx=106&ty=121&sig=101481742656926588925&page=1&tbnh=125&tbnw=164&start=0&ndsp=28&ved=1t:429,r:1,s:0