A conceptual development framework for temporal information systems
Conceptual modelling is the activity of describing part of the real world for purposes of communication and understanding. Any conceptual modelling approach aiming to do this accurately must offer support for data changing over time. This paper presents a development framework for Temporal Information Systems. It is based on a Fact Based Model with time support. The mapping of the model onto a relational database is described and an algebra for it is defined, the operations of which operate on facts at the conceptual level. A data definition and manipulation language is defined based on the algebra and operates at the conceptual schema level rather than the database one, thus requiring little or no knowledge from the users about SQL or about how the database itself is organised.
KeywordsEntity Type Relational Algebra Fact Type Temporal Element Entity Class
Unable to display preview. Download preview PDF.
- Ariav, G., et al, Special Requirements and Approaches, Proceedings of the 1st Int. Workshop Towards an Infrastructure for Temporal Databases, March 1994.Google Scholar
- Petrounias, I., Loucopoulos, P., Time Dimension in a Fact Based Model, Proceedings of 1st Int. Conference on Object-Role Modelling, Australia, 1994.Google Scholar
- Loucopoulos, P., Petrounias, I., The Functional Requirements Model and its Metamodel, UMIST/F_CUBE/8, March 1993.Google Scholar
- Ariav, G., A Temporally Oriented Data Model, ACM Transaction on database Systems, 11(4), pp. 499–527, Dec. 1986.Google Scholar
- Clifford, J., Rao, A., A Simple, General Structure for Temporal Domains, in Proceedings of the IFIP 8/WG8.1, Working Conference on temporal Aspects in Information Systems, Sophia Antipolis, France, May 1987.Google Scholar
- Allen, J., F., Maintaining Knowledge about Temporal Intervals Communications of ACM, 26(11), Nov. 1983Google Scholar
- A Logic Oriented Approach to Knowledge and Databases Supporting Natural Language User Interfaces, ESPRIT Project 107 (LOKI), Institute of Computer Science, Research Centre of Crete, Greece, March 1986.Google Scholar
- Parent,C.,Spaccapietra,S., An Entity-Relationship Algebra, Proceedings of Int. Conference on Data Engineering, Los Angeles, pp.500–507, April 1984.Google Scholar
- McKenzie,E.,Snodgrass,R.,Evaluation of Relational Algebras Incorporating the Time Dimension in Databases,ACM Computing Surveys, Vol.23, No.1,March 1991Google Scholar
- Ait-Braham,A., Theodoulidis,B.,Karvelis, G.,Conceptual Modelling and Manipulation of Temporal Databases, Proceedings of ER94, Manchester, UK, November 1994Google Scholar