CineCubes: cubes as movie stars with little effort

In this paper we investigate how we can exploit the existence of a star schema in order to answer user OLAP queries with CineCube movies. Our method, implemented in an actual system, includes the following steps. The user submits a query over an underlying star schema. Taking this query as input, the system comes up with a set of queries complementing the information content of the original query, and executes them. Then, the system visualizes the query results and accompanies this presentation with a text commenting on the result highlights. Moreover, via a text-to-speech conversion the system automatically produces audio for the constructed text. Each combination of visualization, text and audio practically constitutes a cube movie, which is wrapped as a PowerPoint presentation and returned to the user.

[1]  Arnaud Giacometti,et al.  Query recommendations for OLAP discovery driven analysis , 2009, DOLAP.

[2]  Matteo Golfarelli,et al.  Similarity measures for OLAP sessions , 2013, Knowledge and Information Systems.

[3]  Neoklis Polyzotis,et al.  The QueRIE system for Personalized Query Recommendations , 2011, IEEE Data Eng. Bull..

[4]  Edward Tufte,et al.  Visual Explanations , 1997 .

[5]  Patrick Marcel,et al.  A survey of query recommendation techniques for data warehouse exploration , 2011, EDA.

[6]  Robert McKee,et al.  Story: Substance, Structure, Style, and the Principles of Screenwriting , 1997 .

[7]  Sunita Sarawagi,et al.  Intelligent Rollups in Multidimensional OLAP Data , 2001, VLDB.

[8]  Torben Bach Pedersen,et al.  Multidimensional Databases and Data Warehousing , 2010, Multidimensional Databases and Data Warehousing.

[9]  Panos Vassiliadis,et al.  A Presentation Model & Non-Traditional Visualization for OLAP , 2005, Int. J. Data Warehous. Min..

[10]  Véronique Cariou,et al.  Built-In Indicators to Discover Interesting Drill Paths in a Cube , 2008, DaWaK.

[11]  Evaggelia Pitoura,et al.  "You May Also Like" Results in Relational Databases , 2009 .

[12]  Panos Vassiliadis,et al.  Modelling and Optimisation Issues for Multidimensional Databases , 2000, CAiSE.

[13]  Arnaud Giacometti,et al.  Query Recommendations for OLAP Discovery-Driven Analysis , 2011, Int. J. Data Warehous. Min..

[14]  Jeffrey Heer,et al.  Narrative Visualization: Telling Stories with Data , 2010, IEEE Transactions on Visualization and Computer Graphics.

[15]  Georgia Koutrika,et al.  Synthesizing structured text from logical database subsets , 2008, EDBT '08.

[16]  Sunita Sarawagi,et al.  User-Adaptive Exploration of Multidimensional Data , 2000, VLDB.

[17]  Sunita Sarawagi,et al.  Explaining Differences in Multidimensional Aggregates , 1999, VLDB.