2,487 Hits in 5.1 sec

Building and Validating a Reduced TPC-H Benchmark

H. Vandierendonck, P. Trancoso
14th IEEE International Symposium on Modeling, Analysis, and Simulation  
In this paper, we investigate a method to reduce the number of queries in TPC-H, a decision support system benchmark.  ...  However, the benchmarking process is complicated to set-up and use and running the benchmarks takes a substantial amount of time.  ...  Acknowledgements We are grateful to Christodoulos Adamou and the rest of the CASPER group for their help.  ... 
doi:10.1109/mascots.2006.16 dblp:conf/mascots/VandierendonckT06 fatcat:nk44mdwllvatrcfwhuzfqxwl4a

New TPC benchmarks for decision support and web commerce

Meikel Poess, Chris Floyd
2000 SIGMOD record  
The query validation describes how to validate each query against a 1 gigabyte database (qualification database). TPC-H and TPC-R define 22 queries, 16 of which were carried over from TPC-D.  ...  Andrew Eisenberg and Jim Melton The TPC-H and TPC-R Decision Support Benchmarks In April 1999, two new benchmarks, TPC-R and TPC-H, replaced TPC-D as the industry's standard benchmarks for decision support  ... 
doi:10.1145/369275.369291 fatcat:k3dkqhauz5bateretxklxxhgrq

MRBench: A Benchmark for MapReduce Framework

Kiyoung Kim, Kyungho Jeon, Hyuck Han, Shin-gyu Kim, Hyungsoo Jung, Heon Y. Yeom
2008 2008 14th IEEE International Conference on Parallel and Distributed Systems  
To this end, we build MR-Bench to deal with large volumes of relational data and execute highly complex queries.  ...  However, there are only few good benchmarks to evaluate MapReduce implementations by realistic testsets. In this paper, we present MRBench that is a benchmark for evaluating MapReduce systems.  ...  Validation To validate our implementation, we compared our result with TPC-H benchmark results from Postgresql database.  ... 
doi:10.1109/icpads.2008.70 dblp:conf/icpads/KimJHKJY08 fatcat:jbtt63l4brapfmqo4makwoep7i

Benchmarking SQL-on-Hadoop Systems: TPC or Not TPC? [chapter]

Avrilia Floratou, Fatma Özcan, Berni Schiefer
2015 Lecture Notes in Computer Science  
Today, many SQL-on-Hadoop vendors use the data generators and the queries of existing TPC benchmarks, but fail to adhere to the rules, producing results that are not transparent.  ...  The new benchmark evaluation schemes should be inexpensive, effective and open enough to embrace the variety of SQL-on-Hadoop systems and their corresponding vendors.  ...  As opposed to other database benchmarks such as TPC-H, whose results must be validated by a certified TPC auditor, the TPCx-HS benchmark results can also be validated using a peer-review process.  ... 
doi:10.1007/978-3-319-20233-4_7 fatcat:vv7ibqt62zgtpc62ny772oxwba

Data Processing Benchmarks [article]

Jérôme Darmont
2017 arXiv   pre-print
We also address the newer trends in cloud benchmarking. Finally, we discuss the issues, tradeoffs and future trends for data processing benchmarks.  ...  The aim of this article is to present an overview of the major families of state-of-the-art data processing benchmarks, namely transaction processing benchmarks and decision support benchmarks.  ...  TPC-H (TPC, 2013) has long been the only standard decision-support benchmark.  ... 
arXiv:1701.08634v1 fatcat:22lp2aqhubc7bhya5y52oqsoty

Database Benchmarks [article]

Jérôme Darmont
2017 arXiv   pre-print
and decision-support benchmarks, and to discuss the issues, tradeoffs and future trends in database benchmarking.  ...  The aim of this article is to present an overview of the major families of state-of-the-art data-base benchmarks, namely: relational benchmarks, object and object-relational benchmarks, XML benchmarks,  ...  TPC-H (TPC, 2005c) is currently their only decision-support benchmark.  ... 
arXiv:1701.08052v1 fatcat:llrcrysa6rf4hnafyru3oqroem

Big Steps Towards Query Eco-Processing - Thinking Smart
Les Grandes Étapes vers l'éco-traitement des requêtes - Thinking Smart

Simon Pierre Dembele, Ladjel Bellatreche, Carlos Ordonez, Nabil Gmati, Mathieu Roche, Tri Nguyen-Huu, Laurent Debreu
2021 ARIMA  
TPC-H.  ...  Nous effectuons des expériences approfondies basées sur les systèmes PostgreSQL, MonetDB et Hyrise en utilisant un jeu de données généré à partir du benchmarks TPC-H afin de valider nos propositions.  ...  Also, we plan to apply the same approach to other systems and compare them with monetDB, PostgreSQL, and Hyrise systems.  ... 
doi:10.46298/arima.6767 fatcat:v3ivitm74je4tdb27c6y6a3zga

Quantifying TPC-H choke points and their optimizations

Markus Dreseler, Martin Boissier, Tilmann Rabl, Matthias Uflacker
2020 Proceedings of the VLDB Endowment  
TPC-H continues to be the most widely used benchmark for relational OLAP systems.  ...  This paper provides a systematic analysis of choke points and their optimizations. It complements previous work on TPC-H choke points by providing a quantitative discussion of their relevance.  ...  The CH-benCHmark [15] combines the transactional and analytical challenges of TPC-C and TPC-H. Others have worked on reducing the complexity of TPC-H.  ... 
doi:10.14778/3389133.3389138 fatcat:lfjnnobaw5b5tcj5a7o55ytcm4

