Why do we need a different schema for Data warehousing/Business - TopicsExpress



          

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. blog.cybernetwebdesign/why-do-we-need-a-different-schema-for-data-warehousingbusiness-intelligence/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
Posted on: Thu, 08 Jan 2015 08:39:08 +0000

Trending Topics



Recently Viewed Topics




© 2015