Database Performance in the Real World TPC-D and SAP R/3

Jochen Doppelhammer, Thomas Höppler, Alfons Kemper, Donald Kossmann

Research output: Contribution to journalArticlepeer-review

20 Scopus citations

Abstract

Traditionally, database systems have been evaluated in isolation on the basis of standardized benchmarks (e.g., Wisconsin, TPC-C, TPS-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 systems, in which the database system constitutes an integrated component. In order to derive performance evaluations of pratical 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.

Original languageEnglish
Pages (from-to)123-134
Number of pages12
JournalSIGMOD Record (ACM Special Interest Group on Management of Data)
Volume26
Issue number2
DOIs
StatePublished - Jun 1997
Externally publishedYes

Fingerprint

Dive into the research topics of 'Database Performance in the Real World TPC-D and SAP R/3'. Together they form a unique fingerprint.

Cite this