⊿ Point. {R} Glossary. ◢ Keyword: D. ▰ Sources. 〓 Books [B] ◥ University. {q} PhD. ⏫ THEMES. ⏫ Big Data. [B] Big Data. ⚫ USA. ↂ EndNote. ☝️ BD Dummies. Data Warehouse. Data Warehouse Overview In computing, a data warehouse (DW, DWH), or an enterprise data warehouse (EDW), is a database used for reporting and data analysis. Integrating data from one or more disparate sources creates a central repository of data, a data warehouse (DW). Data warehouses store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons. The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). A data warehouse constructed from integrated data source systems does not require ETL, staging databases, or operational data store databases. A data mart is a small data warehouse focused on a specific area of interest.
This definition of the data warehouse focuses on data storage. Benefits of a data warehouse[edit] A data warehouse maintains a copy of information from the source transaction systems. History[edit]