research-article

Not just correct, but correct and fast: a look at one of Jim Gray's contributions to database system performance

Authors:

David J. DeWitt,

Charles LevineAuthors Info & Claims

ACM SIGMOD Record, Volume 37, Issue 2

Pages 45 - 49

https://doi.org/10.1145/1379387.1379403

Published: 01 June 2008 Publication History

Get Access

Abstract

This paper examines Jim Gray's role in the specification of the debit/credit benchmark. The publication of this benchmark in a 1985 paper launched a benchmark war among the vendors that resulted in dramatic improvements in database system performance in the years following its publication. It was the genesis of the TPC, an industry consortium which has reshaped the benchmark landscape. Descendents of this benchmark continue to this day to be an important metric of modern transaction processing systems.

Supplementary Material

JPG File (eecs_20080531b2.jpg)

Download
10.64 KB

Audio Only (23087.mp3)

Download
39.45 MB

MP4 File (eecs_20080531b2.mp4)

Download
324.85 MB

References

[1]

Many of the papers cited below are posted at http://research.microsoft.com/~gray/JimGrayPublications.htm; they are marked with a (*).

Google Scholar

[2]

"A Measure of Transaction Processing Power," Anon et al., Datamation, April 1, 1985. *

Digital Library

Google Scholar

[3]

"Benchmarking Database Systems: A Systematic Approach," Bitton, D., DeWitt, D. J., and C. Turbyfil, Proceedings of the 1983 Very Large Database Conference, October 1983.

Digital Library

Google Scholar

[4]

"A Measure of Transaction Processing Power," Anon et al., Tandem Technical Report, TR 85.2. *

Crossref

Google Scholar

[5]

"The History of DebitCredit and the TPC," Omni Serlin, The Benchmark Handbook, Chapter 2, 1993. *

Google Scholar

[6]

"History and Overview of the TPC," Shanley, Kim, http://www.tpc.org/information/about/history.asp, February 1998.

Google Scholar

[7]

"DeWitt Clauses: Can We Protect Purchasers Without Hurting Microsoft?" http://www.redorbit.com/news/ technology/520809/dewitt clauses can we protect purchasers without hurting microsoft/index.html

Google Scholar

[8]

"The Evolution of TPC Benchmarks: Why TPC-A and TPC-B Are Obsolete," Charles Levine, Jim Gray, Steve Kiss, and Walt Kohler, San Francisco Systems Center Technical Report 93.1, Digital Equipment Corporation, September 1993. *

Google Scholar

[9]

http://research.microsoft.com/barc/sortbenchmark/

Google Scholar

[10]

"Thousands of DebitCredit Transactions-Per-Second," Jim Gray, and Charles Levine, Microsoft Research Technical Report, MSR-TR-2005-39, April 1, 2005. *

Google Scholar

[11]

"Introduction," Jim Gray, The Benchmark Handbook, Chapter 1, 1993.*

Google Scholar

Cited By

View all

Navin Shrinivas PAyaan MRowjee ACE VGiri A(2024)Techniques Used in Time Series Databases and Their Internals2024 9th International Conference on Big Data Analytics (ICBDA)10.1109/ICBDA61153.2024.10607196(218-226)Online publication date: 16-Mar-2024
https://doi.org/10.1109/ICBDA61153.2024.10607196
Taipalus T(2024)Database management system performance comparisons: A systematic literature reviewJournal of Systems and Software10.1016/j.jss.2023.111872208(111872)Online publication date: Feb-2024
https://doi.org/10.1016/j.jss.2023.111872
Qu LWang QChen TLi KZhang RZhou XXu QYang ZYang CQian WZhou A(2022)Are current benchmarks adequate to evaluate distributed transactional databases?BenchCouncil Transactions on Benchmarks, Standards and Evaluations10.1016/j.tbench.2022.1000312:1(100031)Online publication date: Mar-2022
https://doi.org/10.1016/j.tbench.2022.100031
Show More Cited By

Index Terms

Not just correct, but correct and fast: a look at one of Jim Gray's contributions to database system performance
1. Information systems
  1. Data management systems
    1. Database management system engines
  2. Information retrieval
    1. Evaluation of retrieval results

