Recommending XMLTable views for XQuery workloads

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Calisto Zuzarte

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Physical structures, for example indexes and materialized views, can improve query execution performance by orders of magnitude. Hence, it is important to choose the right configuration of these physical structures for a given database. In this paper, we discuss the types of materialized views that are suitable for an XML database. We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries. We have implemented our XMLTable View Advisor in a prototype version based on IBM® DB2® V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor's recommendations.

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Pages129-144
Number of pages16
Volume5679 LNCS
DOIs
Publication statusPublished - 6 Nov 2009
Externally publishedYes
Event6th International XML Database Symposium, XSym 2009 - Lyon, France
Duration: 24 Aug 200924 Aug 2009

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume5679 LNCS
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other6th International XML Database Symposium, XSym 2009
CountryFrance
CityLyon
Period24/8/0924/8/09

Fingerprint

XML Database
XQuery
XML
Workload
Query
Recommendations
Choose
Prototype
Configuration
Demonstrate

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Elghandour, I., Aboulnaga, A., Zilio, D. C., & Zuzarte, C. (2009). Recommending XMLTable views for XQuery workloads. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 5679 LNCS, pp. 129-144). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 5679 LNCS). https://doi.org/10.1007/978-3-642-03555-5_11

Recommending XMLTable views for XQuery workloads. / Elghandour, Iman; Aboulnaga, Ashraf; Zilio, Daniel C.; Zuzarte, Calisto.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 5679 LNCS 2009. p. 129-144 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 5679 LNCS).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Elghandour, I, Aboulnaga, A, Zilio, DC & Zuzarte, C 2009, Recommending XMLTable views for XQuery workloads. in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). vol. 5679 LNCS, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 5679 LNCS, pp. 129-144, 6th International XML Database Symposium, XSym 2009, Lyon, France, 24/8/09. https://doi.org/10.1007/978-3-642-03555-5_11
Elghandour I, Aboulnaga A, Zilio DC, Zuzarte C. Recommending XMLTable views for XQuery workloads. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 5679 LNCS. 2009. p. 129-144. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). https://doi.org/10.1007/978-3-642-03555-5_11
Elghandour, Iman ; Aboulnaga, Ashraf ; Zilio, Daniel C. ; Zuzarte, Calisto. / Recommending XMLTable views for XQuery workloads. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 5679 LNCS 2009. pp. 129-144 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{1ec921b1c23f4b42aa1fa5b0ba29e53e,
title = "Recommending XMLTable views for XQuery workloads",
abstract = "Physical structures, for example indexes and materialized views, can improve query execution performance by orders of magnitude. Hence, it is important to choose the right configuration of these physical structures for a given database. In this paper, we discuss the types of materialized views that are suitable for an XML database. We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries. We have implemented our XMLTable View Advisor in a prototype version based on IBM{\circledR} DB2{\circledR} V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor's recommendations.",
author = "Iman Elghandour and Ashraf Aboulnaga and Zilio, {Daniel C.} and Calisto Zuzarte",
year = "2009",
month = "11",
day = "6",
doi = "10.1007/978-3-642-03555-5_11",
language = "English",
isbn = "364203554X",
volume = "5679 LNCS",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
pages = "129--144",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

T1 - Recommending XMLTable views for XQuery workloads

AU - Elghandour, Iman

AU - Aboulnaga, Ashraf

AU - Zilio, Daniel C.

AU - Zuzarte, Calisto

PY - 2009/11/6

Y1 - 2009/11/6

N2 - Physical structures, for example indexes and materialized views, can improve query execution performance by orders of magnitude. Hence, it is important to choose the right configuration of these physical structures for a given database. In this paper, we discuss the types of materialized views that are suitable for an XML database. We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries. We have implemented our XMLTable View Advisor in a prototype version based on IBM® DB2® V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor's recommendations.

AB - Physical structures, for example indexes and materialized views, can improve query execution performance by orders of magnitude. Hence, it is important to choose the right configuration of these physical structures for a given database. In this paper, we discuss the types of materialized views that are suitable for an XML database. We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries. We have implemented our XMLTable View Advisor in a prototype version based on IBM® DB2® V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor's recommendations.

UR - http://www.scopus.com/inward/record.url?scp=70350584948&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=70350584948&partnerID=8YFLogxK

U2 - 10.1007/978-3-642-03555-5_11

DO - 10.1007/978-3-642-03555-5_11

M3 - Conference contribution

SN - 364203554X

SN - 9783642035548

VL - 5679 LNCS

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 129

EP - 144

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

ER -