Emyliana Song
Multimedia University

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

Transforming data-centric eXtensible markup language into relational databases using hybrid approach Su-Cheng Haw; Emyliana Song
Bulletin of Electrical Engineering and Informatics Vol 10, No 6: December 2021
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.11591/eei.v10i6.2865

Abstract

eXtensible markup language (XML) appeared internationally as the format for data representation over the web. Yet, most organizations are still utilising relational databases as their database solutions. As such, it is crucial to provide seamless integration via effective transformation between these database infrastructures. In this paper, we propose XML-REG to bridge these two technologies based on node-based and path-based approaches. The node-based approach is good to annotate each positional node uniquely, while the path-based approach provides summarised path information to join the nodes. On top of that, a new range labelling is also proposed to annotate nodes uniquely by ensuring the structural relationships are maintained between nodes. If a new node is to be added to the document, re-labelling is not required as the new label will be assigned to the node via the new proposed labelling scheme. Experimental evaluations indicated that the performance of XML-REG exceeded XMap, XRecursive, XAncestor and Mini-XML concerning storing time, query retrieval time and scalability. This research produces a core framework for XML to relational databases (RDB) mapping, which could be adopted in various industries.
XMapDB-Sim: Performance Evalaution on Model-based XML to Relational Database Mapping Choices Haw Su-Cheng; Emyliana Song; Nur Amirah Azhar; Aisyah Amin
Indonesian Journal of Electrical Engineering and Computer Science Vol 7, No 2: August 2017
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.11591/ijeecs.v7.i2.pp551-566

Abstract

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 provides 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. This paper (i) reviews on some existing model-based mapping schemes focusing on how the mapping technique works, the advantages and the disadvantages, (ii) present the simulation engine to evaluate the performance of selected mapping schemes, (iii) highlight the future direction of the related area.