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 analytical queries with column-stores
 
conference paper

Scaling up analytical queries with column-stores

Alagiannis, Ioannis  
•
Athanassoulis, Manos  
•
Ailamaki, Anastasia  
2013
Proceedings of the 6th International Workshop on Testing Database Systems
6th International Workshop on Testing Database Systems

As data analytics is used by an increasing number of applications, data analytics engines are required to execute workloads with increased concurrency, i.e., an increasing number of clients submitting queries. Data management systems designed for data analytics - a market dominated by column-stores - however, were initially optimized for single query execution, minimizing its response time. Hence, they do not treat concurrency as a first class citizen. In this paper, we experiment with one open-source and two commercial column-stores using the TPC-H and SSB benchmarks in a setup with an increasing number of concurrent clients submitting queries, focusing on whether the tested systems can scale up in a single node instance. The tested systems for in-memory workloads scale up, to some degree; however, when the server is saturated they fail to fully exploit the available parallelism. Further, we highlight the unpredictable response times for high concurrency.

  • Files
  • Details
  • Metrics
Loading...
Thumbnail Image
Name

Paper11-CameraReady.pdf

Type

Publisher's Version

Version

Published version

Access type

openaccess

Size

549.56 KB

Format

Adobe PDF

Checksum (MD5)

b1c3c0ed603a56853384f810ac95aa06

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