Real-time temporal data warehouse cubing

  • Authors:
  • Usman Ahmed;Anne Tchounikine;Maryvonne Miquel;Sylvie Servigne

  • Affiliations:
  • Université de Lyon, CNRS, INSA-Lyon, LIRIS, UMR, France;Université de Lyon, CNRS, INSA-Lyon, LIRIS, UMR, France;Université de Lyon, CNRS, INSA-Lyon, LIRIS, UMR, France;Université de Lyon, CNRS, INSA-Lyon, LIRIS, UMR, France

  • Venue:
  • DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.