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. Scaling up Mixed Workloads: a Battle of Data Freshness, Flexibility, and Scheduling
 
conference paper

Scaling up Mixed Workloads: a Battle of Data Freshness, Flexibility, and Scheduling

Psaroudakis, Iraklis  
•
Wolf, Florian
•
May, Norman
Show more
2015
Performance Characterization and Benchmarking. Traditional to Big Data. TPCTC 2014
Sixth TPC Technology Conference on Performance Evaluation & Benchmarking (TPCTC 2014)

The common "one size does not fit all" paradigm isolates transactional and analytical workloads into separate, specialized database systems. Operational data is periodically replicated to a data warehouse for analytics. Competitiveness of enterprises today, however, depends on real-time reporting on operational data, necessitating an integration of transactional and analytical processing in a single database system. The mixed workload should be able to query and modify common data in a shared schema. The database needs to provide performance guarantees for transactional workloads, and, at the same time, efficiently evaluate complex analytical queries. In this paper, we share our analysis of the performance of two main-memory databases that support mixed workloads, SAP HANA and HyPer, while evaluating the mixed workload CH-benCHmark. By examining their similarities and differences, we identify the factors that affect performance while scaling the number of concurrent transactional and analytical clients. The three main factors are (a) data freshness, i.e., how recent is the data processed by analytical queries, (b) flexibility, i.e., restricting transactional features in order to increase optimization choices and enhance performance, and (c) scheduling, i.e., how the mixed workload utilizes resources. Specifically for scheduling, we show that the absence of workload management under cases of high concurrency leads to analytical workloads overwhelming the system and severely hurting the performance of transactional workloads.

  • Files
  • Details
  • Metrics
Type
conference paper
DOI
10.1007/978-3-319-15350-6_7
Web of Science ID

WOS:000355821600007

Author(s)
Psaroudakis, Iraklis  
Wolf, Florian
May, Norman
Neumann, Thomas
Böhm, Alexander
Ailamaki, Anastasia  
Sattler, Kai-Uwe
Date Issued

2015

Publisher

Springer International Publishing AG

Published in
Performance Characterization and Benchmarking. Traditional to Big Data. TPCTC 2014
ISBN of the book

978-3-319-15350-6

978-3-319-15349-0

Series title/Series vol.

Lecture Notes in Computer Science; 8904

Start page

97

End page

112

Subjects

OLAP

•

OLTP

•

CH-benCHmark

•

SAP HANA

•

HyPer

•

data freshness

•

flexibility

•

scheduling

•

workload management

Note

Published by: Springer International Publishing AG. Benchmark source code can be found in the referenced URL.

URL

URL

http://www3.in.tum.de/research/projects/CHbenCHmark/
Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
DIAS  
Event nameEvent placeEvent date
Sixth TPC Technology Conference on Performance Evaluation & Benchmarking (TPCTC 2014)

Hangzhou, China

September 1-5, 2014

Available on Infoscience
September 25, 2014
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/107052
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