Data warehouses are designed in such a way that they are optimized for speed of data retrieval. To assist in speeding data retrieval, the data stored in the data warehouse is often stored multiple times, both in their most granular and summarized (aggregated) forms.
Read More... [Source: Computers-and-Technology Articles from EzineArticles.com - Posted by FreeAutoBlogger]