Query Performance Optimization in XML Data Warehouses

Abstract : XML data warehouses form an interesting basis for decision-support applications that exploit complex data. However, native-XML database management systems (DBMSs) currently bear limited performances and it is necessary to research for ways to optimize them. In this chapter, we present two such techniques. First, we propose a join index that is specifically adapted to the multidimensional architecture of XML warehouses. It eliminates join operations while preserving the information contained in the original warehouse. Second, we present a strategy for selecting XML materialized views by clustering the query workload. To validate these proposals, we measure the response time of a set of decision-support XQueries over an XML data warehouse, with and without using our optimization techniques. Our experimental results demonstrate their efficiency, even when queries are complex and data are voluminous.
Document type :
Book sections
Complete list of metadatas

Cited literature [37 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-01448189
Contributor : Jérôme Darmont <>
Submitted on : Saturday, January 28, 2017 - 3:02:02 PM
Last modification on : Wednesday, October 31, 2018 - 12:24:08 PM
Long-term archiving on : Saturday, April 29, 2017 - 12:13:09 PM

Files

ChapterMahboubi-Darmont-Final-...
Files produced by the author(s)

Identifiers

Collections

Citation

Hadj Mahboubi, Jérôme Darmont. Query Performance Optimization in XML Data Warehouses. E-Strategies for Resource Management Systems: Planning and Implementation, IGI Global, pp.232-253, 2010, ⟨10.4018/978-1-61692-016-6.ch014⟩. ⟨hal-01448189v2⟩

Share

Metrics

Record views

30

Files downloads

58