- process of transforming data into something useful for decision making
DATA WAREHOUSE (DWH)
-
is a repository that stores information for the decision making process
-
integrated and consistent (no delete or update, only add) (automated data collection process)
-
it show data evolution overtime
MULTIDIMENSIONAL MODEL
- in a DWH data are organized in a multidimensional structure that store data based in categories
this model can be explored interactively by the user through OLAP queries