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

Thanopoulou, A; Carreira, P; Galhardas, H

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	https://dspace.lib.ntua.gr/xmlui/handle/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