Exploiting Advanced Database Optimization Features for Large-Scale SAP R/3 Installations

Summary: Evaluates horizontal partitioning for multi-terabyte SAP R/3 OLTP databases on centralized shared-everything systems. Finds major gains for joins, parallel queries, and administration, with tolerable write overhead—motivating deployment in large production installations. (summarized by gpt-5.6-luna on Jul 21 2026)

Paper ID: he47ad4d27003150c
Venue: VLDB
Year: 2002
Pagerank: 6.994136e-05
Overall Rank: 3,798 | 74.55%
DOI: 10.1016/B978-155860869-6/50088-3

Incoming Non-self Citations Over Time

Authors

1. Bernhard Zeller (University of Passau)
2. Alfons Kemper (University of Passau)

BibTeX Citation

@article{zeller_vldb02,
        title = {{Exploiting Advanced Database Optimization Features for Large-Scale SAP R/3 Installations}},
        author = {Zeller, Bernhard and Kemper, Alfons},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50088-3},
        url = {https://doi.org/10.1016/B978-155860869-6/50088-3},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
196	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025581936
3,156	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.5694347e-05
9,565	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.1460502e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
55	GAMMA - A High Performance Dataflow Database Machine	1986	VLDB	0.00040385073
194	Data Placement In Bubba	1988	SIGMOD	0.00025627096
1,291	Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines	1990	VLDB	0.00011147286
2,823	Horizontal Data Partitioning In Database Design	1982	SIGMOD	7.9522816e-05
5,260	Multi-Disk B-trees	1991	SIGMOD	6.1939544e-05
6,976	A Performance Analysis of the Gamma Database Machine	1988	SIGMOD	5.6140776e-05
8,659	Data Base Design Principles for Striping and Placement of Delay-Sensitive Data on Disks	1998	PODS	5.2784495e-05
8,660	Declustering Databases on Heterogeneous Disk Systems	1995	VLDB	5.2784495e-05
8,661	An Iterative Method for Distributed Database Design	1991	VLDB	5.2784495e-05
13,293	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD	4.9605343e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,585	On the Design and Scalability of Distributed Shared-Data Databases	2015	SIGMOD
2	196	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD
3	5,807	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB
4	4,432	Dynamic and Order Preserving Data Partitioning for Database Machines	1985	VLDB
5	9,306	Asymmetric-Partition Replication for Highly Scalable Distributed Transaction Processing in Practice	2020	VLDB
6	2,823	Horizontal Data Partitioning In Database Design	1982	SIGMOD
7	474	Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems	2012	SIGMOD
8	14,515	SAP R/3: A Database Application System	1998	SIGMOD
9	13,293	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD
10	1,340	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB