A conceptual model for the logical design of temporal databases

  • Authors:

  • Debabrata Dey;Terence M. Barron;Veda C. Storey

  • Affiliations:

  • Department of Information Systems and Decision Sciences, Louisiana State University, Baton Rouge, LA 70803, USA;Department of Information Systems and Operations Management, University of Toledo, Toledo, OH 43606, USA;Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA

  • Venue:
  • Decision Support Systems
  • Year:
  • 1995

Quantified Score

Hi-index 0.00

Visualization

Abstract

Although widely advocated as a tool for the conceptual modelling of data, the Entity-Relationship (E-R) model [4] and its extensions are generally lacking in constructs to model the dynamic nature of the real world, making them inadequate for designing temporal databases. This research first extends the E-R model to a Temporal Event-Entity-Relationship Model (TEERM), by introducing events as an additional construct. Second, a method is proposed for mapping this conceptual model into a temporal relational model for the logical design of temporal relational databases with a corresponding set of integrity constraints. The model is illustrated with an example and evaluated using a set of criteria proposed by ^B^a^t^i^n^i^ ^e^t^ ^a^l^.^ ^[^2^]. The model appears to be expressive, simple and easy to use, and should, therefore, aid the temporal database design process significantly.