loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Anna Thanopoulou 1 ; Paulo Carreira 2 and Helena Galhardas 2

Affiliations: 1 National Technical University of Athens, Greece ; 2 Technical University of Lisbon and INESC-ID, Portugal

Keyword(s): Database Benchmarking, Database Performance Tuning, Decision Support.

Related Ontology Subjects/Areas/Topics: Data Engineering ; Databases and Data Security ; Databases and Information Systems Integration ; Enterprise Information Systems ; Large Scale Databases ; Query Languages and Query Processing

Abstract: Most medium-sized enterprises run their databases on inexpensive off-the-shelf hardware; still, they need quick answers to complex queries, like ad-hoc Decision Support System (DSS) ones. Thus, it is important that the chosen database system and its tuning be optimal for the specific database size and design. Such choice can be made in-house, based on tests with academic database benchmarks. This paper focuses on the TPC-H database benchmark that aims at measuring the performance of ad-hoc DSS queries. Since official TPC-H results feature large databases and run on high-end hardware, we attempt to assess whether the test is meaningfully downscalable and can be performed on off-the-shelf hardware. We present the benchmark and the steps that a non-expert must take to run the tests. In addition, we report our own benchmark tests, comparing an open-source and a commercial database server running on off-the-shelf hardware when varying parameters that affect the performance of DSS queries.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 52.90.40.84

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Thanopoulou, A.; Carreira, P. and Galhardas, H. (2012). Benchmarking with TPC-H on Off-the-Shelf Hardware - An Experiments Report. In Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 2: ICEIS; ISBN 978-989-8565-10-5; ISSN 2184-4992, SciTePress, pages 205-208. DOI: 10.5220/0004004402050208

@conference{iceis12,
author={Anna Thanopoulou. and Paulo Carreira. and Helena Galhardas.},
title={Benchmarking with TPC-H on Off-the-Shelf Hardware - An Experiments Report},
booktitle={Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 2: ICEIS},
year={2012},
pages={205-208},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004004402050208},
isbn={978-989-8565-10-5},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 2: ICEIS
TI - Benchmarking with TPC-H on Off-the-Shelf Hardware - An Experiments Report
SN - 978-989-8565-10-5
IS - 2184-4992
AU - Thanopoulou, A.
AU - Carreira, P.
AU - Galhardas, H.
PY - 2012
SP - 205
EP - 208
DO - 10.5220/0004004402050208
PB - SciTePress