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. Extending database task schedulers for multi-threaded application code
 
conference paper

Extending database task schedulers for multi-threaded application code

Wolf, Florian
•
Psaroudakis, Iraklis  
•
May, Norman
Show more
2015
Proceedings of the 27th International Conference on Scientific and Statistical Database Management
International Conference on Scientific and Statistical Database Management

Modern databases can run application logic defined in stored procedures inside the database server to improve application speed. The SQL standard specifies how to call external stored routines implemented in programming languages, such as C, C++, or JAVA, to complement declarative SQL-based application logic. This is beneficial for scientific and analytical algorithms because they are usually too complex to be implemented entirely in SQL. At the same time, database applications like matrix calculations or data mining algorithms benefit from multi-threading to parallelize compute-intensive operations. Multi-threaded application code, however, introduces a resource competition between the threads of applications and the threads of the database task scheduler. In this paper, we show that multi-threaded application code can render the database's workload scheduling ineffective and decrease the core throughput of the database by up to 50%. We present a general approach to address this issue by integrating shared memory programming solutions into the task schedulers of databases. In particular, we describe the integration of OpenMP into databases. We implement and evaluate our approach using SAP HANA. Our experiments show that our integration does not introduce overhead, and can improve the throughput of core database operations by up to 15%.

  • Details
  • Metrics
Type
conference paper
DOI
10.1145/2791347.2791379
Author(s)
Wolf, Florian
Psaroudakis, Iraklis  
May, Norman
Ailamaki, Anastasia  
Sattler, Kai-Uwe
Date Issued

2015

Publisher

ACM

Publisher place

New York, NY, USA

Published in
Proceedings of the 27th International Conference on Scientific and Statistical Database Management
ISBN of the book

978-1-4503-3709-0

URL

URL

http://dl.acm.org/citation.cfm?id=2791379
Editorial or Peer reviewed

REVIEWED

Written at

OTHER

EPFL units
DIAS  
Event nameEvent placeEvent date
International Conference on Scientific and Statistical Database Management

San Diego, California, USA

June 29 - July 1, 2015

Available on Infoscience
August 19, 2015
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/117142
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