Abstract
This paper presents an approach for migrating existing temporal relational database (TRDB), into temporal object relational database (TORDB). This is done by enhancing a representation of a varying time database’s structure, in order to make hidden semantic explicit. In contrast to other studies, our main goal here is to offer a first and better solution to mentioned limits to existing works, in order to provide the efficient and the correct method for the translation from TRDB to TORDB. We are going to take an existing RDB using valid time features as input, enrich its metadata representation, and generate a new valid time data Model (NVTM), which captures the most important characteristics of temporal databases for conversion. From the NVTM, we will develop our TORDB design scheme in order to simplify the implementation of a temporal object. Through this UML profile, we precede to the last step, the creation of temporal object relational tables integrating valid time aspects.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Kulkarni, K.: Michels, J.E: Temporal features in SQL: 2011. ACM SIGMOD Rec. 41(3), 34–43 (2012)
Kaufmann, M., Fischer, P.M., May, N., Kossmann, D.: Benchmarking bitemporal database systems: ready for the future or stuck in the past? In: EDBT, pp. 738–749 (2014)
Brdjanin, D., Maric, S, Pavkovic, Z.S.: On suitability of standard UML notation for relational database schema representation. In: Enterprise Business-Process and Information Systems Modeling, Vol. 248, pp. 399–413. Springer (2016)
Atay, C.E.: A comparison of attribute and tuple time stamped bitemporal relational data models. In: Proceedings of the International Conference on Applied Computer Science, pp. 479–489 (2010)
Petković, D.: Performance issues concerning storage of time-variant data. Egypt. Comput. Sci. J. 38(2), 1–11 (2014)
Chau, V.T.N., Chittayasothorn, S.: A temporal object relational SQL language with attribute timestamping in a temporal transparency environment. Data Knowl. Eng. 67, 331–361 (2008). Elsevier
Noh, S.Y., Gadia, S.K., Jang, H.: Comparisons of three data storage models in parametric temporal databases. J. Central South Univ. 20, 1919–1927 (2013)
ISO/IEC 9075-2:2011: Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (2011)
Vesić, S., Babarogić, S., Aničić, N.: Use of the temporal concepts in transaction database. In: Proceedings of the SYMORG, pp. 850–857 (2014)
Radovanović, S., Milovanović, E., Aničić, N.: Performance evaluation of temporal features defined in Oracle 12C database. In: Proceedings of the SYMORG, pp. 858–866 (2014)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG
About this paper
Cite this paper
Ain El Hayat, S., Bahaj, M. (2018). Converting Temporal Relational Database into Temporal Object Relational Database. In: Ezziyyani, M., Bahaj, M., Khoukhi, F. (eds) Advanced Information Technology, Services and Systems. AIT2S 2017. Lecture Notes in Networks and Systems, vol 25. Springer, Cham. https://doi.org/10.1007/978-3-319-69137-4_43
Download citation
DOI: https://doi.org/10.1007/978-3-319-69137-4_43
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-69136-7
Online ISBN: 978-3-319-69137-4
eBook Packages: EngineeringEngineering (R0)