Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. Adaptive HTAP through Elastic Resource Scheduling
 
conference paper

Adaptive HTAP through Elastic Resource Scheduling

Raza, Aunn  
•
Chrysogelos, Periklis  
•
Anadiotis, Angelos Christos  
Show more
January 1, 2020
Sigmod'20: Proceedings Of The 2020 Acm Sigmod International Conference On Management Of Data
ACM SIGMOD International Conference on Management of Data (SIGMOD)

Modern Hybrid Transactional/Analytical Processing (HTAP) systems use an integrated data processing engine that performs analytics on fresh data, which are ingested from a transactional engine. HTAP systems typically consider data freshness at design time, and are optimized for a fixed range of freshness requirements, addressed at a performance cost for either OLTP or OLAP. The data freshness and the performance requirements of both engines, however, may vary with the workload. We approach HTAP as a scheduling problem, addressed at runtime through elastic resource management. We model an HTAP system as a set of three individual engines: an OLTP, an OLAP and a Resource and Data Exchange (RDE) engine. We devise a scheduling algorithm which traverses the HTAP design spectrum through elastic resource management, to meet the workload data freshness requirements. We propose an in-memory system design which is non-intrusive to the current state-of-art OLTP and OLAP engines, and we use it to evaluate the performance of our approach. Our evaluation shows that the performance benefit of our system for OLAP queries increases over time, reaching up to 50% compared to static schedules for 100 query sequences, while maintaining a small, and controlled, drop in the OLTP throughput.

  • Details
  • Metrics
Type
conference paper
DOI
10.1145/3318464.3389783
Web of Science ID

WOS:000644433700135

Author(s)
Raza, Aunn  
Chrysogelos, Periklis  
Anadiotis, Angelos Christos  
Ailamaki, Anastasia  
Date Issued

2020-01-01

Publisher

ASSOC COMPUTING MACHINERY

Publisher place

New York

Published in
Sigmod'20: Proceedings Of The 2020 Acm Sigmod International Conference On Management Of Data
ISBN of the book

978-1-4503-6735-6

Start page

2043

End page

2054

Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
DIAS  
Event nameEvent placeEvent date
ACM SIGMOD International Conference on Management of Data (SIGMOD)

ELECTR NETWORK

Jun 14-19, 2020

Available on Infoscience
June 5, 2021
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/178545
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés