Editing Data warehouse (section)

==Benefits==
A data warehouse maintains a copy of information from the source transaction systems. This architectural complexity provides the opportunity to:
* Integrate data from multiple sources into a single database and data model. More congregation of data to single database so a single query engine can be used to present data in an [[Operational Data Store|operational data store]].
* Mitigate the problem of isolation-level lock contention in [[transaction processing]] systems caused by long-running analysis queries in transaction processing databases.
* Maintain [[Provenance#Data provenance|data history]], even if the source transaction systems do not.
* Integrate data from multiple source systems, enabling a central view across the enterprise. This benefit is always valuable, but particularly so when the organization grows via merging.
* Improve [[data quality]], by providing consistent codes and descriptions, flagging or even fixing bad data.
* Present the organization's information consistently.
* Provide a single [[common data model]] for all data of interest regardless of data source.
* Restructure the data so that it makes sense to the business users.
* Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the [[operational system]]s.
* Add value to operational business applications, notably [[customer relationship management]] (CRM) systems.
* Make decision–support queries easier to write.
* Organize and disambiguate repetitive data.