Title
Cost-based optimization in DB2 XML
Abstract
DB2 XML is a hybrid database system that combines the relational capabilities of DB2 Universal Database™ (UDB) with comprehensive native XML support. DB2 XML augments DB2® UDB with a native XML store, XML indexes, and query processing capabilities for both XQuery and SQL/XML that are integrated with those of SQL. This paper presents the extensions made to the DB2 UDB compiler, and especially its cost-based query optimizer, to support XQuery and SQL/XML queries, using much of the same infrastructure developed for relational data queried by SQL. It describes the challenges to the relational infrastructure that supporting XQuery and SQL/XML poses and provides the rationale for the extensions that were made to the three main parts of the optimizer: the plan operators, the cardinality and cost model, and statistics collection.
Year
DOI
Venue
2006
10.1147/sj.452.0299
IBM Systems Journal
Keywords
Field
DocType
db2 xml augments db2,relational data,xml query,db2 universal databasetm,db2 udb compiler,db2 xml,xml index,relational capability,native xml store,cost-based optimization,comprehensive native xml support
Efficient XML Interchange,XML Encryption,Streaming XML,XML validation,Computer science,XML database,XML schema,XML Schema Editor,Database,XQuery
Journal
Volume
Issue
ISSN
45
2
0018-8670
Citations 
PageRank 
References 
25
1.07
33
Authors
8
Name
Order
Citations
PageRank
A. Balmin1341.62
T. Eliaz2251.07
J. Hornibrook3251.07
L. Lim4251.07
Guy M. Lohman52846965.94
D. Simmen6251.07
M. Wang7252.09
Zhang Chao88724.26