CineCubes: Aiding data workers gain insights from OLAP queries

In this paper we demonstrate that it is possible to enrich query answering with a short data movie that gives insights to the original results of an OLAP query. Our method, implemented in an actual system, CineCubes, 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. For each of the query results, we execute a set of highlight extraction algorithms that identify interesting patterns and values in the data of the results. 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 movie, which is wrapped as a PowerPoint presentation and returned to the user.

[1]  Nicholas Diakopoulos,et al.  Visualization Rhetoric: Framing Effects in Narrative Visualization , 2011, IEEE Transactions on Visualization and Computer Graphics.

[2]  Pat Hanrahan.  Analytic database technologies for a new kind of user: the data enthusiast , 2012, SIGMOD Conference.

[3]  Daniel A. Keim,et al.  Hierarchy-driven Visual Exploration of Multidimensional Data Cubes , 2007, BTW.

[4]  Carlos Ordonez,et al.  Interactive exploration and visualization of OLAP cubes , 2011, DOLAP '11.

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

[6]  Edward R. Tufte.  Visual explanations: images and quantities, evidence and narrative , 1997 .

[7]  Wo-Shun Luk,et al.  Data visualization on web-based OLAP , 2011, DOLAP '11.

[8]  Pat Helland,et al.  Idempotence is not a medical condition , 2012, Commun. ACM.

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

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

[11]  Alfredo Cuzzocrea,et al.  Hand-OLAP: a system for delivering OLAP services on handheld devices , 2003, The Sixth International Symposium on Autonomous Decentralized Systems, 2003. ISADS 2003..

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

[13]  Alfred Inselberg.  Visualization and knowledge discovery for high dimensional data , 2001, Proceedings Second International Workshop on User Interfaces in Data Intensive Systems. UIDIS 2001.

[14]  Sara Jones,et al.  Narrative Visualization: Sharing Insights into Complex Data , 2012 .

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

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

[17]  Carsten Sapia.  On Modeling and Predicting Query Behavior in OLAP Systems , 1999, DMDW.

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

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

[20]  Ben Shneiderman,et al.  The eyes have it: a task by data type taxonomy for information visualizations , 1996, Proceedings 1996 IEEE Symposium on Visual Languages.

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

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

[23]  Wolf-Tilo Balke,et al.  Datenbanken und Informationssysteme , 2012, 40 Jahre Informatik @ Braunschweig.

[24]  Curtis E. Dyreson,et al.  Building a display of missing information in a data sieve , 2011, DOLAP '11.

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

[26]  D. Ellis.  Visual explanations: Images and quantities , 1997 .

[27]  Svetlana Mansmann,et al.  From Analysis to Interactive Exploration: Building Visual Hierarchies from OLAP Cubes , 2006, EDBT.

[28]  Panos Vassiliadis,et al.  CineCubes: cubes as movie stars with little effort , 2013, DOLAP '13.

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

[30]  Carlos Ordonez,et al.  Evaluating Statistical Tests on OLAP Cubes to Compare Degree of Disease , 2009, IEEE Transactions on Information Technology in Biomedicine.

[31]  Jock D. Mackinlay,et al.  Storytelling: The Next Step for Visualization , 2013, Computer.

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

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

[34]  Alfredo Cuzzocrea,et al.  Enabling OLAP in mobile environments via intelligent data cube compression techniques , 2008, Journal of Intelligent Information Systems.