Back to search

University of Waterloo

Improving OLAP Workload Performance in Apache Ignite

Abstract

dc:description.abstract

Apache Ignite is an open-source system that is used to process database workloads. It utilizes Apache Calcite as the underlying query engine to parse SQL queries into relational algebra operators that are passed to the Ignite execution engine. This thesis investigates the performance of online analytical processing (OLAP) workloads with varying memory and data distribution settings using Apache Ignite with Apache Calcite. From empirical studies, practical strategies to decrease response times for OLAP queries are designed and implemented in Apache Ignite. Through studies using the TPC-H benchmark, it is demonstrated that each strategy yields performance improvements across multiple queries, and when all strategies are enabled, average performance improves generally for all queries in the workload.

Degree

thesis:*
Grantor dc:publisher
University of Waterloo
Year dc:date.issued
2024

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Dodds, Mark
Advisor dc:contributor.advisor
  • Daudjee, Khuzaima

Rights

Language dc:language.iso
en

Identifiers

dc:identifier.*
Handle dc:identifier.uri
https://hdl.handle.net/10012/21048

Chain of custody

source
Harvested from
University of Waterloo
Base URL
dspacemainprd01.lib.uwaterloo.ca/server/oai/request
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Dodds, Mark. Improving OLAP Workload Performance in Apache Ignite. University of Waterloo, 2024. https://hdl.handle.net/10012/21048