Query Performance Optimization in XML Data Warehouses

Hadj Mahboubi (1) , Jérôme Darmont (1)

1 ERIC - Equipe de Recherche en Ingénierie des Connaissances

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.

Domaines: Base de données [cs.DB]

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⟩