Abstract
According to the approach of conceptual database design, database models are designed from the Entity-Relationship (ER) model. However, the real world of most database applications are related to the temporal aspects, so data modelling using the ER diagrams had encountered many difficulties. In an attempt to more naturally support the modeling of temporal aspects of information, many different temporal ER models have been proposed such as RAKE, TEER, TimeER… In order to design a logical data model, we have to develop a new conversion method. To solve the problem, this paper addresses expressing a temporal ER model as a traditional ER model. Thus, it provides a mapping algorithm to convert a temporal model to a traditional ER model. Hereby, we can inherit conversion method from a traditional ER model to a logical data model. In this paper, the TimeER model is used to represent temporal ER models, because it provide built-in support for capturing temporal aspects more sufficiently compared to other models.
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
Jensen, C.S.: Temporal Database Management. Dr. techn. thesis by Christian S. Jensen. http://people.cs.aau.dk/~csj/Thesis/
Gregersen, H., Jensen, C.S.: Temporal Entity-Relationship Models-A Survey. IEEE Transactions on Knowledge and Data Engineering 11(3), 464–497 (1999)
Quang, H., Thanh, H.T.: A mapping algorithm from TimeER model to relational model. In: ICT-Hanoi 2008: Proceedings of the 2nd Hanoi Forum on Information – Communication Technology, Hanoi, Vietnam, pp. 37–45 (2008)
Quang, H., Thanh, H.T.: Extension of Method for Converting TimeER Model to Relational Model. Journal of Computer Science and Cybernetics 25(3), 246–257 (2009)
Hoang, Q., Van Nguyen, T.: Extraction of TimeER model from a relational database. In: Nguyen, N.T., Kim, C.-G., Janiak, A. (eds.) ACIIDS 2011, Part I. LNCS, vol. 6591, pp. 57–66. Springer, Heidelberg (2011)
Hoang, Q., Nguyen, V.T.: Extraction of a Temporal Conceptual Model from a Relational Database. Int. J. Intelligent Information and Database Systems 7(4), 340–355 (2013)
Hoffer, J.A., George, J.F., Valacich, J.S.: Modern Systems Analysis and Design, 4th edn. Prentice Hall, USA (2005)
Franceschet, M., Gubiani, D., Montanari, A., Piazza, C.: A Graph-Theoretic Approach to Map Conceptual Designs to XML Schemas. ACM Transactions on Database Systems 38(1), article 6 (2013)
Nguyen Viet Chanh: Hoang Quang: An Approach to Design Temporal Database. Journal of Science, Hue University 74A(5), 99–107 (2012)
Chen, P.P.: The Entity-Relationship Model – Toward a Unified View of Data. ACM Transactions on Database Systems 1(1) (1970)
Hoang, Q.: Translation from E-R Model to Object-Oriented Model. Journal of Computer Science and Cybernetics 17(4), 78–86 (2001)
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 6th edn. Addison-Wesley, USA (2011)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Quang, H., Pham, T. (2015). Expressing a Temporal Entity-Relationship Model as a Traditional Entity-Relationship Model. In: Núñez, M., Nguyen, N., Camacho, D., Trawiński, B. (eds) Computational Collective Intelligence. Lecture Notes in Computer Science(), vol 9330. Springer, Cham. https://doi.org/10.1007/978-3-319-24306-1_47
Download citation
DOI: https://doi.org/10.1007/978-3-319-24306-1_47
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-24305-4
Online ISBN: 978-3-319-24306-1
eBook Packages: Computer ScienceComputer Science (R0)