Affiliation:
1. Universiti Malaysia Pahang, Malaysia
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.
Reference22 articles.
1. Augeri, C. J., Bulutoglu, D. A., Mullins, B. E., Baldwin, R. O., & Baird, L. C. (2007). An analysis of XML compression efficiency. In Proceedings of the Workshop on Experimental Computer Science (pp. 1-12).
2. The design and implementation of O 2, an object-oriented database system
3. Bohannon, P., Freire, J., Roy, P., & Simeon, J. (2002). From XML schema to relations: A cost-based approach to XML storage. In Proceedings of the IEEE International Conference on Data Engineering (pp. 64-75).
4. Storing and querying XML data using an RDBMS.;D.Florescu;A Quarterly Bulletin of the Computer Society of the IEEE Technical Committee on Data Engineering,1999
5. Goldman, R., McHugh, J., & Widom, J. (1999). From semi structured data to XML: Migrating the lore data model and query language. In Proceedings of the 2nd International Workshop on the Web and Databases (pp. 25-30).