Why should query results be treated simply as sets of tuples returned by the DBMS as if they would be visualized in an orange CRT of the 70’s? So far, database systems assume their work is done once results are produced, effectively prohibiting even well-educated end-users to work with them. Can we do something better?

In this line of work, we want to show that it is possible to produce query results that are (a) properly visualized, (b) textually exploitable, i.e., enriched with an automatically extracted text that comments on the result, (c) vocally enriched, i.e., enriched with audio that allows the user not only to see, but also hear. Moreover, we provide an extensible method to accompany a query result with results of complementary queries that allow the qualitative assessment of its information content. Interestingly, a meaningful sequence of related queries that provide context and depth to the original query, “dressed” with the appropriate visualization and sound, ends up to be nothing else but a movie where cubes star.

  • A data movie as a powerpoint results
  • Cinecubes and automated reporting

Texts and Presentations

Alexandre Chanson, Ben Crulis, Nicolas Labroche, Patrick Marcel, Verónika Peralta, Stefano Rizzi, Panos Vassiliadis. The Traveling Analyst Problem: Definition and Preliminary Study . 22nd International Workshop On Data Warehousing and OLAP (DOLAP 2020), Copenhagen, Denmark, March 30, 2020. [Online proceedings at CEUR, pp. 94-98].

Preliminary attempt towards data storytelling under constraints

Dimitrios Gkesoulis, Panos Vassiliadis, Petros Manousis. CineCubes: Aiding data workers gain insights from OLAP queries. Information Systems, Volume 53, October–November 2015, Pages 60 - 86.
See the paper here (PDF) and a detailed presentation here (PDF).

Extends DOLAP'13 with a broad survey of related work, an enlightening user study, and details of the formal background, software architecture and experiments.

Dimitrios Gkesoulis, Panos Vassiliadis. CineCubes: Cubes as Movie Stars with Little Effort. ACM Sixteenth International Workshop On Data Warehousing and OLAP (DOLAP 2013), pp. 3 - 10, 28 October 2013, San Fransisco, USA (colocated with ACM CIKM 2013).
Paper (PDF) and presentation: (PDF) (PPT).

The original Cinecubes paper at DOLAP 2013

Resources

Demo

A on-line demo of CineCubes, set-up over the Adult database, is found in this CineCubes demo site.

Unfortunately, the old CineCubes demo site mentioned in the DOLAP'13 paper (http://snf-56304.vm.okeanos.grnet.gr/), which was also quite fast, is no longer under our control and we cannot guarantee that it will be working properly.

Examples

[2013-08-08]You can find the result of a CineCube query here (21MB pptx file)

Code

The git for the Cinecubes code is found here.