Abstract
The input data of the corporate data warehouse is provided by the data sources, that are integrated. In the temporal database research area, a bitemporal database is a database supporting valid time and transaction time. Valid time is the time when the fact is true in the modeled reality, while transaction time is the time when the fact is stored in the database. Defining a data warehouse as a bitemporal database containing integrated and subject-oriented data in support of the decision making process, transaction time in the data warehouse can always be obtained, because it is internal to a given storage system. When an event is loaded into the data warehouse, its valid time is transformed into a bitemporal element, adding transaction time, generated by the database management system of the data warehouse. However, depending on whether the data sources manage transaction time and valid time or not, we could obtain the valid time for the data warehouse or not. The aim of this paper is to present a temporal study of the different kinds of data sources to load a corporate data warehouse, using a bitemporal storage structure.
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
Abelló, A., Martín, C.: A Bitemporal Storage Structure for a Corporate Data Warehouse. In: Proc. of the 5th. Int. Conf. on Enterprise Information Systems (ICEIS), pp. 177–183 (2003)
Böhlen, M., Snodgrass, R.T., Soo, M.D.: Coalescing in Temporal Databases. In: Proc. of the 22nd. Int. Conf. on Very Large Data Bases (VLDB), pp. 180–191 (1996)
Clifford, J., Dyreson, C., Isakowitz, T., Jensen, C.S., Snodgrass, R.T.: On the Semantics of ‘Now’ in Databases. ACM Transactions on Database Systems 22(2), 171–214 (1997)
Inmon, W.H., Imhoff, C., Sousa, R.: Corporate Information Factory, 2nd edn. John Wiley & Sons, Chichester (1998)
Jarke, M., Lenzerini, M., Vassilious, Y., Vassiliadis, P. (eds.): Fundamentals of Data Warehousing. Springer, Heidelberg (2000)
Jensen, C.S., Clifford, J., Gadia, S.K., Segev, A., Snodgrass, R.T.: A Glossary of Temporal Database Concepts. ACM SIGMOD Record 21(3), 35–43 (1992)
Jensen, C.S., Soo, M.D., Snodgrass, R.T.: Unifying Temporal Data Models via a Conceptual Model. Information Systems 19(7), 513–547 (1994)
Pedersen, T.B., Jensen, C.S.: Research Issues in Clinical Data Warehousing. In: Proc. of the 10th. Int. Conf. on Statistical and Scientific Database Management (SSDBM), pp. 43–52 (1998)
Snodgrass, R.T., Ahn, I.: Temporal Databases. IEEE Computer 19(9), 35–42 (1986)
Snodgrass, R.T.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann Publishers, San Francisco (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Martin, C., Abelló, A. (2003). A Temporal Study of Data Sources to Load a Corporate Data Warehouse. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2003. Lecture Notes in Computer Science, vol 2737. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45228-7_12
Download citation
DOI: https://doi.org/10.1007/978-3-540-45228-7_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40807-9
Online ISBN: 978-3-540-45228-7
eBook Packages: Springer Book Archive