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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Grandi, F., Mandreoli, F., Tiberio, P., Bergonzini, M.: A temporal data model and management system for normative texts in XML format. In: Proceedings of the 5th ACM international Workshop on Web information and Data Management, New Orleans, Louisiana, USA, November 07 - 08 (2003)
Augeri, C.J., Bulutoglu, D.A., Mullins, B.E., Baldwin, R.O., Baird, L.C.: An analysis of XML compression efficiency. In: Proceedings of the Workshop on Experimental Computer Science, San Diego, California (June 2007)
Reed, D.: Take a good look. Data Strategy, from Business Source Complete database 2(4), 24–29 (2008)
Sybase Corporation: Using xml with the Sybase adaptive server sol databases. Technical whitepaper( August 21, 1999)
XRel: a path-based approach to storage and retrieval of xml documents using relational databases. ACM Trans. Interet. Technol. 1(1), 110–141 (2001)
Xparent: An efficient rdbms-based xml database system. In: ICDE 2002: Proceedings of the 18th International Conference on Data Engineering, p. 335. IEEE Computer Society, Washington, DC, USA (2002)
Jiang, H., Lu, H., Wang, W., Yu, J.X.: Path materialization revisited: an efficient storage model for xml data. In: ADC 2002: Proceedings of the 13th Australasian database conference, pp. 85–94. Australian Computer Society, Inc. (2002)
Kyung-Soo, J.: A design of middleware components for the connection between xml and rdb. In: Proceeding of the IEEE International Symposium on Industrial Electronics, pp. 1753–1756 (2001)
Rys, M.: Microsoft sol server 2000 xml enhancements. Microsoft Support Webcast (April 2000)
HasanZafari, K.M.: EbrahimShiri. Xlight, An Efficient Relational Schema To Store And Query XML Data. In: Proceeding of the IEEE Internationalconference inData Store and Data Engineering, April 22, pp. 254–257 (2010)
Yue, L., Ren, J., Qian, Y.: Storage Method of XML Documents Based-on Pri-order Labling Schema. In: Proceeding of the IEEE International Workshop on Education Technology and Computer Science, December 30, pp. 50–53 (2008)
Sainan, L., Caifeng, L., Liming, G.: Storage Method for XML Document based on Relational Database. In: Proceeding of the IEEE International Symposium on Computer Science and Computational Technology, pp. 127–131 (2009)
Bancihon, F., Barbedette, G., Benzaken, V., et al.: The design and implementation of an object-oriented database system. In: Proceedings of the Second International Workshop on Object-oriented Database (1988)
Shanmugasundaram, J., Tufte, K., et al.: Relational databases for querying XML documents: limitations and opportunities. In: VLDB (1999)
Goldman, R., McHugh, J., Widom, J.: Fromsemi structured data to XML: migrating the lore data model and query language. In: Proceedings of WebDB 1999, pp. 25–30 (1999)
Yoshikawa, M., Amagasa, T., Shimura, T., Uemura, S.: XRel: a path-based approach to storage and retrieval of xmldocuments using relational databases. ACM TOIT 1(1), 110–141 (2001)
Jiang, H., Lu, H., Wang, W., Xu Yu, J.: Path materialization revisited: an efficient storage model for XML data. In: 13th Australasian Database Conference, ADC (2002)
Tian, F., DeWitt, D., Chen, J., Zhang, C.: The design and performance evaluation of alternative XML storage strategies. ACM Sigmod Record (2002)
Florescu, D., Kossman, D.: Storing and querying XML data using an RDBMS. IEEE Data Engineering Bulletin (1999)
Ramanath, M., Freire, J., Haritsa, J., Roy, P.: Searching for efficient XML-to-relational mappings. In: Proceedings of the International XML Database Symposium (2003)
Bohannon, P., Freire, J., Roy, P., Simeon, J.: From XML schema to relations: a cost-based approach to XMLstorage. In: Proceedings of IEEE ICDE (2002)
Tatarinov, I., Viglas, S., Beyer, K., et al.: Storing and querying ordered XML using a relational database system. In: Proceedings of the ACM SIGMOD (2002)
Zhang, C., Naughton, J., Dewitt, D., Luo, Q., Lohmann, G.: On supporting containment queries in relational database systems. In: Proceedings of ACM SIGMOD (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Fakharaldien, M.A.I., Mohamed Zain, J., Sulaiman, N. (2011). XRecursive: AStorage Method for XML Document Based on Relational Database. In: Zain, J.M., Wan Mohd, W.M.b., El-Qawasmeh, E. (eds) Software Engineering and Computer Systems. ICSECS 2011. Communications in Computer and Information Science, vol 180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-22191-0_40
Download citation
DOI: https://doi.org/10.1007/978-3-642-22191-0_40
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-22190-3
Online ISBN: 978-3-642-22191-0
eBook Packages: Computer ScienceComputer Science (R0)