Migrating relational databases into XML documents

Abdelsalam M. Maatuk, Tawfig Abdelaziz, Akhtar Ali

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

5 Citations (Scopus)

Abstract

This paper aims to devise a method for migrating a relational database (RDB) into an XML document. Database migration is concerned with the process of converting schema and data from a source RDB, as a one-time conversion, into a target XML database to be managed and handled in its new environment. The source schema is enriched semantically and translated into a target schema, and the data stored in the source database is converted into a target database based on the new schema. The semantic enrichment process is requisite to produce an enhanced metadata model from the source database and captures essential characteristics of target XML schema, and suitable for converting RDB data into an XML document. Algorithms are developed for producing the target database according to a set of migration rules to translate all constructs of an RDB into an XML Schema, based on which RDB data is then converted. A prototype system has been implemented and empirically evaluated by testing its results, looking at our achievements and reflecting on the results. From the evaluation of results, it is concluded that the proposed solution is efficient and correct.

Original languageEnglish
Title of host publicationProceedings - 2020 21st International Arab Conference on Information Technology, ACIT 2020
PublisherInstitute of Electrical and Electronics Engineers Inc.
ISBN (Electronic)9781728188553
DOIs
Publication statusPublished - 28 Nov 2020
Event21st International Arab Conference on Information Technology, ACIT 2020 - Giza, Egypt
Duration: 28 Nov 202030 Nov 2020

Publication series

NameProceedings - 2020 21st International Arab Conference on Information Technology, ACIT 2020

Conference

Conference21st International Arab Conference on Information Technology, ACIT 2020
Country/TerritoryEgypt
CityGiza
Period28/11/2030/11/20

Keywords

  • Data Conversion
  • Data Publishing
  • Relational Database
  • Schema Translation
  • XML

Fingerprint

Dive into the research topics of 'Migrating relational databases into XML documents'. Together they form a unique fingerprint.

Cite this