PhD Seminar • Data Systems • Proteus: Autonomous Adaptive Storage for Mixed Database WorkloadsExport this event to calendar

Wednesday, March 2, 2022 12:00 PM EST

Please note: This PhD seminar will be given online.

Michael Abebe, PhD candidate
David R. Cheriton School of Computer Science

Supervisor: Professor Khuzaima Daudjee

Hybrid transaction/analytical processing (HTAP) workloads contain a mix of transactional (OLTP) and analytical (OLAP) requests. To meet these demands, distributed HTAP systems typically maintain a complete copy of data in row-oriented storage format that is well-suited for OLTP workloads and a second complete copy in column-oriented storage format optimized for OLAP workloads. Maintaining these data copies consumes significant storage space and system resources. Conversely, storing data in a single format results in performance degradation for one aspect of the workload (OLTP or OLAP).

In this talk, I will present Proteus, a distributed HTAP database system that autonomously selects and adapts its storage layout to optimize for any workload. Proteus generates physical execution plans that utilize storage-aware operators for efficient transaction execution. Using comprehensive HTAP workloads and state-of-the-art comparison systems, I will show how Proteus delivers superior HTAP performance while providing OLTP and OLAP performance on par with designs specialized for processing only one of the two workloads.


To join this PhD seminar on Zoom, please go to https://uwaterloo.zoom.us/j/94790063425?pwd=UkhaZlJob2I2RXJZM0VOTFdUSjZ0UT09.

Location 
Online PhD seminar
200 University Avenue West

Waterloo, ON N2L 3G1
Canada
Event tags 

S M T W T F S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
  1. 2024 (100)
    1. April (23)
    2. March (27)
    3. February (25)
    4. January (25)
  2. 2023 (296)
    1. December (20)
    2. November (28)
    3. October (15)
    4. September (25)
    5. August (30)
    6. July (30)
    7. June (22)
    8. May (23)
    9. April (32)
    10. March (31)
    11. February (18)
    12. January (22)
  3. 2022 (245)
  4. 2021 (210)
  5. 2020 (217)
  6. 2019 (255)
  7. 2018 (217)
  8. 2017 (36)
  9. 2016 (21)
  10. 2015 (36)
  11. 2014 (33)
  12. 2013 (23)
  13. 2012 (4)
  14. 2011 (1)
  15. 2010 (1)
  16. 2009 (1)
  17. 2008 (1)