Habilitation of Assist.-Prof. Mag. Dr. Christoph Georg Schütz

IT-Project Data Souvereignty in winter termin 2021/22

Business Intelligence: Washing Gold in Times of Information Overload

See all news.



You can find us here.

Active Data Warehouses: Complementing OLAP with Analysis Rules

Authors: T. Thalhammer, M. Schrefl, M. Mohania
Paper: Thal01a (2001)
Citation: Journal on Data & Knowledge Engineering (DKE), Vol. 39, No. 3, Dezember 2001, Elsevier Science Publ., pp. 241-269, ISSN 0169-023X, 2001.
Resources: Copy  (In order to obtain the copy please send an email with subject  Thal01a  to


Conventional data warehouses are passive. All tasks related to analysing data and making decisions must be carried out manually by analysts. Today's data warehouse and OLAP systems offer little support to automatize decision tasks that occur frequently and for which well established decision procedures are available. Such a functionality can be provided by extending the conventional data warehouse architecture with analysis rules, which mimic the work of an analyst during decision making. Analysis rules extend the basic ECA (event/condition/action) rule structure with mechanisms to analyse data multidimensionally and to make decisions. The resulting architecture is called active data warehouse. This paper (1) motivates the need for active data warehouses, (2) discusses various issues of analysis rules and provides a textual language for their specification, and (3) outlines how analysis rules can be implemented on top of existing relational data warehouses.