Recommendations

A correct and useful incremental copying garbage collector
ISMM '07: Proceedings of the 6th international symposium on Memory management

Designing a garbage collector with real-time properties is a particularlydifficult task, involving the construction of both an incremental run-timealgorithm as well as methods enabling a priori reasoning about schedulability in two dimensions (time and ...
Just Curious: An Interview with John Cocke

A legend in computer architecture and perhaps best known as a pioneer of ideas that led to reduced instruction set computing, John Cocke has designed machines that still influence processor design today. In conjunction with his winning the inaugural ...
Do Scopus and WoS correct "old" omitted citations?

Omitted citations--i.e., missing links between a cited paper and the corresponding citing papers--are a consequence of several bibliometric-database errors. To reduce these errors, databases may undertake two actions: (1) improving the control of the (...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 37, Issue 2

Tribute to honor Jim Gray

June 2008

79 pages

ISSN:0163-5808

DOI:10.1145/1379387

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 2008

Published in SIGMOD Volume 37, Issue 2

Check for updates

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

12
Total Citations
View Citations
504
Total Downloads

Downloads (Last 12 months)14
Downloads (Last 6 weeks)3

Reflects downloads up to 22 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Navin Shrinivas PAyaan MRowjee ACE VGiri A(2024)Techniques Used in Time Series Databases and Their Internals2024 9th International Conference on Big Data Analytics (ICBDA)10.1109/ICBDA61153.2024.10607196(218-226)Online publication date: 16-Mar-2024
https://doi.org/10.1109/ICBDA61153.2024.10607196
Taipalus T(2024)Database management system performance comparisons: A systematic literature reviewJournal of Systems and Software10.1016/j.jss.2023.111872208(111872)Online publication date: Feb-2024
https://doi.org/10.1016/j.jss.2023.111872
Qu LWang QChen TLi KZhang RZhou XXu QYang ZYang CQian WZhou A(2022)Are current benchmarks adequate to evaluate distributed transactional databases?BenchCouncil Transactions on Benchmarks, Standards and Evaluations10.1016/j.tbench.2022.1000312:1(100031)Online publication date: Mar-2022
https://doi.org/10.1016/j.tbench.2022.100031
(2022)BibliographyStorage Systems10.1016/B978-0-32-390796-5.00023-1(641-693)Online publication date: 2022
https://doi.org/10.1016/B978-0-32-390796-5.00023-1
Thomasian A(2022)Database parallelism, big data and analytics, deep learningStorage Systems10.1016/B978-0-32-390796-5.00017-6(385-491)Online publication date: 2022
https://doi.org/10.1016/B978-0-32-390796-5.00017-6
Poggi N(2019)MicrobenchmarkEncyclopedia of Big Data Technologies10.1007/978-3-319-77525-8_111(1143-1152)Online publication date: 20-Feb-2019
https://doi.org/10.1007/978-3-319-77525-8_111
Poggi N(2018)MicrobenchmarkEncyclopedia of Big Data Technologies10.1007/978-3-319-63962-8_111-1(1-10)Online publication date: 1-Mar-2018
https://doi.org/10.1007/978-3-319-63962-8_111-1
Bonnet PShasha D(2018)Database BenchmarksEncyclopedia of Database Systems10.1007/978-1-4614-8265-9_80797(936-938)Online publication date: 7-Dec-2018
https://doi.org/10.1007/978-1-4614-8265-9_80797
Hanwahr N(2017)“Mr. Database”„Mr. Database“NTM Zeitschrift für Geschichte der Wissenschaften, Technik und Medizin10.1007/s00048-017-0180-925:4(519-542)Online publication date: 27-Oct-2017
https://doi.org/10.1007/s00048-017-0180-9
Bonnet PShasha D(2017)Database BenchmarksEncyclopedia of Database Systems10.1007/978-1-4899-7993-3_80797-1(1-3)Online publication date: 3-Apr-2017
https://doi.org/10.1007/978-1-4899-7993-3_80797-1
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

A correct and useful incremental copying garbage collector

Just Curious: An Interview with John Cocke

Do Scopus and WoS correct "old" omitted citations?