Authors: Debabrata Dey, Terence M. Barron, Veda C. Storey
Tags: 1995, conceptual modeling
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-EntityRelationship 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 Batini et al. [2]. The model appears to be expressive, simple and easy to use, and should, therefore, aid the temporal database design process significantly.
Read the full paper here: https://pdf.sciencedirectassets.com/271653/1-s2.0-S0167923600X01583/1-s2.0-0167923694000448/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjENb%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCICuVQ2KwY952TD2%2BhMycsw0Ie3wSNemtrcvMeZaw%2BwJBAiEA9Dm3ZRBkKtKiIwoFozmXYFymjO3A9yuAtFokmsJl5yQqvQMIvv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARADGgwwNTkwMDM1NDY4NjUiDOzdpr7R0oVim81e5CqRAy7kS78KbsvvEHjRZXF9HBfcWZxyuAYm4qD7BpkDaDuggShplu4fV6MseueUF%2By84UvGpBzUQ%2BVqsj6%2FF8fQvyJawvTChBhYPIOaYhyASigiSNdlc8CQb1Y0Ix6UrRcQG%2BL0ckKVfJ%2Fus2su3KW8mHK2gqws0Ys9zyBvJWk96QjPDcGUTHOrMsAIyPP82lhnAD%2BXXXce83sfFqYQoW%2BK5ht60hOzegHmdLz%2BPQ7cNu5gxOfA3Kf4x2sEcrf%2F0BM5vSZuU2LVutB%2BRZr4NJOBzAECnwc9vcFsGKvBRP1Q2Aw%2BvzTAJ4R1cJDOr15ixo8xHdyY%2FgMwdcXLIx%2FNMyG2AS6QJfFqCwLZ39Zj9UeqwK4T26THhCOlE9VGq6MKrHBucIlJv%2BveCIFLx376TpI8%2Fm8UTf5HArAhIg8s3k1zlvMxMFOwQSJeGincjjMlGoYWCNJB3A1oxlPqjnVYsgaZtWiMwR8IT%2Fc1MXOoXbcxQ9Johu22nfwZ8Of6C%2BswZePTnonAvmSVc60tGEq091arjKmYML%2BglPoFOusBEvriEimEWJzEEl1ok42w9JlGqzaeR%2B03udd0Q5LaB3RoEnB0C7wI6xxH4AATVgWBJkPD%2Fx9B%2Bx9qU8IsNV3UwxTB0QsBUBa9x%2FTAS7zN4z4vzAWgJBFAN%2BiWXTcK7F6a1qbeFxZ4QUg3DNA36eXxbwTa4AnQ8j%2Fsl7eYe6g2v6MELk8fVGa4%2BulM7uLiFqUuGRuftBJeBawYeSl87Uirq%2B5bGe1u9P4HwITzdI8EKuueeDa2wEuwSaFE3BzynIRPzEfWcngLFKz7QUF1%2BTFVRkpSNmPlkOq3oOV6WurA%2FppMpSSjJV470spHxQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200825T142823Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTY46MQ5VHO%2F20200825%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=a49afc04d1962e50a477e589eaf8d1dbe31ce090ec47b6461b576c3125f96d84&hash=c816d0fab98a49d85254a5a81af18264dd32f7f630be7db256696f84475996ca&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0167923694000448&tid=spdf-fff030db-4520-40e1-9ac4-57ec48eb02a0&sid=6675431d1f93d24bc00a2406701bcf4bbb2agxrqa&type=client
