Computer Programming Software Terms, Glossary and Dictionary

DW: Data Warehouse

Data warehouse (DW) is a computer database that collects, integrates and stores an organization's data with the aim of producing accurate and timely management information and supporting data analysis. A DW typically has the following characters: 1) SUBJECT oriented, meaning that the data in the database is organised so that all the data elements relating to the same real-world event or object are linked together; 2) Time variant, meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time; 3) Non-volatile, meaning that data in the database is never over-written or deleted, but retained for future reporting; and, 4) Integrated, meaning that the database contains data from most or all of an organisation's operational applications, and that this data is made consistent.  



Related Terms:

DW: Data Warehouse