Patent · US Active

Reference partitioned tables

US7870174B2 · kind B2 · utility

14Cited by

5References

36Claims

0Family size

Assignee

Oracle International Corporation · US

Inventors

George Eadon · Hollis, US
Eugene Inseok Chong · Concord, US
Shrikanth Shankar · Mountain View, US
Ananth Raghavan · San Francisco, US
Jagannathan Srinivasan · Nashua, US
Souripriya Das · Nashua, US

Key dates

Filing date	Oct 11, 2007
Grant date	Jan 11, 2011
Priority date	—
Expiry date	Oct 20, 2028

Classification

Technology area (CPC Y)Emerging Cross-Sectional Technologies
CPC primaryY10S707/954
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Systems, methodologies, media, and other embodiments associated with supporting reference partitioned tables in a relational database are described. One example method includes identifying a partitioning strategy (e.g., range, list, hash) associated with a parent table that is related to a child table by a referential constraint. The example method may also include creating the child table to be a reference-partitioned table partitioned according to the partitioning strategy associated with the parent table. The example method may also include creating the child table to be equi-partitioned with respect to the parent table. The child table is not to replicate a partition key of the parent table but rather is to inherit a partitioning key associated with the parent table through a foreign key relationship.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.