No abstract

Abstract. Storing XML documents in a relational database is a promising solution because relational databases are mature and scale very well and 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. In this paper, we propose an algorithm schema named XRecursive that translates XML documents to relational database according to the proposed storing structure. The steps and algorithm are given in details to describe how to use the storing structure to storage and query XML documents in relational database. Then we report our experimental results on a real database to show the performance of our method in some features.

In this paper we present a middleware for storing and retrieving XML document in relational databases. To store XML documents in relational databases, several mapping prototypes can be used. I n this prototype we chose XParent model mapping method and free of cost available technologies MySQL, Php MyAdmin and PHP classes are used the example. The key to middleware prototype is storing and retrieving XML document in a relational database, providing a user interface for XML manipulation, independent of proprietorship and without doing any modification in its basic structure. As the proposed prototype is using XParent so it will be proved to be an efficient solution with respect to query processing specially recursive XML queries and updating. The middleware prototype can also be used as the benchmarking tool for the researchers to compare various schema-oblivious XML mapping strategies after adding them as new collection.

No 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.