Migration of the Temporal RDB into Temporal ORDB including
DOI:
https://doi.org/10.14738/tmlai.54.2977Keywords:
Bitemporal Data, SQL, 2011, Temporal database, RDB, ORDB, Semantic EntichmentAbstract
This paper proposes an approach for migrating existing relational database (TRDB) according to SQL: 2011 standard into temporal object relational database (TORDB) including Bitemporal data. This is done with methods that can extract various functions from a TRDB, which is based on the different kind of the relationships between tables. To do that we’re going to enhance 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 method for the translation from TRDB to TORDB. We are going to take an existing RDB with bitemporal data features as input, we provide our meta-model in order to get a correct description of a data structure, enriches its metadata representation, and generates a bitemporal data Model (BTDM), which captures essential characteristics of temporal databases for migration. A prototype has been developed which proves the effectiveness of this solution, and temporal queries has been made with help of Oracle 12C.
References
(1) Jaypalsinh A. Gohil, Dr. Prashant M. Dolia .“Checking and Verifying Temporal Data Validity using Valid Time Temporal Dimension and Queries In Oracle 12c”, International Journal of Database Management Systems (IJDMS), Vol.7, No.4, August 2015.
(2) M. Kaufmann, P. M. Fischer, N. May, D. Kossmann: “Benchmarking Bitemporal Database Systems: Ready for the Future or Stuck in the Past?” . EDBT, 738-749, 2014
(3) D. Petković , “Performance Issues Concerning Storage of Time-Variant Data, Egyptian Computer Science Journal”, Vol. 38 No, 2014.
(4) Atay, C. , “ A Comparison of Attribute and Tuple Time Stamped Bitemporal Relational Data Models”, Proc. of the Int. Conf. on Applied Computer Science, p: 479-489, 2010.
(5) D. Brdjanin , S Maric , Z S Pavkovic «On Suitability of Standard UML Notation for Relational Database Schema Representation » . Enterprise Business-Process and Information Systems Modeling , Vol 248, pp 399-413, 2016
(6) Dušan Petkovic. “Temporal Data in Relational Database Systems: A
Comparison”. New Advances in Information Systems and Technologies,Vol 444,pp 13-23. 2016
(7) Chau, V.T.N. and Chittayasothorn, S. “A Temporal Object Relational SQL Language with Attribute Timestamping in a Temporal Transparency Environment,” Data & Knowledge Engineering, (67), p. 331-361, 2008.
(8) T. Chau and S. Chittayasothorn, “A Temporal Compatible Object Relational Database System”, The IEEE Southeastcon, 2007.
(9) Noh, SY., Gadia, S.K. & Jang, H. J. Cent, “Comparisons of three data storage models in parametric temporal databases”. Journal of central south university , vol 20: 1919_1927, 2013.
(10) Slavimir Vesić, Slađan Babarogić Nenad Aničić, “Use
of the Temporal Concepts in Transaction Database”, PROC. SYMORG, p 850-857 , 2014.
(11) ISO/IEC 9075-2:2011, Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation), 2011.
(12) Kulkarni, K., Michels, J. “Temporal Features in SQL: 2011”, SIGMOD Records, Vol. 41, No. 3, 2012.
(13) Maatuk, A., Ali, M. A. and Rossiter, N.: “Semantic Enrichment: The First Phase of Relational Database Migration”. In CIS2E '08, 6pp, Bridgeport, USA, 2008.
