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: 4120
Venue: SIGMOD
Year: 2008
Pagerank: 8.2764713e-05
Overall Rank: 2,666 | 81.72%
DOI: 10.1145/1376616.1376727

Incoming Non-self Citations Over Time

Authors

1. George Eadon (Oracle)
2. Ananth Raghavan (Oracle)
3. Eugene Inseok Chong (Oracle)
4. Jagannathan Srinivasan (Oracle)
5. Shrikanth Shankar (Oracle)
6. Souripriya Das (Oracle)

BibTeX Citation

@inproceedings{eadon_sigmod08,
        title = {{Supporting Table Partitioning By Reference in Oracle}},
        author = {Eadon, George and Raghavan, Ananth and Chong, Eugene Inseok and Srinivasan, Jagannathan and Shankar, Shrikanth and Das, Souripriya},
        series = {{SIGMOD} '08},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1376616.1376727},
        url = {https://dl.acm.org/doi/10.1145/1376616.1376727},
        year = {2008}
}

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
773	Low Overhead Concurrency Control for Partitioned Main Memory Databases	2010	SIGMOD	0.00014131021
1,345	The End of a Myth: Distributed Transactions Can Scale	2017	VLDB	0.00011090483
2,159	Efficient Processing of Data Warehousing Queries in a Split Execution Environment	2011	SIGMOD	9.061086e-05
2,499	Learning a Partitioning Advisor for Cloud Databases	2020	SIGMOD	8.4993549e-05
3,035	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	7.8297746e-05
3,200	Locality-aware Partitioning in Parallel Database Systems	2015	SIGMOD	7.642132e-05
4,456	AdaptDB: Adaptive Partitioning for Distributed Joins	2017	VLDB	6.692321e-05
6,279	Fast and Effective Distribution-Key Recommendation for Amazon Redshift	2020	VLDB	5.9286872e-05
7,311	Lachesis: Automatic Partitioning for UDF-Centric Analytics	2021	VLDB	5.6491618e-05
8,042	Grep: A Graph Learning Based Database Partitioning System	2023	SIGMOD	5.5015896e-05
9,578	Partiqle: An Elastic SQL Engine over Key-Value Stores	2012	SIGMOD	5.2528121e-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.

Rank	Cited Paper	Year	Venue	Pagerank
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00069513174
199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025612088
366	Scalable Semantic Web Data Management Using Vertical Partitioning	2007	VLDB	0.00020039981
2,797	Vertical Partitioning for Database Design: A Graphical Algorithm	1989	SIGMOD	8.1135051e-05
2,855	Horizontal Data Partitioning In Database Design	1982	SIGMOD	8.0323779e-05
7,464	Partitioning A Relational Database Horizontally Using A Knowledge-Based Approach	1985	SIGMOD	5.6109154e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,161	Data Partitioning for In-Memory Systems: Myths, Challenges, and Opportunities	2019	CIDR
2	1,852	Automated Partitioning Design in Parallel Database Systems	2011	SIGMOD
3	3,036	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD
4	9,159	Hybrid Row-Column Partitioning in Teradata	2016	VLDB
5	199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD
6	4,633	Parallel SQL Execution in Oracle 10g	2004	SIGMOD
7	3,199	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD
8	7,464	Partitioning A Relational Database Horizontally Using A Knowledge-Based Approach	1985	SIGMOD
9	3,200	Locality-aware Partitioning in Parallel Database Systems	2015	SIGMOD
10	7,377	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD