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

T. Thalhammer, M. Schrefl
Thal02a (2002)
Software - Practice and Experience (SP&E), Vol. 32, Issue 12, John Wiley & Sons Ltd., ISSN 0038-0644, pp. 1193-1222, 2002.
Copy  (In order to obtain the copy please send an email with subject  Thal02a  to


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.