Real-Time Temporal Data Warehouse Cubing

Usman Ahmed (1) , Anne Tchounikine (1) , Maryvonne Miquel (1) , Sylvie Servigne (1)

1 BD - Base de Données

Traditional data warehouses are built in an off-line periodic fashion which makes them less valuable in applications where the most up-to-date data is required. For these applications, data should be incorporated in the warehouse and made available as soon as possible in “Real Time Data Warehouse”. In this paper we propose an indexing model named TiC-Tree, in order to simultaneously index and store multidimensional detailed and aggregated data. Our contribution exploits the temporal nature of data and focuses on range and/or group-by queries. We evaluate our proposal with the synthetic data set Star Schema Benchmark and advocate it in comparison with other existing solution.

Mots clés: Data warehouse; OLAP; Real Time data; Graph based index

Domaines: Informatique [cs]

Usman Ahmed, Anne Tchounikine, Maryvonne Miquel, Sylvie Servigne. Real-Time Temporal Data Warehouse Cubing. 21st International Conference on Database and Expert Systems Applications (DEXA 2010), Aug 2010, Bilbao, Spain. pp.159-167, ⟨10.1007/978-3-642-15251-1_12⟩. ⟨hal-01381526⟩