Textual aggregation approaches in OLAP context: A survey

Mustapha Bouakkaz (1) , Youcef Ouinten (1) , Sabine Loudcher (2) , Yulia Strekalova (3)

1 Université Amar Telidji - Laghouat
2 ERIC - Entrepôts, Représentation et Ingénierie des Connaissances
3 UF - University of Florida [Gainesville]

In the last decade, OnLine Analytical Processing (OLAP) has taken an increasingly important role as a research field. Solutions, techniques and tools have been provided for both databases and data warehouses to focus mainly on numerical data. however these solutions are not suitable for textual data. Therefore recently, there has been a huge need for new tools and approaches that treat and manipulate textual data and aggregate it as well. Textual aggregation techniques emerge as a key tool to perform textual data analysis in OLAP for decision support systems. This paper aims at providing a structured and comprehensive overview of the literature in the field of OLAP Textual Aggregation. We provide a new classification framework in which the existing textual aggregation approaches are grouped into two main classes, namely approaches based on cube structure and approaches based on text mining. We discuss and synthesize also the potential of textual similarity metrics, and we provide a recent classification of them.

Mots clés: Aggregation; Data warehouse; OLAP; Textual data; Data mining

Domaines: Méthodes et statistiques

Mustapha Bouakkaz, Youcef Ouinten, Sabine Loudcher, Yulia Strekalova. Textual aggregation approaches in OLAP context: A survey. International Journal of Information Management, 2017, 37 (6), pp.684-69. ⟨10.1016/j.ijinfomgt.2017.06.005⟩. ⟨halshs-01577038⟩