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: 9098
Venue: VLDB
Year: 2002
Pagerank: 7.1388374e-05
Overall Rank: 3,772 | 74.13%
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
199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025612088
3,199	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.6423984e-05
9,350	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.2841297e-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
52	GAMMA - A High Performance Dataflow Database Machine	1986	VLDB	0.00041107291
188	Data Placement In Bubba	1988	SIGMOD	0.00026126036
1,271	Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines	1990	VLDB	0.0001138443
2,855	Horizontal Data Partitioning In Database Design	1982	SIGMOD	8.0323779e-05
5,120	Multi-Disk B-trees	1991	SIGMOD	6.3577476e-05
6,823	A Performance Analysis of the Gamma Database Machine	1988	SIGMOD	5.7627061e-05
8,471	Data Base Design Principles for Striping and Placement of Delay-Sensitive Data on Disks	1998	PODS	5.4181286e-05
8,472	Declustering Databases on Heterogeneous Disk Systems	1995	VLDB	5.4181286e-05
8,473	An Iterative Method for Distributed Database Design	1991	VLDB	5.4181286e-05
12,956	Database Performance in the Real World — TPC-D and SAP R/3 —	1997	SIGMOD	5.093636e-05

Semantically Similar Papers

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