article

Free access

Database performance in the real world: TPC-D and SAP R/3

Authors:

Joachen Doppelhammer,

Thomas Höppler,

Alfons Kemper,

Donald KossmannAuthors Info & Claims

ACM SIGMOD Record, Volume 26, Issue 2

Pages 123 - 134

https://doi.org/10.1145/253262.253280

Published: 01 June 1997 Publication History

PDF eReader

Abstract

Traditionally, database systems have been evaluated in isolation on the basis of standardized benchmarks (e.g., Wisconsin, TPC-C, TPC-D). We argue that very often such a performance analysis does not reflect the actual use of the DBMSs in the “real world.” End users typically don't access a stand-alone database system; rather they use a comprehensive application system, in which the database system constitutes an integrated component. In order to derive performance evaluations of practical relevance to the end users, the application system including the database system has to be benchmarked. In this paper, we present TPC-D benchmark results carried out using the SAP R/3 system, an integrated business administration system. Like many other application systems SAP R/3 is based on a commercial relational database system. We compare the SAP R/3 benchmark results with TPC-D results of an isolated database system, the database product that served as SAP R/3's back-end.

References

[1]

D. Bitton, D. DeWitt, and C. Turbyfii1. Benchmarking database systems: A systematic approach. In Proc. of the Conf. on Very Large Data Bases (VLDB), 1983.]]

Digital Library

Google Scholar

[2]

R. Buck-Emden and J. Galimow. Die Client~Server-Technologie des SAP-Systems R/3. Addison-Wesley, Reading, MA, USA, 3. edition, 1996.]]

Digital Library

Google Scholar

[3]

G. Colliat. OLAP, relational, and multidimensional database systems. ACM SIGMOD Record, 25(3):64---69, Sep 1996.]]

Digital Library

Google Scholar

[4]

J. Doppelhammer, T. Htippler, A. Kemper, and D. Kossmann. Database performance of SAP System R/3. http://www.db.fmi.unipassau.de/projects/SAP.]]

Google Scholar

[5]

P. Fernandez and D. Schneider. The ins and outs (and everything in between) of data warehousing. Tutorial handouts for the SIGMOD Conference, 1996.]]

Digital Library

Google Scholar

[6]

J. Gray, A. Bosworth, A. Layman, and H. Pirahesh. Data cube: A relational aggregation operator generalizing group-by, cross-tab, and subtotal. In Proc. IEEE Conf. on Data Engineering, pages 152-159, 1996.]]

Digital Library

Google Scholar

[7]

J. Gray. The Benchmark Handbook for Database and Transaction Processing Systems. Morgan- Kaufmann Publishers, San Mateo, CA, USA, 2. edition, 1993.]]

Digital Library

Google Scholar

[8]

B. Lober and U. Marquard. Standard Application Benchmarks. SAP AG, 69185 Walldorf, Germany, Dec 1995.]]

Google Scholar

[9]

B. Matzke. ABAP/4- Die Programmiersprache des SAP-Systems R/3. Addison-Wesley, Reading, MA, USA, 1996.]]

Google Scholar

[10]

SAP AG. R/3 system overview. http://www.sap.com/r3/r3_over.htm.]]

Google Scholar

[11]

Transaction Processing Performance Council TPC. TPC benchmark D (decision support). Standard Specification 1.0, May 1995.]]

Google Scholar

[12]

L. Will, C. Hienger, E Str~enburg, and R. Himmer. R/3-Administration. Addison-Wesley, Reading, MA, USA, 1996.]]

Digital Library

Google Scholar

Cited By

View all

Samaraweera GChang J(2020)Security and Privacy Implications on Database Systems in Big Data Era: A SurveyIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2019.292979433:1(239-258)Online publication date: 7-Dec-2020
https://dl.acm.org/doi/10.1109/TKDE.2019.2929794
Zeller BKemper A(2004)Benchmarking SAP R/3 archiving scenariosProceedings. 20th International Conference on Data Engineering10.1109/ICDE.2004.1320046(782-785)Online publication date: 2004
https://doi.org/10.1109/ICDE.2004.1320046
Muller EDadam PEnderle JFeltes M(2001)Tuning an SQL-based PDM system in a worldwide client/server environmentProceedings 17th International Conference on Data Engineering10.1109/ICDE.2001.914818(99-108)Online publication date: 2001
https://doi.org/10.1109/ICDE.2001.914818
Show More Cited By

Index Terms

Database performance in the real world: TPC-D and SAP R/3
1. General and reference
  1. Cross-computing tools and techniques
    1. Metrics
2. Information systems
  1. Data management systems
    1. Database design and models

Recommendations

Database performance in the real world: TPC-D and SAP R/3
SIGMOD '97: Proceedings of the 1997 ACM SIGMOD international conference on Management of data

