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. To Share or Not To Share?
 
conference paper

To Share or Not To Share?

Johnson, Ryan
•
Hardavellas, Nikos
•
Pandis, Ippokratis
Show more
2007
Proceedings of the International Conference on Very Large Data Bases
33rd International Conference on Very Large Data Bases

Intuitively, aggressive work sharing among concurrent queries in a database system should always improve performance by eliminating redundant computation or data accesses. We show that, contrary to common intuition, this is not always the case in practice, especially in the highly parallel world of chip multiprocessors. As the number of cores in the system increases, a trade-off appears between exploiting work sharing opportunities and the available parallelism. To resolve the trade-off, we develop an analytical approach that predicts the effect of work sharing in multi-core systems. Database systems can use the model to determine, statically or at runtime, whether work sharing is beneficial and apply it only when appropriate. The contributions of this paper are as follows. First, we introduce and analyze the effects of the trade-off between work sharing and parallelism on database systems running complex decision-support queries. Second, we propose an intuitive and simple model that can evaluate the trade-off using real-world measurement approximations of the query execution processes. Furthermore, we integrate the model into a prototype database execution engine, and demonstrate that selective work sharing according to the model outperforms never-share static schemes by 20% on average and always-share ones by 2.5x.

  • Files
  • Details
  • Metrics
Type
conference paper
Author(s)
Johnson, Ryan
Hardavellas, Nikos
Pandis, Ippokratis
Mancheril, Naju
Harizopoulos, Stavros
Sabirli, Kivanc
Ailamaki, Anastassia  
Falsafi, Babak  
Date Issued

2007

Published in
Proceedings of the International Conference on Very Large Data Bases
Start page

351

End page

362

Note

SYSTEMS PUBLICATION_SHORE_MT

Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
DIAS  
PARSA  
Event nameEvent placeEvent date
33rd International Conference on Very Large Data Bases

Vienna, Austria

September

Available on Infoscience
January 23, 2009
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/34314
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