A Tale of Two Approaches: Query Performance Study of XML Storage Strategies in Relational Databases [chapter]

Sandeep Prakash, Sourav S. Bhowmick
2006 Lecture Notes in Computer Science  
Several recent papers have investigated a relational approach to store XML data and there is a growing evidence that schema-conscious approaches are a better option than schema-oblivious techniques as far as query performance is concerned. This paper studies three strategies for storing XML document including one representing schema-conscious approach (Shared-Inlining ) and two representing schema-oblivious approach (XParent and Sucxent++). We implement and evaluate each approach using
more » ... non-recursive XQueries. Our analysis shows an interesting fact that schemaconscious approaches are not always a better option than schema-oblivious approaches! In fact, it is possible for a schema-oblivious approach (Sucxent++) to be faster than a schema-conscious approach (Shared-Inlining ) for 55% of the benchmark queries (the highest observed factor being 87.8 times). Sucx-ent++ also outperforms XParent by up to 1700 times.
doi:10.1007/11827405_15 fatcat:3qwt2dvqkbe2zeepivk7gscwf4