Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/52867

TitleHTAPBench: Hybrid transactional and analytical processing benchmark
Author(s)Coelho, Fábio
Paulo, João
Vilaça, Ricardo Manuel Pereira
Pereira, José
Oliveira, Rui Carlos Mendes de
KeywordsBenchmarking
HTAP
OLAP
OLTP
Issue date2017
PublisherAssociation for Computing Machinery (ACM)
Abstract(s)The increasing demand for real-time analytics requires the fusion of Transactional (OLTP) and Analytical (OLAP) systems, eschewing ETL processes and introducing a plethora of proposals for the so-called Hybrid Analytical and Trans-actional Processing (HTAP) systems. Unfortunately, current benchmarking approaches are not able to comprehensively produce a unified metric from the assessment of an HTAP system. The evaluation of both engine types is done separately, leading to the use of disjoint sets of benchmarks such as TPC-C or TPC-H. In this paper we propose a new benchmark, HTAPBench, providing a unified metric for HTAP systems geared toward the execution of constantly increasing OLAP requests limited by an admissible impact on OLTP performance. To achieve this, a load balancer within HTAPBench regulates the coexistence of OLTP and OLAP workloads, proposing a method for the generation of both new data and requests, so that OLAP requests over freshly modified data are comparable across runs. We demonstrate the merit of our approach by validating it with different types of systems: OLTP, OLAP and HTAP; showing that the benchmark is able to highlight the differences between them, while producing queries with comparable complexity across experiments with negligible variability.
TypeConference paper
URIhttp://hdl.handle.net/1822/52867
ISBN9781450344043
DOI10.1145/3030207.3030228
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:HASLab - Artigos em atas de conferências internacionais (texto completo)

Files in This Item:
File Description SizeFormat 
p293.pdf
  Restricted access
1,41 MBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID