Abstract
XML processing performance in database systems depends on static optimizations such as XML query rewrites, cost-based optimizations such as choosing appropriate XML indices, and the efficiency of runtime tasks like XML parsing and serialization. This paper discusses some of the runtime performance aspects of XML processing in relational database systems using Microsoft® SQL ServerTM 2005’s approach as an example. It also motivates a non-textual storage as the preferred choice for storing XML natively. A performance evaluation of these techniques shows XML query performance improvements of up to 6 times.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Rys, M.: XQuery in Relational Database Systems. In: XML 2004 Conference (2004)
Pal, S., Cseri, I., Schaller, G., Seeliger, O., Giakoumakis, L., Zolotov, V.: Indexing XML Data Stored in a Relational Database. In: VLDB Conference (2004)
Boag, S., Chamberlin, D. (et al).: XQuery 1.0: An XML Query Language. W3C Working Draft 04 (April 2005), http://www.w3.org/TR/xquery/
Fernández, M., Malhotra, A. (et al).: XQuery 1.0 and XPath 2.0 Data Model. W3C Working Draft 4 (April 2005), http://www.w3.org/TR/xpath-datamodel/
Neil, P.O., Neil, E.O., Pal, S., Cseri, I., Schaller, G., Westbury, N.: ORDPATHs: Insert- Friendly XML Node Labels. In: SIGMOD Conference (2004)
Rahm, E., Böhme, T.: XMach-1: A Multi-User Benchmark for XML Data Management. In: Proc. VLDB workshop Efficiency and Effectiveness of XML Tools, and Techniques (2002)
Pal, S., Fussell, M., Dolobowsky, I.: XML support in Microsoft SQL Server (2005), MSDN Online http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5xml.asp
Schmidt, A.R., Waas, F., Kersten, M.L., Carey, M.J., Manolescu, I., Busse, R.: XMark: A benchmark for xml data management. In: VLDB, pp. 974–985 (2002)
Nicola, M., John, J.: XML Parsing: A Threat to Database Performance. In: CIKM 2003 (2003)
Bayardo, R.J., Josifovski, V., Gruhl, D., Myllymaki, J.: An Evaluation of Binary XML Encoding Optimizations for Fast Stream Based XML Processing. In: WWW 2004 Conference (2004)
Report From the W3C Workshop on Binary Interchange of XML Information Item Sets, http://www.w3.org/2003/08/binary-interchange-workshop/Report
Kanne, C.C., Moerkotte, G.: Efficient Storage of XML Data. In: ICDE 2000 (2000)
Rys, M., Chamberlin, D., Florescu, D., et al.: Tutorial on XML and Relational Database Management Systems: The Inside Story. In: SIGMOD 2005 (2005)
Pal, S., Cseri, I., Seeliger, O., Rys, M., Schaller, G., Kukol, P., Yu, W., Tomic, D., Baras, A., Kowalczyk, C., Berg, B., Churin, D., Kogan, E.: XQuery Implementation in a Relational Database System. In: Proceedings of VLDB 2005 Conference (2005)
Lam, W., Ng, W., Wood, P., Levene, M.: XCQ: Xml Compression and Querying System. In: Proc of WWW 2003 Conference (2003)
Martin, B., Jano, B.: WAP Binary XML Content Format. W3C NOTE (June 24 (1999), http://www.w3.org/TR/wbxml/
Beyer, K., Cochrane, R.J., et al.: System RX: One Part Relational, One Part XML. In: SIGMOD 2005 (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kogan, E., Schaller, G., Rys, M., Huu, H.H., Krishnaswamy, B. (2005). Optimizing Runtime XML Processing in Relational Databases. In: Bressan, S., et al. Database and XML Technologies. XSym 2005. Lecture Notes in Computer Science, vol 3671. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11547273_16
Download citation
DOI: https://doi.org/10.1007/11547273_16
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-28583-0
Online ISBN: 978-3-540-31968-9
eBook Packages: Computer ScienceComputer Science (R0)