Sunday, 28 October 2012

Why do we need a different schema for Data warehousing/Business Intelligence?

A data warehouse stores historical data that is collected from various sources and the data is time variant. The data warehouse is updated in a scheduled and controlled manner. An online system usually does not store historical data, however if history data is stored it would pose severe performance issues, further being an Online environment 2 users accessing the same set of information are likely to derive different results. An online system would provide data only from a single source, whereas a data warehouse usually has data being put in from various sources.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...