DB2 goes hybrid: integratng native XML and XQuery with relational data and SQL

Authors:
K. Beyer;R. Cochrane;M. Hvizdos;V. Josifovski;J. Kleewein;G. Lapis;G. Lohman;R. Lyle;M. Nicola;F. Özcan;H. Pirahesh;N. Seemann;A. Singh;T. Truong;R. C. Van der Linden;B. Vickery;C. Zhang;G. Zhang
Affiliations:
-;-;-;-;-;-;-;-;-;-;-;-;-;-;-;-;-;-
Venue:
IBM Systems Journal
Year:
2006

Citing 29
Cited 8

Grammar-like functional rules for representing query optimization alternatives

SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
Extensible/rule based query rewrite optimization in Starburst

SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Professional XML

Professional XML
Covering indexes for branching path queries

Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Holistic twig joins: optimal XML pattern matching

Proceedings of the 2002 ACM SIGMOD international conference on Management of data
SilkRoute: A framework for publishing relational data in XML

ACM Transactions on Database Systems (TODS)
Starburst Mid-Flight: As the Dust Clears

IEEE Transactions on Knowledge and Data Engineering
Optimizing Regular Path Expressions Using Graph Schemas

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
Relational Databases for Querying XML Documents: Limitations and Opportunities

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Querying XML Views of Relational Data

Proceedings of the 27th International Conference on Very Large Data Bases
Answering XML Queries on Heterogeneous Data Sources

Proceedings of the 27th International Conference on Very Large Data Bases
TAX: A Tree Algebra for XML

DBPL '01 Revised Papers from the 8th International Workshop on Database Programming Languages
TIMBER: A native XML database

The VLDB Journal — The International Journal on Very Large Data Bases
Anatomy of a native XML base management system

The VLDB Journal — The International Journal on Very Large Data Bases
Algebraic rewritings for optimizing regular path queries

Theoretical Computer Science - Database theory
A comprehensive XQuery to SQL translation using dynamic interval encoding

Proceedings of the 2003 ACM SIGMOD international conference on Management of data
XML parsing: a threat to database performance

CIKM '03 Proceedings of the twelfth international conference on Information and knowledge management
The BEA streaming XQuery processor

The VLDB Journal — The International Journal on Very Large Data Bases
Querying XML streams

The VLDB Journal — The International Journal on Very Large Data Bases
System RX: one part relational, one part XML

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
DB2/XML: designing for evolution

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Towards an enterprise XML architecture

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
XML and relational database management systems: inside Microsoft® SQL Server™ 2005

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Native XML support in DB2 universal database

VLDB '05 Proceedings of the 31st international conference on Very large data bases
XQuery implementation in a relational database system

VLDB '05 Proceedings of the 31st international conference on Very large data bases
Mixed mode XML query processing

VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
From tree patterns to generalized tree patterns: on efficient evaluation of XQuery

VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
A framework for using materialized XPath views in XML query processing

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Indexing XML data stored in a relational database

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

On the path to efficient XML queries

VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Grouping and optimization of XPath expressions in DB2® pureXML

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
An xml index advisor for DB2

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Usage-driven storage structures for native XML databases

IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications
Recommending XMLTable Views for XQuery Workloads

XSym '09 Proceedings of the 6th International XML Database Symposium on Database and XML Technologies
XML: some papers in a haystack

ACM SIGMOD Record
Key concepts for native XML processing

From active data management to event-based systems and more
Recommending XML physical designs for XML databases

The VLDB Journal — The International Journal on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

Comprehensive and efficient support for XML data management is a rapidly increasing requirement for database systems. To address this requirement, DB2 Universal DatabaseTM (UDB) now combines relational data management with native XML support. This makes DB2® a truly hybrid database management system with first-class support for both XML and relational data processing as well as the integration of the two. This paper presents the overall architecture and design aspects of native XML support in DB2 UDB and its integration with the relational data-flow engine. We describe the new XML components in DB2 UDB and show how XML processing leverages much of the infrastructure which is used for relational data.