Migration of the Relational Data Base (RDB) to the Object Relational Data Base (ORDB)

Authors: Alae El Alami, Mohamed Bahaj

Abstract:

This paper proposes an approach for translating an existing relational database (RDB) schema into ORDB. The transition is done with methods that can extract various functions from a RDB which is based on aggregations, associations between the various tables, and the reflexive relationships. These methods can extract even the inheritance knowing that no process of reverse engineering can know that it is an Inheritance; therefore, our approach exceeded all of the previous studies made for ​​the transition from RDB to ORDB. In summation, the creation of the New Data Model (NDM) that stocks the RDB in a form of a structured table, and from the NDM we create our navigational model in order to simplify the implementation object from which we develop our different types. Through these types we precede to the last step, the creation of tables.

The step mentioned above does not require any human interference. All this is done automatically, and a prototype has already been created which proves the effectiveness of this approach.

Keywords: Relational databases, Object-relational databases, Semantic enrichment.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1091436

References:

[1] G. O. Young, "Synthetic Structure of Industrial Plastics (Book Style with Paper Title and Editor),” in Plastics, 2nd ed. vol. 3, J. Peters, Ed. New York: McGraw-Hill, 1964, pp. 15–64.
[2] Abdelsalam Maatuk, Akhtar Ali, Nick Rossiter: Semantic Enrichment: The First Phase of Relational Database Migration. In CIS2E '08, 6pp, Bridgeport, USA, 2008.
[3] Nora Koch, Hubert Baumeister, Rolf Hennicker and Luis Mandel. : Extending UML to Model Navigation and Presentation in Web Applications. In Proc. of the Workshop Modeling Web Applications in the UML, UML’00, 2000.
[4] Ming Wang. : Using UML for Object-Relational Database Systems Development: A Framework. Issues in Information Systems, VOL 9, No. 2, 2008.
[5] Maatuk, A., Ali, M. A. and Rossiter, N.: An Integrated Approach to Relational Database Migration. In IC-ICT '08, pp. 16, Bannu, Pakistan, 2008.
[6] Abdelsalam Maatuk,M. Akhtar Ali,Nick Rossiter . : Converting Relational Databases into Object-relational Databases. in JOT, vol. 9, no. 2, pages 145-161, 2010.
[7] Stonebraker, Michael, Moore and Dorothy. Object-Relational DBMSs: The Next Great Wave (Morgan Kaufmann Series in Data Management Systems) ISBN: 1558603972.
[8] K. Barclay and J. Savage-Object-Oriented Design with UML and Java,2004, ISBN 0 7506 6098 8.
[9] S. Sumathi, S. Esakkirajan —Fundamentals of Relational Database Management Systems, 2007, ISBN 978-3-540-48397-7.
[10] J.W. Rahayu, E. Pardede and D. Taniar, On Using Collection for Aggregation and Association Relationships in XML Object-Relational Storage. ACM Symposium on Applied Computing, Nicosia, Cyprus, 2004.
[11] http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html.