Benchmarking with TPC-H on off-the-shelf hardware an experiments report

DSpace/Manakin Repository

Show simple item record

dc.contributor.author Thanopoulou, A en
dc.contributor.author Carreira, P en
dc.contributor.author Galhardas, H en
dc.date.accessioned 2014-03-01T02:53:33Z
dc.date.available 2014-03-01T02:53:33Z
dc.date.issued 2012 en
dc.identifier.uri http://hdl.handle.net/123456789/36416
dc.relation.uri http://www.scopus.com/inward/record.url?eid=2-s2.0-84865750278&partnerID=40&md5=bac4c1d4615787fa7e0b1de14ee34689 en
dc.subject Database benchmarking en
dc.subject Database performance tuning en
dc.subject Decision support en
dc.subject.other Benchmark tests en
dc.subject.other Complex queries en
dc.subject.other Data-base servers en
dc.subject.other Database performance en
dc.subject.other Database size en
dc.subject.other Decision supports en
dc.subject.other Large database en
dc.subject.other Medium-sized enterprise en
dc.subject.other Off-the-shelf hardwares en
dc.subject.other Open-source en
dc.subject.other Varying parameters en
dc.subject.other Artificial intelligence en
dc.subject.other Computer hardware en
dc.subject.other Decision support systems en
dc.subject.other Hardware en
dc.subject.other Information systems en
dc.subject.other Query languages en
dc.subject.other Benchmarking en
dc.title Benchmarking with TPC-H on off-the-shelf hardware an experiments report en
heal.type conferenceItem en
heal.publicationDate 2012 en
heal.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. en
heal.journalName ICEIS 2012 - Proceedings of the 14th International Conference on Enterprise Information Systems en
dc.identifier.volume 1 DISI en
dc.identifier.issue AIDSS/- en
dc.identifier.spage 205 en
dc.identifier.epage 208 en

Files in this item

Files Size Format View

There are no files associated with this item.

This item appears in the following Collection(s)

Show simple item record