Index vs. navigation in XPath evaluation

Authors:
Norman May;Matthias Brantner;Alexander Böhm;Carl-Christian Kanne;Guido Moerkotte
Affiliations:
University of Mannheim, Mannheim, Germany;University of Mannheim, Mannheim, Germany;University of Mannheim, Mannheim, Germany;University of Mannheim, Mannheim, Germany;University of Mannheim, Mannheim, Germany
Venue:
XSym'06 Proceedings of the 4th international conference on Database and XML Technologies
Year:
2006

Citing 26
Cited 4

On the propagation of errors in the size of join results

SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Query evaluation techniques for large databases

ACM Computing Surveys (CSUR)
The five-minute rule ten years later, and other computer storage rules of thumb

ACM SIGMOD Record
Storing semistructured data with STORED

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
The design and performance evaluation of alternative XML storage strategies

ACM SIGMOD Record
Labeling dynamic XML trees

Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Accelerating XPath location steps

Proceedings of the 2002 ACM SIGMOD international conference on Management of data
DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Measuring the Complexity of Join Enumeration in Query Optimization

VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
Indexing and Querying XML Data for Regular Path Expressions

Proceedings of the 27th International Conference on Very Large Data Bases
The Complexity of Transformation-Based Join Enumeration

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Optimized Translation of XPath into Algebraic Expressions Parameterized by Programs Containing Navigational Primitives

WISE '02 Proceedings of the 3rd International Conference on Web Information Systems Engineering
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
Structural Joins: A Primitive for Efficient XML Query Pattern Matching

ICDE '02 Proceedings of the 18th International Conference on Data Engineering
ORDPATHs: insert-friendly XML node labels

SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Full-Fledged Algebraic XPath Processing in Natix

ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Concurrency control and recovery for balanced B-link trees

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
XQuery implementation in a relational database system

VLDB '05 Proceedings of the 31st international conference on Very large data bases
A Complete and Efficient Algebraic Compiler for XQuery

ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
XSEED: Accurate and Fast Cardinality Estimation for XPath Queries

ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
XCluster Synopses for Structured XML Content

ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
Efficient structural joins on indexed XML documents

VLDB '02 Proceedings of the 28th 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
Staircase join: teach a relational DBMS to watch its (axis) steps

VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29

A cost-based join selection for XML twig content-based queries

DataX '08 Proceedings of the 2008 EDBT workshop on Database technologies for handling XML information on the web
XPath leashed

ACM Computing Surveys (CSUR)
Key concepts for native XML processing

From active data management to event-based systems and more
XML query processing: efficiency and optimality

Proceedings of the 16th International Database Engineering & Applications Sysmposium

Quantified Score

Hi-index	0.00

Visualization

Abstract

A well-known rule of thumb claims, it is better to scan than to use an index when more than 10% of the data are accessed. This rule was formulated for relational databases. But is it still valid for XML queries? In this paper we develop similar rules of thumb for XML queries by experimentally comparing different execution strategies, e.g. using navigation or indices. These rules can be used immediately for heuristic optimization of XML queries, and in the long run, they may serve as a foundation for cost-based query optimization in XQuery.