Filters








16 Hits in 1.2 sec

A Practitioner's Introduction to Database Performance Benchmarks and Measurements

S. W. Dietrich, M. Brown, E. Cortes-Rello, S. Wunderlin
1992 Computer journal  
Thanks are also due to Forouzan Golshani, Aime Bayle and the performance Group at Bull Worldwide Information Systems in Phoenix for feedback on earlier versions of this paper.  ...  Acknowledgements The authors would like to thank the anonymous referee for thoughtful comments that improved the paper.  ...  In TPC-A, the history file may be horizontally partitioned, whereas DebitCredit required a unified history file. The DebitCredit benchmark also required storage for the history file for 90 days.  ... 
doi:10.1093/comjnl/35.4.322 fatcat:66moka6hsjhspdpqton2ndhm74

From TPC-C to Big Data Benchmarks: A Functional Workload Model [chapter]

Yanpei Chen, Francois Raab, Randy Katz
2014 Lecture Notes in Computer Science  
In particular, this model describes several components of the targeted workloads: the functional goals that the system must achieve, the representative data access patterns, the scheduling and load variations  ...  Big data systems help organizations store, manipulate, and derive value from vast amounts of data. Relational database and MapReduce are two, arguably competing implementations of such systems.  ...  In November of 1989, the TPC published its standardized end-to-end version of DebitCredit under the name TPC Benchmark A (TPC-A) [11] .  ... 
doi:10.1007/978-3-642-53974-9_4 fatcat:edf2ntdkdnfopckwlvcfg4pyqy

Not just correct, but correct and fast

David J. DeWitt, Charles Levine
2008 SIGMOD record  
It was the genesis of the TPC, an industry consortium which has reshaped the benchmark landscape.  ...  This paper examines Jim Gray's role in the specification of the debit/credit benchmark.  ...  Both TPC-A and TPC-B are direct descendents of Jim's debit/credit benchmark. TPC-A and B brought to an end the wild west of debit/credit benchmarking claims.  ... 
doi:10.1145/1379387.1379403 fatcat:3ggae3vkx5b5tpq6vedharqy6u

From A to E

Pınar Tözün, Ippokratis Pandis, Cansu Kaynak, Djordje Jevdjic, Anastasia Ailamaki
2013 Proceedings of the 16th International Conference on Extending Database Technology - EDBT '13  
benchmarks of TPC: TPC-B and TPC-C.  ...  These factors slow down the adoption of TPC-E. In turn, there is little knowledge in the community about how TPC-E behaves micro-architecturally and within the database engine.  ...  Acknowledgments We would like to thank all the members of the DIAS and PARSA laboratories at EPFL, Islam Atta, and Duygu Ceylan for their support and feedback throughout this work.  ... 
doi:10.1145/2452376.2452380 dblp:conf/edbt/TozunPKJA13 fatcat:eozhhscc6jfkfdpaqrnrngpaue

A detailed comparison of two transaction processing workloads

Stets, Gharachorloo, Barroso
2002 2002 IEEE International Workshop on Workload Characterization  
This paper presents a detailed comparison of the debit-credit (modeled after TPC-B) and order-entry (modeled after TPC-C) transaction processing workloads in the context of various architectural choices  ...  These studies have typically used a workload based on either the TPC-B or the TPC-C benchmark, with many of them opting for the simpler TPC-B benchmark.  ...  Next came the DebitCredit benchmark, which was a first attempt to measure not just server performance but also that of the network and clients.  ... 
doi:10.1109/wwc.2002.1226492 fatcat:b23waf7eivdgvaf2uxyhcpgylm

Performance characterization of a Quad Pentium Pro SMP using OLTP workloads

Kimberly Keeton, David A. Patterson, Yong Qiang He, Roger C. Raphael, Walter E. Baker
1998 SIGARCH Computer Architecture News  
We examine the effectiveness of out-of-order execution, branch prediction, speculative execution, superscalar issue and retire, caching and multiprocessor scaling.  ...  The potential impact of these differences is that computers optimized for technical workloads may not provide good performance for commercial applications, and these applications may not fully exploit  ...  Acknowledgments We thank Seckin Unlu of Intel for his help in deciphering the Pentium Pro hardware counters and interpreting experimental results.  ... 
doi:10.1145/279361.279364 fatcat:krdbxhrf5jfvzhi6akmvpxca4q

Analysis of the generalized clock buffer replacement scheme for database transaction processing

Victor F. Nicola, Asit Dan, Daniel M. Dias
1992 Performance Evaluation Review  
To show the usefulness of the model we apply it to a Transaction Processing Council benchmark A (TPC-A) like workload.  ...  The CLOCK algorithm is a popular buffer replacement algorithm becauseof its simplicity and its ability to approximate the performance of the Least Recently Used (LRU) replacement policy.  ...  TPC-A is a database benchmark workload for a debitcredit banking application. The database consists of three types of data; namely, BRANCH, TELLER, and ACCOUNT.  ... 
doi:10.1145/149439.133084 fatcat:x5rzfzdvpjfgzk57sv4liq3qre

Analysis of the generalized clock buffer replacement scheme for database transaction processing

