University of Twente Student Theses

Login

Improving Query Performance of Holistic Aggregate Queries for Real-Time Data Exploration

Pallett, Dennis (2014) Improving Query Performance of Holistic Aggregate Queries for Real-Time Data Exploration.

[img] PDF
2MB
Abstract:This thesis reports on the research done into improving query performance for holistic aggregate queries for real-time data exploration. There are three types of aggregation functions: distributive, algebraic and holistic. The performance of database queries with the first two types of aggregation functions can be (greatly) improved by employing the distributed nature of such functions. However holistic aggregate functions, such as the median aggregation function, cannot be computed distributively. Therefore a different method is needed to improve query performance of database queries with a holistic function. Existing research in this field is primarily focused on finding approximate solutions to improve query performance however the research described in this thesis focuses on finding an exact solution. As part of the research several new algorithms have been developed which are able to significantly improve the query performance of holistic aggregation queries and completely change the time complexity of such queries. In addition several optimizations have been developed which improve query performance even further. Each of the newly developed algorithms and optimizations have been systematically evaluated on two criteria: query performance and storage cost. Finally a selection framework has been designed that aids in the selection of the best algorithm and optimization for different circumstances.
Item Type:Essay (Master)
Faculty:EEMCS: Electrical Engineering, Mathematics and Computer Science
Subject:54 computer science
Programme:Computer Science MSc (60300)
Link to this item:https://purl.utwente.nl/essays/65229
Export this item as:BibTeX
EndNote
HTML Citation
Reference Manager

 

Repository Staff Only: item control page