The Making of TPC-DS

Raghunath Othayoth Nambiar, Meikel Poess
2006 Very Large Data Bases Conference  
For the last decade, the research community and the industry have used TPC-D and its successor TPC-H to evaluate performance of decision support technology.  ...  Recognizing a paradigm shift in the industry the Transaction Processing Performance Council has developed a new Decision Support benchmark, TPC-DS, expected to be released this year.  ...  ACKNOWLEDGEMENT The authors would like to acknowledge Mike Nikolaiev, Ray Glasstone, Umesh Dayal, Ken Jacobs, Tracey Stewart, Christopher Buss and Ivan Mcphee for their comments and feedback and all TPC-DS  ... 
dblp:conf/vldb/OthayothP06 fatcat:26y56idxofdb3bke37ws3fqh4m

Power Based Performance and Capacity Estimation Models for Enterprise Information Systems

Meikel Poess, Raghunath Othayoth Nambiar
2011 IEEE Data Engineering Bulletin  
This paper presents enhancements to previously published energy estimation models based on the TPC-C and TPC-H benchmarks from the same authors and a new model, based on the TPC-E benchmark.  ...  Wide industry adaption of TPC-Energy requires a large body of benchmark publications across multiple software and hardware platforms, which could take several years.  ...  Acknowledgement The authors would like to acknowledge Satinder Sethi and and Ray Glasstone for their invaluable comments and feedback and Heinrich Poess for his infinite support.  ... 
dblp:journals/debu/PoessN11 fatcat:ktjskvoodvertdwywcouksv5ia

Multidimensional Database Design via Schema Transformation: Turning TPC-H into the TPC-H*d Multidimensional Benchmark

Alfredo Cuzzocrea, Rim Moussa
2013 International Conference on Management of Data  
We successfully used the framework to revolve the well known TPC-H benchmark to become a multidimensional benchmark -TPC-H*d benchmark, and translated into MDX language (MultiDimensional eXpressions) the  ...  In order to assess the effectiveness and the efficiency of our proposal, we benchmark the open source Mondrian ROLAP server and its OLAP4j driver with TPC-H*d benchmark.  ...  We succeed in (i) revolving TPC-H benchmark into a multidimensional benchmark TPC-H*d [23] , and (ii) assessing the capacities of the ROLAP server Mondrian [17] with TPC-H*d benchmark.  ... 
dblp:conf/comad/CuzzocreaM13 fatcat:t6uijrlayrdf5ac3m3odcwid4i

Deconstructing RDMA-enabled Distributed Transactions: Hybrid is Better!

Xingda Wei, Zhiyuan Dong, Rong Chen, Haibo Chen
2018 USENIX Symposium on Operating Systems Design and Implementation  
Evaluations using popular OLTP workloads including TPC-C and SmallBank show that DrTM+H achieves over 7.3 and 90.4 million transactions per second on a 16-node RDMA-capable cluster (ConnectX-4) respectively  ...  Based on the above studies, we build DrTM+H, a new hybrid distributed transaction system that always embraces the optimal RDMA primitives at each phase of transactional execution.  ...  TPC-E. is designed to be a more realistic OLTP benchmark, which simulates the workload of a brokerage firm.  ... 
dblp:conf/osdi/WeiD0C18 fatcat:gatcnnb75fe6hpevuep7ruxbbu


I. A. Kazantsev, R. K. Klassen
2021 Vestnik komp iuternykh i informatsionnykh tekhnologii  
We have created an automatic pretranslator prototype and proposing a new approach to improve the automatic pretranslator efficiency by parsing the original SQL (Structured Query Language) query and building  ...  You can additionally improve performance by reducing the amount of data transferred, due to a more accurate selection of the dimensions of DECIMAL fields and lowering the projection operations to the level  ...  Acknowledgments The TPC acknowledges the work and contributions of the TPC-D subcommittee member companies in developing Version 2 of the TPC-D specification which formed the basis for TPC-H Version 1.  ... 
doi:10.14489/vkit.2021.12.pp.003-012 fatcat:iz642bkxpvel7gllog7ilqtupe

Automated profiling and resource management of pig programs for meeting service level objectives

Zhuoyao Zhang, Ludmila Cherkasova, Abhishek Verma, Boon Thau Loo
2012 Proceedings of the 9th international conference on Autonomic computing - ICAC '12  
We validate our approach using a 66-node Hadoop cluster and a diverse set of workloads: PigMix benchmark, TPC-H queries, and customized queries mining a collection of HP Labs' web proxy logs.  ...  of a Pig program as a function of allocated resources; (ii) estimating the amount of resources (a number of map and reduce slots) required for completing a Pig program with a given (soft) deadline.  ...  The accuracy of this model is validated using PigMix benchmark [2] and a combination of TPC-H and web proxy log analysis queries on a 66-node Hadoop cluster.  ... 
doi:10.1145/2371536.2371546 dblp:conf/icac/ZhangCVL12 fatcat:zzmyfvq5h5h6jj6vosiaulxt4i

Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems

Thomas Neumann, Tobias Mühlbauer, Alfons Kemper
2015 Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data - SIGMOD '15  
and fine-grained serializability validation mechanism.  ...  of a committing transaction.  ...  Building the predicate trees takes between 2 µs and 15 µs for the TPC-C transactions on our system; and between 4 µs and 24 µs for the analytical TPC-H queries (9.5 µs geometric mean).  ... 
doi:10.1145/2723372.2749436 dblp:conf/sigmod/0001MK15 fatcat:soyptpo245gfvp4ymqxvjniss4
« Previous Showing results 1 — 15 out of 2,487 results