Traditionally, database systems have been evaluated in isolation on the basis of standardized benchmarks (e.g., Wisconsin, TPC-C, TPC-D). We argue that very often such a performance analysis does not reflect the actual use of the DBMSs in the “real ...
Panel: Database system performance management
In the past few years we have seen in the literature a number of proposals for benchmarks to be used in measuring the performance of database management and transaction processing systems. The TP1 benchmark [Anon et al 1985] and the Wisconsin benchmark [...
Panel: Database system performance management
SIGMOD '86: Proceedings of the 1986 ACM SIGMOD international conference on Management of data
In the past few years we have seen in the literature a number of proposals for benchmarks to be used in measuring the performance of database management and transaction processing systems. The TP1 benchmark [Anon et al 1985] and the Wisconsin benchmark [...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 26, Issue 2

June 1997

583 pages

ISSN:0163-5808

DOI:10.1145/253262

Chairman:
Sudha Ram
Univ. of Arizona, Tucson
,
Editor:
Joan M. Peckham
Univ. of Rhode Island, Kingston

Issue’s Table of Contents

SIGMOD '97: Proceedings of the 1997 ACM SIGMOD international conference on Management of data
June 1997
594 pages
ISBN:0897919114
DOI:10.1145/253260
Editors:
Joan M. Peckman
Univ. of Rhode Island, Kingston
,
Sudha Ram
Univ. of Arizona, Tucson
,
Michael Franklin

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1997

Published in SIGMOD Volume 26, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

17
Total Citations
View Citations
1,378
Total Downloads

Downloads (Last 12 months)126
Downloads (Last 6 weeks)32

Reflects downloads up to 24 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Samaraweera GChang J(2020)Security and Privacy Implications on Database Systems in Big Data Era: A SurveyIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2019.292979433:1(239-258)Online publication date: 7-Dec-2020
https://dl.acm.org/doi/10.1109/TKDE.2019.2929794
Zeller BKemper A(2004)Benchmarking SAP R/3 archiving scenariosProceedings. 20th International Conference on Data Engineering10.1109/ICDE.2004.1320046(782-785)Online publication date: 2004
https://doi.org/10.1109/ICDE.2004.1320046
Muller EDadam PEnderle JFeltes M(2001)Tuning an SQL-based PDM system in a worldwide client/server environmentProceedings 17th International Conference on Data Engineering10.1109/ICDE.2001.914818(99-108)Online publication date: 2001
https://doi.org/10.1109/ICDE.2001.914818
Mahmood KRisch TZhu MDesai BToyama M(2015)Utilizing a NoSQL Data Store for Scalable Log AnalysisProceedings of the 19th International Database Engineering & Applications Symposium10.1145/2790755.2790772(49-55)Online publication date: 13-Jul-2015
https://dl.acm.org/doi/10.1145/2790755.2790772
Mahmood KTruong TRisch T(2015)NoSQL Approach to Large Scale Analysis of Persisted StreamsData Science10.1007/978-3-319-20424-6_15(152-156)Online publication date: 11-Jun-2015
https://doi.org/10.1007/978-3-319-20424-6_15
Nazemi ETarokh MDjavanshir G(2012)ERP: a literature surveyThe International Journal of Advanced Manufacturing Technology10.1007/s00170-011-3756-x61:9-12(999-1018)Online publication date: 25-Feb-2012
https://doi.org/10.1007/s00170-011-3756-x
Bögelsack AHomann MWittges HKrcmar HLèbre AGopalan K(2011)Performance of SAP ERP with memory virtualization using IBM active memory expansion as an exampleProceedings of the 5th international workshop on Virtualization technologies in distributed computing10.1145/1996121.1996128(21-28)Online publication date: 8-Jun-2011
https://dl.acm.org/doi/10.1145/1996121.1996128
Kemper ANeumann T(2011)HyPerProceedings of the 2011 IEEE 27th International Conference on Data Engineering10.1109/ICDE.2011.5767867(195-206)Online publication date: 11-Apr-2011
https://dl.acm.org/doi/10.1109/ICDE.2011.5767867
Funke FKemper AKrompass SKuno HNambiar RNeumann TNica APoess MSeibold M(2011)Metrics for measuring the performance of the mixed workload CH-benCHmarkProceedings of the Third TPC Technology conference on Topics in Performance Evaluation, Measurement and Characterization10.1007/978-3-642-32627-1_2(10-30)Online publication date: 29-Aug-2011
https://dl.acm.org/doi/10.1007/978-3-642-32627-1_2
Florescu DKossmann D(2009)Rethinking cost and performance of database systemsACM SIGMOD Record10.1145/1558334.155833938:1(43-48)Online publication date: 24-Jun-2009
https://dl.acm.org/doi/10.1145/1558334.1558339
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

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

Abstract

References

Cited By

Index Terms

Recommendations