Abstract
This paper deals with temporal aspects in data warehouses and their effects on Online Analytical Processing (OLAP) environments. After sketching the multidimensional data model and demonstrating a conventional OLAP architecture the term Temporal OLAP (TOLAP) is introduced. A TOLAP environment is an extended conventional OLAP environment being able to handle temporal data. We choose a metadata based approach where all temporal information are stored in a repository and no modifications to the data warehouse itself are necessary. Furthermore, we propose coloured tables for the presentation of results at the end user’s client.
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.
References
Anahory, S. and Murray, D. Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems. Addison-Wesley, June 1997.
Barquin, R. and Edelstein, H. Building, Using, and Managing the Data Warehouse. Prentice Hall, 1997.
Berson, A. and Smith, S. Data Warehousing, Data Mining, and OLAP. McGraw-Hill, 1st ed., 1997.
Business Objects Inc.. Homepage BusinessObjects. http://www.businessobjects.com/,2002.
Chamoni, P. and Stock, S. Temporale Daten in Management Support Systemen (in German), Wirtschaftsinformatik, vol. 40, December 1998, pp. 513–519.
Chaudhuri, S. and Dayal, U. An Overview of Data Warehousing and OLAP Technology, SIGMOD Record, vol. 26, March 1997.
Codd, E., Codd, S., and Salley, C. Providing OLAP to User-Analysis: An IT-Mandate. Hyperion Solutions, 1993.
Cognos Inc., Homepage Cognos. http://www.cognos.com/,2002.
Colliat, G. OLAP, Relational, and Multidimensional Database Systems, SIGMOD Record, vol. 25, no. 3, 1996, pp. 64–69.
Inmon, W. Building the Data Warehouse. John Wiley & Sons, Inc., 1st ed., 1992.
Jensen, C., Clifford, J., Elmasri, R., Gadia, S., Hayes, P., and Jajodia, S. A Consensus Glossary of Temporal Database, SIGMOD Record, vol. 23, January 1994.
Kimball, R. Meta Meta Data Data. Making a List of Data About Metadata and Exploring Information Cataloging Tools, DBMS Online, March 1998.
Kimball, R. The Data Warehouse Toolkit. John Wiley & Sons, Inc., 1996.
Oracle Inc., Homepage Oracle. http://www.oracle.com/,2002.
Snodgrass, R., ed. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, 1995.
Thomsen, E. OLAP Solutions — Building Multidimensional Information Systems. John Wiley & Sons, Inc., 1st ed., 1997.
Turban, E., Aronson, J., and Aronson, J. Decision Support Systems and Intelligent Systems. Prentice Hall, 6th ed., 2000.
Westerman, P. Data Warehousing: Using the Wal-Mart Model. Morgan Kaufmann, 1st ed., 2000.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer Science+Business Media Dordrecht
About this chapter
Cite this chapter
Herden, O. (2002). Tolap. In: Haav, HM., Kalja, A. (eds) Databases and Information Systems II. Springer, Dordrecht. https://doi.org/10.1007/978-94-015-9978-8_5
Download citation
DOI: https://doi.org/10.1007/978-94-015-9978-8_5
Publisher Name: Springer, Dordrecht
Print ISBN: 978-90-481-6182-9
Online ISBN: 978-94-015-9978-8
eBook Packages: Springer Book Archive