In your own words what is a data warehouse and why is it important to have another copy of the data in a data warehouse?
A data warehouse is a database that copies and aggregates data from one or more operational databases to facilitate analytical operations. For example, an international electronics company with many regional branches might aggregate its local sales figures into one data warehouse to gain insights into the global operation.
It is important to maintain a separate copy of the source data for many reasons — some examples include:
- Preventing analytical operations from impacting the function of the operational database(s).
- Allowing the data to be transformed during the ETL process to further facilitate the desired analysis.
- Storing a primarily read-only dataset to keep a historical archive of important records.
No comments:
Post a Comment