Abstract
In this article, we discuss how temporal aspects of information systems can be modeled and implemented. We introduce extensions of an entity-relationship model which allow us to model temporal aspects. Moreover, we describe how these extended entity-relationship models are used to generate an application database which supports objects with temporarily restricted validity. We support historical objects (i.e. objects which are not valid any longer) and future objects (i.e. objects which will be valid in the future). Our approach is driven by requirements from a real-world project. In this project we had to support temporal aspects of objects in an information system supporting business processes from the area of housing construction and administration.
Chapter PDF
Similar content being viewed by others
References
Ait-Braham, A., Theodoulidis, B. and Karvelis, G.: 1994, Conceptual Modelling and Manipulation of Temporal Databases, in P. Loucopoulos (ed.), Proceedings of the 13 th International Conference on the Entity-Relationship Approach,Springer, Manchester, UK, pp. 296–313. Appeared as Lecture Notes in Computer Science no. 881.
Bhargava, G. and Gadia, S.: 1993, Relational Database Systems with zero information-loss, IEEE Transactions on Knowledge and Data Engineering 5 (7), 76–87.
Clifford, J. and Crocker, A.: 1993, The Historical Relational Data Model (HRDM) Revisited, in A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev and R. Snodgrass (eds), Temporal Databases, The Benjamin/Cummings Publishing Company, Redwood City, CA, US, pp. 626
Clifford, J., Croker, A. and Tuzhilin, A.: 1994, On completeness of historical relational query languages, IEEE Transactions on Database Systems 19 (1), 64–116.
Dinkhoff, G., Gruhn, V., Saalmann, A. and Zielonka, M.: 1994, Business Process Modeling in the Workflow Management Environment LEU, in P. Loucopoulos (ed.), Proceedings of the 13 th International Conference on the Entity-Relationship Approach,Springer, Manchester, UK, pp. 46–63. Appeared as Lecture Notes in Computer Science no. 881.
Gadia, S.: 1988, A homogenous relational model and query languages for temporal databases IEEE Transactions on Database Systems 13(4), 418–448.
Gadia, S. and Vaishnav, J.: 1985, A query language for a homogenous temporal database Proceedings of the ACM Symposium on Principles of Database Systems, pp. 51–56.
G. Kappel, Pröll, B., Rausch-Schott, S. and Retschitzegger, W.: 1995, TriGSflow Active Object-Oriented Workflow Management, Hawaii International Conference on System Sciences (HICSS’95), Hawaii, USA.
Gruhn, V., Pahl, C. and Weyer, M.: 1995, Data Model Evolution as a Basis of Business Process Management 00ER95: Object-Oriented and Entity-Relationship Modeling, Springer, Berlin, Gold Coast, Australia, pp. 270–281. Appeared as Lecture Notes in Computer Science 1021.
Gruhn, V. and Wolf, S.: 1994, Software-Entwicklung auf der Basis von Geschäftsprozeß-Management, Theorie und Praxis der Wirtschaftsinformatik 31(180), 116–125.
Gruhn, V. and Wolf, S.: 1995, Software Process Improvement by Business Process Orientation, Software Process Improvement and Practice 1, 49–56. Pilot Issue.
Hou, W. and Ozsoyoglu, G.: 1993, Processing real-time aggregate queries in CASE-DB, IEEE Transactions on Database Systems 18 (2), 224–261.
Jensen, C., Clifford, J., Gadia, S., Segev, A. and Snodgrass, R.: 1994, A Consensus Glossary of Temporal Database Concepts, SIGMOD Record 23(1), 52–64.
Jensen, C., Soo, M. and Snodgrass, R.: 1989, Unifying Temporal Models via a Conceptual Model, Information Systems 19(7), 513–547.
Ozsoyoglu, G. and Snodgrass, R.: 1995, Temporal and Real-Time Databases: A Survey, IEEE Transactions on Knowledge and Data Engineering 7(4), 513–532.
Pissinou, N., Snodgrass, R., Elmasri, R., Mumick, I., Ozsu, M., Percini, B., Segev, A. and Theodoulidis, B.: 1994, Towards an Infrastructure for Temporal Databases: Report on Invitational ARPA/NSF Workshop, Technical Report TR 9.4–01, University of Arizona.
Snodgrass, R.: 1995, The TSQL2 Temporal Query Language, Kluwer Academic Publishers.
Snodgrass, R. and Ahn, I.: 1985, A Taxonomy of Time in Databases, Proceedings of the Fourth ACM SIGMOD, New York, NY, US, pp. 236–246.
Snodgrass, R. and Ahn, I.: 1986, Temporal Databases, IEEE Computer 19, 35–42.
Tansel, A., Clifford, J., Gadia, S., Jajodia, S., Segev, A. and Snodgrass, R.: 1993, Temporal Databases, The Benjamin/Cummings Publishing Company, Redwood City, CA, US.
Wieringa, R., de Jonge, W. and Spruit, P.: 1994, Roles and dynamic subclasses: a modal logic approach, in M. Tokoro and R. Pareschi (eds), Proceedings of the European Conference on Object-Oriented Programming, Bologna, Springer, Berlin, pp. 32–59. Appeared as Lecture Notes in Computer Science no. 821.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Springer Science+Business Media Dordrecht
About this chapter
Cite this chapter
Gruhn, V., Fegert, M., Schneider, M. (1998). Modeling and Implementation of Temporal Aspects of Objects in Commercial Information Systems. In: Spaccapietra, S., Maryanski, F. (eds) Data Mining and Reverse Engineering. IFIP — The International Federation for Information Processing. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35300-5_20
Download citation
DOI: https://doi.org/10.1007/978-0-387-35300-5_20
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4757-4910-6
Online ISBN: 978-0-387-35300-5
eBook Packages: Springer Book Archive