Abstract
Data warehouses, which are the core elements of On-Line Analytical Processing (OLAP) systems, are passive since all tasks related to analyzing and making decisions must be carried out manually. This paper introduces a novel architecture, the active data warehouse, which applies the idea of event-condition-action rules (ECA rules) from active database systems to automize repetitive analysis and decision tasks in data warehouses. The work of an analyst is mimicked by analysis rules, which extend the capabilities of conventional ECA rules in order to support multidimensional analysis and decision making.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
R. Agrawal, A. Gupta, and S. Sarawagi. Modeling Multidimensional Databases. In A. Gray and P. Larson, editors, Proc. of the 13th Intl. Conf. on Data Engineering, April 7–11, 1997 Birmingham U.K, pages 232–243. IEEE Computer Society Press.
L. Cabibbo and R. Torlone. A Logical Approach to Multidimensional Databases. In EDBT’98, Proc. of 6th Intl. Conf. on Extending Database Technology, March 23–27, 1998, Valencia, Spain, pages 183–197. Sringer LNCS 1377.
S. Castangia, G. Guerrini, D. Montesi, and G. Rodriguez. Design and Implementiation for the Active Rule Language of Chimera. In N. Revell and A M. Tjoa, editors, Proc. of the Workshop on Database and Expert Systems Applications (DEXA). OMNIPRESS, 1995.
S. Chakravarthy and D. Mishra. Snoop: An Expressive Event Specification Language for Active Databases. Data & Knowledge Engineering, 14(1):1–26, November 1994.
S. Chaudhuri and U. Dayal. An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, 26(1):65–74, March 1997.
E.F. Codd, S.B. Codd, and C.T. Sally. Providing OLAP (On-Line Analytical Processing) To User Analysts: An IT Mandate. Arbor Software Corporation, White Paper, 1993.
M. Golfarelli, D. Maio, and S. Rizzi. Conceptual Design of Data Warehouses from E/R Schemes. In H. El-Rewini, editor, HIGSS’98, Proc. of the 31st Hawaii Intl. Conf. on System Sciences, Volume VII, 1998, pages 334–343. IEEE Computer Society Press.
J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, and M. Venkatrao. Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals. Data Mining and Knowledge Discovery, 1(1):29–53, March 1997.
W. Lehner. Modeling Large Scale OLAP Scenarios. In EDBT’98, Proc. of 6th Intl. Conf. on Extending Database Technology, March 23–27, 1998, Valencia, Spain, pages 153–167. Springer LNCS 1377.
N. Paton and O. Diaz. Active database systems. ACM Computing Surveys, 31(1):63–103, March 1999.
P. Vassiliadis. Modeling Multidimensional Databases, Cubes and Cube Operations. In M. Rafanelli and M. Jarke, editors, 10th Intl. Conf. on Scientific and Statistical Database Management, Proceedings, Capri, Italy, July 1–3, 1998, pages 53–62. IEEE Computer Society Press.
P. Vassiliadis and T. Sellis. A Survey of Logical Models for OLAP Databases. ACM SIGMOD Record, 28(4):64–69, December 1999.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Schrefl, M., Thalhammer, T. (2000). On Making Data Warehouses Active. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2000. Lecture Notes in Computer Science, vol 1874. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44466-1_4
Download citation
DOI: https://doi.org/10.1007/3-540-44466-1_4
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67980-6
Online ISBN: 978-3-540-44466-4
eBook Packages: Springer Book Archive