BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Memento EPFL//
BEGIN:VEVENT
SUMMARY:Design Principles of Hybrid Transactional and Analytical Processin
 g (HTAP) Systems
DTSTART:20190612T140000
DTEND:20190612T160000
DTSTAMP:20260916T032110Z
UID:d0fe61f5135b085527f1b3878a0a29069ece3e0f4f3a46d7416ee5fd
CATEGORIES:Conferences - Seminars
DESCRIPTION:Aunn Raza\nEDIC candidacy exam\nExam president: Prof. Rachid G
 uerraoui\nThesis advisor: Prof. Anastasia Ailamaki\nCo-examiner: Prof. Edo
 uard Bugnion\n\nAbstract\n\nModern applications generate and update large 
 data volumes. To provide meaningful business intelligence\, applications r
 equire timely analytics on fresh operational data. Nevertheless\, recent w
 ork on database management systems has advocated a transition from monolit
 hic engines to separate analytic- and transaction-specialized ones\, to li
 ghten up the critical path using workload knowledge. As a result\, support
 ing hybrid transactional and analytical processing (HTAP) requires an out-
 of-band periodic extract-transform-load (ETL) process to synchronize the t
 wo engines. ETL causes a trade-off between analytical data freshness and p
 erformance\, which becomes more evident as data freshness becomes increasi
 ngly vital.\n \nIn this proposal\, we discuss the design principles of HT
 AP systems and techniques to reduce the ETL cost through three existing wo
 rks. The first work aims to provide analytical data freshness by replacing
  the costly ETL process with lazy snapshotting. The second work aims to pr
 ovide performance isolation between analytical and transactional workloads
  through hardware isolation. The third work exploits heterogeneous hardwar
 e for scaling hybrid workloads on modern hardware. Finally\, we conclude w
 ith our vision for adaptive scheduling of hybrid workloads to dynamically 
 balance between isolation and analytical data freshness.\n\nBackground pap
 ers\nHyPer: A hybrid OLTP&OLAP main memory database system based on virtua
 l memory snapshots\, by A. Kemper\, and T. Neumann. In ICDE\, pages195-2
 06\, 2011.     \nBatchDB: Efficient isolated execution of hybrid OLTP
 + OLAP workloads for interactive applications\,by D. Makreshanski\, J. Gi
 ceva\, C. Barthels\, and G. Alonso.  In SIGMOD\, pages 37-50\, 2017.  
  \nThe case for heterogeneous HTAP\, by R. Appuswamy\, M. Karpathiotaki
 s\, D. Porobic\, and A. Ailamaki. In CIDR\, 2017.\n 
LOCATION:BC 229 https://plan.epfl.ch/?room==BC%20229
STATUS:CONFIRMED
END:VEVENT
END:VCALENDAR
