Claim Missing Document
Check
Articles

Found 4 Documents
Search

Bridging XML and Relational Databases: An Effective Mapping Scheme based on Persistent Samini Subramaniam; Su-Cheng Haw; Poo Kuan Hoong
International Journal of Electrical and Computer Engineering (IJECE) Vol 2, No 2: April 2012
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (342.265 KB)

Abstract

XML has emerged as the leading medium for data transfer over the World Wide Web. At the present days, relational database is still widely used as the back-end database in most organizations. Since there is mismatch in these two structures, an effective mapping scheme is definitely essential that provides seamless integration with relational databases. On the other hand, an immutable labeling scheme is certainly significant to dentify the XML nodes uniquely as well as supports dynamic update without having the existing labels to be re-labeled when there is an occurance of dynamic update. As such, in this paper, we propose s-XML by adopting the Persistent Labeling scheme as the annotation scheme to ensure seamless integration with relational database and able to support updates without the need to re-construct the existing labels. We conduct experiments to show that s-XML performs better in terms of mapping the XML nodes to relational databases, query retrieval and dynamic update compared to the existing approaches.DOI:http://dx.doi.org/10.11591/ijece.v2i2.215
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.
ORD-GAP: a hybrid-based labeling schemes to support XML dynamic updates Aisyah Amin; Su-Cheng Haw; Samini Subramaniam
Indonesian Journal of Electrical Engineering and Computer Science Vol 18, No 3: June 2020
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.11591/ijeecs.v18.i3.pp1596-1606

Abstract

eXtensible Markup Language (XML) has been widely used as the standard for data exchange standard over the Internet. With the fast growing rate of data, especially with high updates, it is crucial to ensure that the XML is able to cope with frequent changes with very least effect on the existing structure. Therefore, in this paper, we investigate on the existing labeling schemes and mapping approaches to gauge a better understanding in terms of the robustness of the labeling schemes and the importance of the mapping schemes. Next, we propose ORD-GAP labeling schemes to identify the structural relationship among XML nodes and yet, it is persistent to re-labeling when new nodes are inserted. Subsequently, a mapping scheme is proposed to transform XML into Relational Database (RDB). Preliminary experimental evaluation demonstrated that the proposed approach achieve 66% better as compared to ORDPATH, and 56% better as compared to ME labeling in terms of data loading time. 
Performance evaluation on structural mapping choices for data-centric XML documents Su-Cheng Haw; Emyliana Soong
Indonesian Journal of Electrical Engineering and Computer Science Vol 18, No 3: June 2020
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.11591/ijeecs.v18.i3.pp1539-1550

Abstract

eXtensible Mark-up Language (XML) has been widely used as the de facto standard for data exchange over the Web. It is crucial to ensure that the data can be mapped correctly into the underlying data storage format, that is, without any lost of information. The two mapping strategies are structural-based and model-based. The structural-based mapping involves the presence of Data Type Definition (DTD) for schema mapping while the model-based mapping does not require the present of DTD or any schema for the mapping purpose. The structural-based mapping is good especially for data-centric type of data, i.e., data which is structured and can be binded into certain schema. As such, this paper evaluates and compares the performances of two selected existing structural-based mapping via simulation. Two main evaluations are: (i) storing the XML data into relational database (RDB), and (ii) querying the XML data from the RDB. The time taken for each respective process will be recorded and compared. From the experimental results, it is observed that the s-XML approach outperformed the SAX approach in terms of storing and query evaluations for most of the test cases conducted.