On supporting containment queries in relational database management systems

DMCA

On supporting containment queries in relational database management systems (2001)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Chun Zhang , Jeffrey Naughton , David Dewitt , Qiong Luo

Citations:

271 - 6 self

BibTeX

@INPROCEEDINGS{Zhang01onsupporting,
    author = {Chun Zhang and Jeffrey Naughton and David Dewitt and Qiong Luo},
    title = {On supporting containment queries in relational database management systems},
    booktitle = {},
    year = {2001},
    pages = {425--436}
}

OpenURL

Abstract

Virtually all proposals for querying XML include a class of query we term “containment queries”. It is also clear that in the foreseeable future, a substantial amount of XML data will be stored in relational database systems. This raises the question of how to support these containment queries. The inverted list technology that underlies much of Information Retrieval is well-suited to these queries, but should we implement this technology (a) in a separate loosely-coupled IR engine, or (b) using the native tables and query execution machinery of the RDBMS? With option (b), more than twenty years of work on RDBMS query optimization, query execution, scalability, and concurrency control and recovery immediately extend to the queries and structures that implement these new operations. But all this will be irrelevant if the performance of option (b) lags that of (a) by too much. In this paper, we explore some performance implications of both options using native implementations in two commercial relational database systems and in a special purpose inverted list engine. Our performance study shows that while RDBMSs are generally poorly suited for such queries, under certain conditions they can outperform an inverted list engine. Our analysis further identifies two significant causes that differentiate the performance of the IR and RDBMS implementations: the join algorithms employed and the hardware cache utilization. Our results suggest that contrary to most expectations, with some modifications, a native implementation in an RDBMS can support this class of query much more efficiently.

Keyphrases

containment query relational database management system native implementation hardware cache utilization foreseeable future xml data separate loosely-coupled ir engine information retrieval certain condition inverted list engine analysis identifies query execution commercial relational database system performance study inverted list technology substantial amount query execution machinery performance implication native table term containment query significant cause relational database system special purpose inverted list engine rdbms query optimization rdbms implementation new operation concurrency control

DMCA