Model-based XML to Relational Database Mapping Choices
Emyliana Song1, Su-Cheng Haw2, Fang-Fang Chua3
1Emyliana Song, Department of Computing and Informatics, Multimedia University, Cyberjaya, Malaysia.
2Su-Cheng Haw, Department of Computing and Informatics, Multimedia University, Cyberjaya, Malaysia.
3Fang-Fang Chua, Department of Computing and Informatics, Multimedia University, Cyberjaya, Malaysia.
Manuscript received on 26 September 2019 | Revised Manuscript received on 05 October 2019 | Manuscript Published on 22 October 2019 | PP: 123-128 | Volume-8 Issue-3S October 2019 | Retrieval Number: C10221083S19/2019©BEIESP | DOI: 10.35940/ijrte.C1022.1083S19
Open Access | Editorial and Publishing Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Extensible Markup Language (XML) technology is widely used for data exchange and data representation in both online and offline mode. This structured format language able to be transformed into other formats and share information across platforms. XML is simple; however, it is designed to accommodate changes. For this paper, a study on transformation of XML document into relational database is conducted. Crucial part of this process is how to maintain the hierarchy and relationships between data in the document into database. Approaches that are discussed in this paper each uses own unique way of data storing technique and database design. Therefore, each algorithm is assessed with three datasets constitute of small, medium and large size XML file. The efficiency of the algorithms is being tested on time taken for data storing and query execution process. At the end of the evaluation, we discuss factors that affect algorithm performance and present suggestions to improve mapping scheme for future works.
Keywords: XML-to-RDB, Model Mapping Scheme, Transformation, XML Database, XML Labeling.
Scope of the Article: Database Theory and Application