Skip to Main Content
 

Global Search Box

 
 
 
 

Files

File List


Prasanth_Jayachandran_Thesis_Final.pdf (10.49 MB)

ETD Abstract Container

Abstract Header

A Distributed Interactive Cube Exploration System

Jayachandran, Prasanth
http://rave.ohiolink.edu/etdc/view?acc_num=osu1366369292

Abstract Details

2013, Master of Science, Ohio State University, Computer Science and Engineering.
As the amount of data generated from web, mobile and social media increases rapidly, analytics using OLAP (Online Analytical Processing) data cubes is getting increasingly popular among organizations. In a typical scenario, this analysis is performed using BI tools to quickly get insights from the pre-materialized multi-dimensional aggregated data. We introduce DICE, a distributed interactive system that uses a novel session-oriented model for online data cube exploration, which is designed to provide the user with interactive sub-second latencies for specified accuracy levels. We provide a novel framework that combines three concepts: faceted exploration of data cubes, speculative execution of queries and query execution over sampled data. Our system uses a combination of intuitive frontend for faceted cube exploration and distributed query execution backend that guarantees interactive latencies. We catalog the challenges encountered in building such a system, we discuss design considerations, implementation details and optimizations of our system. Experiments demonstrate that cube exploration using DICE at billion-tuple scale is at least 33% faster than current approaches. As shown in our video demonstration, DICE allows the user to fluidly interact with billion-tuple datasets while maintaining sub-second interactive response times.
Arnab Nandi (Advisor)
Srinivasan Parthasarathy (Committee Member)
105 p.
Computer Engineering; Computer Science
interactive analysis; real-time analysis; data cube; cube exploration

Recommended Citations

Citations

  • Jayachandran, P. (2013). A Distributed Interactive Cube Exploration System [Master's thesis, Ohio State University]. OhioLINK Electronic Theses and Dissertations Center. http://rave.ohiolink.edu/etdc/view?acc_num=osu1366369292

    APA Style (7th edition)

  • Jayachandran, Prasanth. A Distributed Interactive Cube Exploration System. 2013. Ohio State University, Master's thesis. OhioLINK Electronic Theses and Dissertations Center, http://rave.ohiolink.edu/etdc/view?acc_num=osu1366369292.

    MLA Style (8th edition)

  • Jayachandran, Prasanth. "A Distributed Interactive Cube Exploration System." Master's thesis, Ohio State University, 2013. http://rave.ohiolink.edu/etdc/view?acc_num=osu1366369292

    Chicago Manual of Style (17th edition)

osu1366369292
580
© 2013, all rights reserved.
This open access ETD is published by The Ohio State University and OhioLINK.