Abstract
Commercial OLAP systems usually treat OLAP dimensions as static entities. In practice, dimension updates are often necessary in order to adapt the multidimensional database to changing requirements. In earlier work we proposed a temporal multidimensional model and TOLAP, a query language supporting it, accounting for dimension updates and schema evolution at a high level of abstraction. In this paper we present our implementation of the model and the query language. We show how to translate a TOLAP program to SQL, and present a real-life case study, a medical center in Buenos Aires. We apply our implementation to this case study in order to show how our approach can address problems that occur in real situations and that current non-temporal commercial systems cannot deal with. We present results on query and dimension update performance, and briefly describe a visualization tool that allows editing and running TOLAP queries, performing dimension updates, and browsing dimensions across time.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
R. Bliujute, S. Saltenis, G. Slivinskas, and G. Jensen. Systematic change management in dimensional data warehousing. Time Center Technical Report TR-23, 1998.
L. Cabibbo and R. Torlone. A logical approach to multidimensional databases. In EDBT’98: 6th International Conference on Exteding Database Technology, pages 253–269, Valencia, Spain, 1998.
C.X. Chen and C. Zaniolo. Universal temporal extesions for database languages. In Proceedings of IEEE/ICDE’99, Sydney, Australia, 1999.
W. Chen, M. Kifer, and D.S. Warren. Hilog as a platform for database language. In Proceedings of the 2nd. International Workshop on Database Programming Languages, pages 315–329, Oregon Coast, Oregon, USA, 1989.
C. Hurtado, A.O. Mendelzon, and A. Vaisman. Maintaining data cubes under dimension updates. Proceedings of IEEE/ICDE’99, 1999.
C. Hurtado, A.O. Mendelzon, and A. Vaisman. Updating OLAP dimensions. Proceedings of ACM DOLAP’99, 1999.
R. Kimball. The Data Warehouse Toolkit. J.Wiley and Sons, Inc, 1996.
L.V.S Lakshmanan, F. Sadri, and I.N. Subramanian. Logic and algebraic languages for interoperability in multidatabase systems. Journal of Logic Programming 33(2), pp.101–149, 1997.
W. Lehner. Modeling large OLAP scenarios. In EDBT’98: 6th International Conference on Exteding Database Technology, Valencia, Spain, 1998.
A.O. Mendelzon and A. Vaisman. Temporal queries in OLAP. In Proceedings of the 26th VLDB Conference, Cairo, Egypt, 2000.
T.B Pedersen and C. Jensen. Multidimensional data modeling for complex data. Proceedings of IEEE/ICDE’99, 1999.
Richard Snodgrass. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, 1995.
D. Toman. A point-based temporal extension to sql. In Proceedings of DOOD’97, Montreaux, Switzerland, 1997.
J. Widom. Research problems in data warehousing. In Proceedings of the 4th International Conference on Information and Knowledge Management, 1995.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vaisman, A.A., Mendelzon, A.O. (2002). A Temporal Query Language for OLAP: Implementation and a Case Study. In: Ghelli, G., Grahne, G. (eds) Database Programming Languages. DBPL 2001. Lecture Notes in Computer Science, vol 2397. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46093-4_5
Download citation
DOI: https://doi.org/10.1007/3-540-46093-4_5
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44080-2
Online ISBN: 978-3-540-46093-0
eBook Packages: Springer Book Archive