Realizing Active Data Warehouses with Off-The-Shelf Database Technology

Active data warehouses belong to a new category of decision support systems, which automize decision making for routine decision tasks and semi-routine decision tasks. Just as active database systems extend conventional database systems with event-condition-action rules for integrity constraint enforcement or procedure execution, active data warehouses extend conventional data warehouses with analysis rules that mimic the work of an analyst during decision making. This paper demonstrates how analysis rules can be implemented on top of a passive relational data warehouse system by using commercially available database technology.