CineCubes: Aiding data workers gain insights from OLAP queries. (October 2015)

• Record Type: Journal Article
• Authors: Gkesoulis, Dimitrios; Vassiliadis, Panos; Manousis, Petros
• Is Part Of: Information systems. Volume 53(2015)
• Page Start: 60
• Page End: 86
• Publication Date: 2015-10
• Subjects: CineCubes -- Data narration -- Data movies -- Insight generation -- OLAP -- Management of query results -- Query recommendation; Database management -- Periodicals; Electronic data processing -- Periodicals; Bases de données -- Gestion -- Périodiques; Informatique -- Périodiques; Database management; Electronic data processing; Periodicals; 005.7
• DOI: 10.1016/j.is.2014.12.006
• Languages: English
• ISSNs: 0306-4379

Abstract

Abstract: 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.