The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 11, 2011
Filed:
Oct. 11, 2007
George Eadon, Nashua, NH (US);
Eugene Inseok Chong, Concord, MA (US);
Shrikanth Shankar, Los Altos, CA (US);
Ananth Raghavan, San Francisco, CA (US);
Jagannathan Srinivasan, Nashua, NH (US);
Souripriya Das, Nashua, NH (US);
George Eadon, Nashua, NH (US);
Eugene Inseok Chong, Concord, MA (US);
Shrikanth Shankar, Los Altos, CA (US);
Ananth Raghavan, San Francisco, CA (US);
Jagannathan Srinivasan, Nashua, NH (US);
Souripriya Das, Nashua, NH (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.