Victor F. Nicola, Asit Dan, Daniel M. Dias
1992 Proceedings of the 1992 ACM SIGMETRICS joint international conference on Measurement and modeling of computer systems - SIGMETRICS '92/PERFORMANCE '92  
To show the usefulness of the model we apply it to a Transaction Processing Council benchmark A (TPC-A) like workload.  ...  The CLOCK algorithm is a popular buffer replacement algorithm becauseof its simplicity and its ability to approximate the performance of the Least Recently Used (LRU) replacement policy.  ...  TPC-A is a database benchmark workload for a debitcredit banking application. The database consists of three types of data; namely, BRANCH, TELLER, and ACCOUNT.  ... 
doi:10.1145/133057.133084 dblp:conf/sigmetrics/NicolaDD92 fatcat:y7wpradp4zgjvkus65pcnl6v4e

Using benchmarking to advance research: a challenge to software engineering

S.E. Sim, S. Easterbrook, R.C. Holt
2003 25th International Conference on Software Engineering, 2003. Proceedings.  
The creation and widespread use of a benchmark within a research area is frequently accompanied by rapid technical progress and community building.  ...  Benchmarks have been used in computer science to compare the performance of computer systems, information retrieval algorithms, databases, and many other technologies.  ...  Lethbridge, Andrew Malton, Sergei Marchenko, Volker Riediger, and Andrew Trevors used CppETS and participated in the workshops.  ... 
doi:10.1109/icse.2003.1201189 dblp:conf/icse/SimEH03 fatcat:zbzp5psmijendoslffciumk6ta

Reminiscences in influential papers

Richard Snodgrass
1998 SIGMOD record  
Past columns have including compelling stories of the impact of particular papers on the mind set and discoveries of a few well-known and respected people in the database community.  ...  This column celebrates the process of scienti c inquiry by examining, in an anecdotal and yes, highly personal fashion, how ideas spread and evolve.  ...  The papers mentioned here span the entire history of databases, from work in the late 50's to a reappearance of the AlphaSort paper.  ... 
doi:10.1145/273244.390004 fatcat:bgxmfgnnozblje7ykayh4dzxtu

Design Trade-offs for a Robust Dynamic Hybrid Hash Join (Extended Version) [article]

Shiva Jahangiri, Michael J. Carey, Johann-Christoph Freytag
2021 arXiv   pre-print
We explore the impact of the number of partitions on the performance of HHJ and propose a lower bound and a default value for the number of partitions.  ...  The design of HHJ depends on many details to perform well. This paper is an experimental and analytical study of the trade-offs in designing a robust and dynamic HHJ operator.  ...  Carey, Miron Livny, and Amit Shukla. 1997. Seeking [49] Omri Serlin. 1993. The History of DebitCredit and the TPC. In The Benchmark the Truth About ad hoc Join Costs.  ... 
arXiv:2112.02480v1 fatcat:edxylscxrzgwlbxcmy3ku33s7m

Inside "Big Data management"

Vinayak Borkar, Michael J. Carey, Chen Li
2012 Proceedings of the 15th International Conference on Extending Database Technology - EDBT '12  
In this paper we review the history of systems for managing "Big Data" as well as today's activities and architectures from the (perhaps biased) perspective of three "database guys" who have been watching  ...  Also covered is the approach we are taking in the ASTERIX project at UC Irvine, where we are developing our own set of answers to the questions of the "right" components and the "right" set of layers for  ...  for their collaborative support and for their provision of access to one of their research clusters.  ... 
doi:10.1145/2247596.2247598 dblp:conf/edbt/BorkarCL12 fatcat:3vkbs5k5kzfwlbvykahgcec44q

Performance characterization of a quad Pentium Pro SMP using OLTP workloads

K. Keeton, D.A. Patterson, Yong Qian He, R.C. Raphael, W.E. Baker
Proceedings. 25th Annual International Symposium on Computer Architecture (Cat. No.98CB36235)  
We examine the effectiveness of out-of-order execution, branch prediction, speculative execution, superscalar issue and retire, caching and multiprocessor scaling.  ...  The potential impact of these differences is that computers optimized for technical workloads may not provide good performance for commercial applications, and these applications may not fully exploit  ...  Acknowledgments We thank Seckin Unlu of Intel for his help in deciphering the Pentium Pro hardware counters and interpreting experimental results.  ... 
doi:10.1109/isca.1998.694759 dblp:conf/isca/KeetonPHRB98 fatcat:pudlxup65bf4nlgiw4aaxrn5lq

Transactions Chasing Scalability and Instruction Locality on Multicores

Pinar Tözün
2014
Like TPC-A, the TPC-B database contains four tables: Branch, Teller, Account, and History.  ...  e.g., the inserts to the History table in TPC-B.  ...  Our prototype implementation of ADDICT reduces L1 instruction misses by 85% and the long latency data misses by 20% compared to the conventional way of scheduling transactions.  ... 
doi:10.5075/epfl-thesis-6411 fatcat:6nr2j3f7jvdv7gwoaexy67xsda

Evaluation of closely coupled systems for high performance database processing

E. Rahm
[1993] Proceedings. The 13th International Conference on Distributed Computing Systems  
The performance of such an architecture is evaluated and compared with loosely coupled database sharing systems employing the primary copy approach for concurrency and coherency control.  ...  In particular, we study the impact of different update strategies (FORCE vs. NOFORCE) and workload allocation schemes (random vs. affinity-based routing).  ...  Debit-credit currently represents the most important workload type for evaluating the performance of transaction and database systems since it is the base for the widely used TPC-A and TPC-B benchmarks  ... 
doi:10.1109/icdcs.1993.287696 dblp:conf/icdcs/Rahm93 fatcat:555itoxknrcrdezewapsvzedhi
« Previous Showing results 1 — 15 out of 16 results