Back to papers
Supporting Table Partitioning By Reference in Oracle
Summary: Introduces partition by reference, letting parent-child tables be equi-partitioned by inheriting the parent key without duplicating columns. Uses an active referential constraint to cascade partition maintenance and atomically migrate child rows on parent key updates, implemented in Oracle 11gR1 for single and composite partitioning.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 4058
- Venue
- SIGMOD
- Year
- 2008
- Pagerank
- 7.7796493e-05
- Overall Rank
- 2,983 | 79.25%
- DOI
-
-
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 11 of 11 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 1,090 |
Low Overhead Concurrency Control for Partitioned Main Memory Databases |
2010 |
SIGMOD |
0.0001415654 |
| 1,819 |
The End of a Myth: Distributed Transactions Can Scale |
2017 |
VLDB |
0.00010429773 |
| 2,337 |
Efficient Processing of Data Warehousing Queries in a Split Execution Environment |
2011 |
SIGMOD |
9.0098186e-05 |
| 3,076 |
Learning a Partitioning Advisor for Cloud Databases |
2020 |
SIGMOD |
7.6107677e-05 |
| 3,779 |
Instance-Optimized Data Layouts for Cloud Analytics Workloads |
2021 |
SIGMOD |
6.7747205e-05 |
| 3,821 |
Locality-aware Partitioning in Parallel Database Systems |
2015 |
SIGMOD |
6.7281515e-05 |
| 5,118 |
AdaptDB: Adaptive Partitioning for Distributed Joins |
2017 |
VLDB |
5.6820984e-05 |
| 6,659 |
Fast and Effective Distribution-Key Recommendation for Amazon Redshift |
2020 |
VLDB |
4.9710856e-05 |
| 7,476 |
Lachesis: Automatic Partitioning for UDF-Centric Analytics |
2021 |
VLDB |
4.7188928e-05 |
| 8,103 |
Grep: A Graph Learning Based Database Partitioning System |
2023 |
SIGMOD |
4.5852201e-05 |
| 9,424 |
Partiqle: An Elastic SQL Engine over Key-Value Stores |
2012 |
SIGMOD |
4.3441378e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 6,540 |
Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities |
2019 |
CIDR |
5.0219214e-05 |
| 2,413 |
Automated Partitioning Design in Parallel Database Systems |
2011 |
SIGMOD |
8.8672223e-05 |
| 2,216 |
On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS |
1998 |
SIGMOD |
9.2699038e-05 |
| 9,008 |
Hybrid Row-Column Partitioning in Teradata |
2016 |
VLDB |
4.4100992e-05 |
| 286 |
Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design |
2004 |
SIGMOD |
0.00028990057 |
| 4,266 |
Parallel SQL Execution in Oracle 10g |
2004 |
SIGMOD |
6.30862e-05 |
| 3,214 |
Query Optimization Techniques for Partitioned Tables |
2011 |
SIGMOD |
7.3661891e-05 |
| 7,058 |
Partitioning A Relational Database Horizontally Using A Knowledge-Based Approach |
1985 |
SIGMOD |
4.8478506e-05 |
| 3,821 |
Locality-aware Partitioning in Parallel Database Systems |
2015 |
SIGMOD |
6.7281515e-05 |
| 7,415 |
Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g |
2008 |
SIGMOD |
4.7355557e-05 |