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: 8907
Venue: VLDB
Year: 2002
Pagerank: 7.0201615e-05
Overall Rank: 3,516 | 75.55%
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
286	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00028990057
3,214	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.3661891e-05
9,186	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	4.3791424e-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
20	GAMMA - A High Performance Dataflow Database Machine	1986	VLDB	0.00086459551
197	Data Placement In Bubba	1988	SIGMOD	0.00035201758
1,266	Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines	1990	VLDB	0.00012946573
3,153	Horizontal Data Partitioning In Database Design	1982	SIGMOD	7.4707022e-05
5,098	Multi-Disk B-trees	1991	SIGMOD	5.7007294e-05
6,630	A Performance Analysis of the Gamma Database Machine	1988	SIGMOD	4.9862818e-05
8,057	Data Base Design Principles for Striping and Placement of Delay-Sensitive Data on Disks	1998	PODS	4.5944409e-05
8,058	Declustering Databases on Heterogeneous Disk Systems	1995	VLDB	4.5944409e-05
8,059	An Iterative Method for Distributed Database Design	1991	VLDB	4.5944409e-05
12,762	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,957	On the Design and Scalability of Distributed Shared-Data Databases	2015	SIGMOD	9.9598319e-05
286	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00028990057
6,060	OLTPShare: The Case for Sharing in OLTP Workloads	2018	VLDB	5.2305257e-05
3,903	Dynamic And Order Preserving Data Partitioning For Database Machines	1985	VLDB	6.6432116e-05
9,027	Asymmetric-Partition Replication for Highly Scalable Distributed Transaction Processing in Practice	2020	VLDB	4.4044295e-05
3,153	Horizontal Data Partitioning In Database Design	1982	SIGMOD	7.4707022e-05
679	Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems	2012	SIGMOD	0.00018215154
13,958	SAP R/3: A Database Application System	1998	SIGMOD	-
12,762	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD	4.1945683e-05
1,731	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.0001073454