Optimizing runtime XML processing in relational databases

Authors:
Eugene Kogan;Gideon Schaller;Michael Rys;Hanh Huynh Huu;Babu Krishnaswamy
Affiliations:
Microsoft Corporation, Redmond, WA;Microsoft Corporation, Redmond, WA;Microsoft Corporation, Redmond, WA;Microsoft Corporation, Redmond, WA;Microsoft Corporation, Redmond, WA
Venue:
XSym'05 Proceedings of the Third international conference on Database and XML Technologies
Year:
2005

Citing 8
Cited 1

XML parsing: a threat to database performance

CIKM '03 Proceedings of the twelfth international conference on Information and knowledge management
An evaluation of binary xml encoding optimizations for fast stream based xml processing

Proceedings of the 13th international conference on World Wide Web
ORDPATHs: insert-friendly XML node labels

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
System RX: one part relational, one part XML

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
XML and relational database management systems: the inside story

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
XQuery implementation in a relational database system

VLDB '05 Proceedings of the 31st international conference on Very large data bases
XMark: a benchmark for XML data management

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Indexing XML data stored in a relational database

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Dynamic programming strikes back

Proceedings of the 2008 ACM SIGMOD international conference on Management of data

Quantified Score

Hi-index	0.00

Visualization

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.