XRecursive: Connecting XML with Relational Databases

XRecursive: Connecting XML with Relational Databases

Mohammed Adam Ibrahim Fakharaldien (Universiti Malaysia Pahang, Malaysia), Jasni Mohamed Zain (Universiti Malaysia Pahang, Malaysia), Norrozila Sulaiman (Universiti Malaysia Pahang, Malaysia) and Tutut Herawan (Universiti Malaysia Pahang, Malaysia)
Copyright: © 2011 |Pages: 13
DOI: 10.4018/ijirr.2011100104
OnDemand PDF Download:
$30.00
List Price: $37.50

Abstract

Storing XML documents in a relational database is a promising solution because relational databases are mature and scale very well. They have the advantages that in a relational database XML data and structured data can coexist making it possible to build application that involve both kinds of data with little extra effort. This paper proposes an alternative method named Xrecursive for mapping XML (eXtensible Markup Language) documents to RDB (Relational Databases). The Xrecursive method does not need a DTD (Document Text Definition) or XML schema. Further, it can be applied as a general solution for any XML data. The steps and algorithm of Xrecursive are given in details to describe how to use the storing structure to storage and query XML documents in relational database. The authors report their experimental results on a real database, showing that the performance of their Xrecursive algorithm achieves better results in terms of storage size, insertion time, mapping time, and reconstruction time as compared with that SUCXENT and XParent methods. In overall, Xrecursive performs better in term of query performances as compared to the both methods.
Article Preview

Introduction

The eXtensible Markup Language (XML) is used for representing data through the internet, but this technology needs a suitable medium for storing these data. At present, three common technologies can be used to store and retrieve XML documents, i.e., native XML database, Object Oriented Database (OODB) and Relational Database (RDB). With the trend of increasing amount of XML documents on the World Wide Web, it is critical to have efficient mechanism to store and query XML documents to exploit the full power of this technology. Now day’ XML emerged as a major standard for representing data on the World Wide Web while the dominant storage mechanism for structured data is the relational databases, which has been an efficient tool for storing, searching, retrieving data from different collection of data. The ability to map XML data in relational databases is difficult mission and challenging in the world of all IT organization so there is a need to develop an interfaces and tools for mapping and storing XML data in relational databases.

Complete Article List

Search this Journal:
Reset
Open Access Articles: Forthcoming
Volume 8: 4 Issues (2018): 1 Released, 3 Forthcoming
Volume 7: 4 Issues (2017)
Volume 6: 4 Issues (2016)
Volume 5: 4 Issues (2015)
Volume 4: 4 Issues (2014)
Volume 3: 4 Issues (2013)
Volume 2: 4 Issues (2012)
Volume 1: 4 Issues (2011)
View Complete Journal Contents Listing