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

Summary: Horizontal partitioning of SAP R/3's centralized, shared-everything DB is evaluated, showing gains for joins and parallel workloads; DML overhead remains modest. Results drive partitioned layouts in large ERP systems and lead to SAP partner adoption. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8908
Venue: VLDB
Year: 2002
Pagerank: 7.018169e-05
Overall Rank: 3,518 | 75.56%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Bernhard Zeller
2. Alfons Kemper

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
283	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00029024583
3,219	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.3592303e-05
9,190	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	4.3749452e-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
21	GAMMA - A High Performance Dataflow Database Machine	1986	VLDB	0.00086104592
197	Data Placement In Bubba	1988	SIGMOD	0.0003508637
1,264	Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines	1990	VLDB	0.00012939192
3,160	Horizontal Data Partitioning In Database Design	1982	SIGMOD	7.4649653e-05
5,217	Multi-Disk B-trees	1991	SIGMOD	5.621547e-05
6,629	A Performance Analysis of the Gamma Database Machine	1988	SIGMOD	4.9817911e-05
8,059	Data Base Design Principles for Striping and Placement of Delay-Sensitive Data on Disks	1998	PODS	4.5902983e-05
8,060	Declustering Databases on Heterogeneous Disk Systems	1995	VLDB	4.5902983e-05
8,061	An Iterative Method for Distributed Database Design	1991	VLDB	4.5902983e-05
12,771	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD	4.1905499e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,956	On the Design and Scalability of Distributed Shared-Data Databases	2015	SIGMOD	9.9626473e-05
283	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00029024583
6,062	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	5.2267464e-05
3,908	Dynamic And Order Preserving Data Partitioning For Database Machines	1985	VLDB	6.6380291e-05
9,029	Asymmetric-Partition Replication for Highly Scalable Distributed Transaction Processing in Practice	2020	VLDB	4.4003748e-05
3,160	Horizontal Data Partitioning In Database Design	1982	SIGMOD	7.4649653e-05
679	Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems	2012	SIGMOD	0.00018211621
13,972	SAP R/3: A Database Application System	1998	SIGMOD	-
12,771	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD	4.1905499e-05
1,726	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00010734339