A Survey on Data Warehousing Issues towards Data Store Structure

Abstract

Data warehousing is a process for assembling and managing data from various sources for the purpose of ahead a single detailed view of an enterprise. The purpose of work is to study the benefits of implementing a data warehouse are as follows: To provide a single version of truth about enterprise information. This may appear somewhat noticeable but it is not unusual in an enterprise for two database systems to have two different versions of the truth. To provide a system in which managers that do not have a strong technical background are able to run complex queries. If the managers are able to access the information they require, it is likely to reduce the bureaucracy around the managers.

KEYWORDS: Data warehousing; ODS; ETL; OLTP