Benchmarking Summarizability Processing in XML Warehouses with Complex Hierarchies

Chantola Kit (1) , Marouane Hachicha (1) , Jérôme Darmont (1)

1 ERIC - Entrepôts, Représentation et Ingénierie des Connaissances

Business Intelligence plays an important role in decision making. Based on data warehouses and Online Analytical Processing, a business intelligence tool can be used to analyze complex data. Still, summarizability issues in data warehouses cause ineffective analyses that may become critical problems to businesses. To settle this issue, many researchers have studied and proposed various solutions, both in relational and XML data warehouses. However, they find difficulty in evaluating the performance of their proposals since the available benchmarks lack complex hierarchies. In order to contribute to summarizability analysis, this paper proposes an extension to the XML warehouse benchmark (XWeB) with complex hierarchies. The benchmark enables us to generate XML data warehouses with scalable complex hierarchies as well as summarizability processing. We experimentally demonstrated that complex hierarchies can definitely be included into a benchmark dataset, and that our benchmark is able to compare two alternative approaches dealing with summarizability issues.

Mots clés: Benchmark; XML warehouse; OLAP; TPC-H; Complex hierarchies; Summarizability; XWeB

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

Chantola Kit, Marouane Hachicha, Jérôme Darmont. Benchmarking Summarizability Processing in XML Warehouses with Complex Hierarchies. 15th International Workshop on Data Warehousing and OLAP (DOLAP 2012), Sep 2012, Maui, United States. pp.73-80. ⟨hal-00855778⟩