Editing Data warehouse (section)

{{Short description|Centralized storage of knowledge}}
[[File:Data Warehouse & Data-Marts overview.svg|400px|thumb|right|alt=Data Warehouse and Data-Marts overview|Data Warehouse and [[Data mart]] overview, with Data Marts shown in the top right.]]

In [[computing]], a '''data warehouse''' ('''DW''' or '''DWH'''), also known as an '''enterprise data warehouse''' ('''EDW'''), is a system used for [[Business intelligence|reporting]] and [[data analysis]] and is a core component of [[business intelligence]].<ref>{{cite conference|last1=Dedić|first1=Nedim|last2=Stanier|first2=Clare|year=2016|editor1-last=Hammoudi|editor1-first=Slimane|editor2-last=Maciaszek|editor2-first=Leszek|editor3-last=Missikoff|editor3-first=Michele M. Missikoff|editor4-last=Camp|editor4-first=Olivier|editor5-last=Cordeiro|editor5-first=José|title=An Evaluation of the Challenges of Multilingualism in Data Warehouse Development|url=http://eprints.staffs.ac.uk/2770/|journal=Proceedings of the 18th International Conference on Enterprise Information Systems (ICEIS 2016)|publisher=SciTePress|volume=1|pages=196–206|conference=International Conference on Enterprise Information Systems, 25–28 April 2016, Rome, Italy|conference-url=https://eprints.staffs.ac.uk/2770/1/ICEIS_2016_Volume_1.pdf |archive-url=https://web.archive.org/web/20180522180940/https://eprints.staffs.ac.uk/2770/1/ICEIS_2016_Volume_1.pdf |archive-date=2018-05-22 |url-status=live|doi=10.5220/0005858401960206|isbn=978-989-758-187-8|doi-access=free}}</ref> Data warehouses are central [[Repository (version control)|repositories]] of data integrated from disparate sources. They store current and historical data organized in a way that is optimized for data analysis, generation of reports, and developing insights across the integrated data.<ref>{{Cite web |title=What is a Data Warehouse? {{!}} Key Concepts {{!}} Amazon Web Services |url=https://aws.amazon.com/data-warehouse/ |access-date=2023-02-13 |website=Amazon Web Services, Inc. |language=en-US}}</ref> They are intended to be used by analysts and managers to help make organizational decisions.<ref name="rainer2012">{{cite book |last1=Rainer |first1=R. Kelly |url=https://archive.org/details/introductiontoin00rain_274 |title=Introduction to Information Systems: Enabling and Transforming Business, 4th Edition |last2=Cegielski |first2=Casey G. |date=2012-05-01 |publisher=Wiley |isbn=978-1118129401 |edition=Kindle |pages=[https://archive.org/details/introductiontoin00rain_274/page/n138 127], 128, 130, 131, 133 |url-access=limited}}</ref>
[[File:Data warehouse architecture.jpg|thumb|upright=1.5|The basic architecture of a data warehouse]]

The data stored in the warehouse is [[upload]]ed from [[operational system]]s (such as marketing or sales). The data may pass through an [[operational data store]] and may require [[data cleansing]] for additional operations to ensure [[data quality]] before it is used in the data warehouse for reporting.

The two main workflows for building a data warehouse system are [[extract, transform, load]] (ETL) and [[extract, load, transform]] (ELT).