A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2009; you can also visit the original URL.
The file type is application/pdf.
Filters
Building and Validating a Reduced TPC-H Benchmark
14th IEEE International Symposium on Modeling, Analysis, and Simulation
Preserved Fulltext
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
2000
SIGMOD record
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2001; you can also visit the original URL.
The file type is application/pdf.
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
2008
2008 14th IEEE International Conference on Parallel and Distributed Systems
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2012; you can also visit the original URL.
The file type is application/pdf.
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]
2015
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
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]
2017
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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]
2017
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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
2021
ARIMA
Les Grandes Étapes vers l'éco-traitement des requêtes - Thinking Smart
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
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
2020
Proceedings of the VLDB Endowment
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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
2006
Very Large Data Bases Conference
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
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
2011
IEEE Data Engineering Bulletin
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
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
2013
International Conference on Management of Data
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
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!
2018
USENIX Symposium on Operating Systems Design and Implementation
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
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
IMPROVING THE AUTOMATIC PRETANSLATOR OF SQL-QUERIES TO A REGULAR PLAN
2021
Vestnik komp iuternykh i informatsionnykh tekhnologii
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
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
2012
Proceedings of the 9th international conference on Autonomic computing - ICAC '12
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2013; you can also visit the original URL.
The file type is application/pdf.
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
2015
Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data - SIGMOD '15
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
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