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.

Matteo Francia, S.R. (2023). Using Regression to Explain Cube Measures. CEUR-WS.

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
Matteo Francia, S.R. (2023). Using Regression to Explain Cube Measures. CEUR-WS.
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