Document-oriented data warehouses : complex hierarchies and summarizability.

Max Chevalier (1) , Mohammed El Malki (1, 2) , Arlind Kopliku (1) , Olivier Teste (1) , Ronan Tournier (1)

1 IRIT - Institut de recherche en informatique de Toulouse
2 Capgemini (FRANCE)

There is an increasing interest in implementing data warehouses with NoSQL document-oriented systems. In the ideal case, data can be analysed on different dimensions. These dimensions follow strict hierarchies that we can use to roll-up and drill-down on analysis axes. In this paper, we deal with non-strict and non-covering hierarchies, common issues in data warehousing a.k.a. summarizability issues. We show how to model these hierarchies in document-oriented systems and we propose an algorithm that can deal with summarizability issues. The new approach is tested and compared to existing approaches.

Mots clés: Data warehouses; Document-oriented systems; NoSQL; Summarizability

Domaines: Théorie de l'information [cs.IT]; Recherche d'information [cs.IR]

Max Chevalier, Mohammed El Malki, Arlind Kopliku, Olivier Teste, Ronan Tournier. Document-oriented data warehouses : complex hierarchies and summarizability.. International Symposium on Ubiquitous Networking (UNet 2016), May 2016, Casablanca, Morocco. pp.671-683. ⟨hal-03659006⟩