The Intentional Analytics Model (IAM) has been devised to couple OLAP and analytics by (i) letting users express their analysis intentions on multidimensional data cubes and (ii) returning enhanced cubes, i.e., multidimensional data annotated with knowledge insights in the form of models (e.g., correlations). Five intention operators were proposed to this end; of these, \sf{describe} and \sf{assess} have been investigated in previous papers. In this work we enrich the IAM picture by focusing on the \sf{explain} operator, whose goal is to provide an answer to the user asking ``why does measure $m$ show these values?''. Specifically, we propose a syntax for the operator and discuss how enhanced cubes are built by (i) finding the polynomials that best approximate the relationship between $m$ and the other cube measures, and (ii) highlighting the most interesting one. Finally, we test the operator implementation in terms of efficiency.

Using Regression to Explain Cube Measures / Matteo Francia, Stefano Rizzi, Patrick Marcel. - ELETTRONICO. - (2023), pp. 555-564. (Intervento presentato al convegno 31st Italian Symposium on Advanced Database Systems (SEBD 23) tenutosi a Galzignano Terme, Italy nel July 2-5, 2023).

Using Regression to Explain Cube Measures

Matteo Francia;Stefano Rizzi;
2023

Abstract

The Intentional Analytics Model (IAM) has been devised to couple OLAP and analytics by (i) letting users express their analysis intentions on multidimensional data cubes and (ii) returning enhanced cubes, i.e., multidimensional data annotated with knowledge insights in the form of models (e.g., correlations). Five intention operators were proposed to this end; of these, \sf{describe} and \sf{assess} have been investigated in previous papers. In this work we enrich the IAM picture by focusing on the \sf{explain} operator, whose goal is to provide an answer to the user asking ``why does measure $m$ show these values?''. Specifically, we propose a syntax for the operator and discuss how enhanced cubes are built by (i) finding the polynomials that best approximate the relationship between $m$ and the other cube measures, and (ii) highlighting the most interesting one. Finally, we test the operator implementation in terms of efficiency.
2023
Proceedings 31st Italian Symposium on Advanced Database Systems
555
564
Using Regression to Explain Cube Measures / Matteo Francia, Stefano Rizzi, Patrick Marcel. - ELETTRONICO. - (2023), pp. 555-564. (Intervento presentato al convegno 31st Italian Symposium on Advanced Database Systems (SEBD 23) tenutosi a Galzignano Terme, Italy nel July 2-5, 2023).
Matteo Francia, Stefano Rizzi, Patrick Marcel
File in questo prodotto:
File Dimensione Formato  
explain.pdf

accesso aperto

Tipo: Versione (PDF) editoriale
Licenza: Licenza per Accesso Aperto. Creative Commons Attribuzione (CCBY)
Dimensione 743.79 kB
Formato Adobe PDF
743.79 kB Adobe PDF Visualizza/Apri

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11585/945836
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 0
  • ???jsp.display-item.citation.isi??? ND
social impact