Describing Analytical Sessions Using a Multidimensional Algebra - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2011

Describing Analytical Sessions Using a Multidimensional Algebra

Résumé

Recent efforts to support analytical tasks over relational sources have pointed out the necessity to come up with flexible, powerful means for analyzing the issued queries and exploit them in decision-oriented processes (such as query recommendation or physical tuning). Issued queries should be decomposed, stored and manipulated in a dedicated subsystem. With this aim, we present a novel approach for representing SQL analytical queries in terms of a multidimensional algebra, which better characterizes the analytical efforts of the user. In this paper we discuss how an SQL query can be formulated as a multidimensional algebraic characterization. Then, we discuss how tonormalize them in order to bridge (i.e., collapse) several SQL queries into a single characterization (representing the analytical session), according to their logical connections.
Fichier non déposé

Dates et versions

hal-01024339 , version 1 (16-07-2014)

Identifiants

  • HAL Id : hal-01024339 , version 1

Citer

Oscar Romero, Patrick Marcel, Alberto Abello, Veronika Peralta, Ladjel Bellatreche. Describing Analytical Sessions Using a Multidimensional Algebra. 13th International Conference on Data Warehousing and Knowledge Discovery, 2011, Toulouse, France. pp.224-239. ⟨hal-01024339⟩
41 Consultations
0 Téléchargements

Partager

Gmail Facebook X LinkedIn More