Transforming Data-Centric XML Into Relational Databases Using Node-Based And Path-Based Approaches

eXtensible Markup Language (XML) has emerged as the standard for information representation over the Internet. However, most enterprises today have long secured the use of relational databases. Thus, it is crucial to map XML data into relational data to provide seamless integration between these dat...

Full description

Saved in:
Bibliographic Details
Main Author: Mohd Tarmizi Song, Emyliana
Format: Thesis
Published: 2020
Subjects:
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:eXtensible Markup Language (XML) has emerged as the standard for information representation over the Internet. However, most enterprises today have long secured the use of relational databases. Thus, it is crucial to map XML data into relational data to provide seamless integration between these database infrastructures. Many mapping techniques have been proposed, yet, none has provided a unified view on these techniques. Ultimately, understanding how these techniques work is important especially if one needs to decide which technique to adopt in their organization. Three objectives were set for this research. Firstly, is to study existing mapping approaches on model-based mapping scheme. Literature reviews on many existing approaches has been done to identify the advantages and shortcomings of each approach. Secondly, is to propose an efficient model-based mapping scheme to bridge XML technologies and relational databases. Lastly, is to evaluate the performance of the proposed mapping scheme as compared to existing approaches. Performance of the algorithms will be measured by using the time taken to map the data from XML into RDB and the storage size that used to store the data.