Reference partitioned tables

Details Reference partitioned tables Reference partitioned tables

2011-01-11

2011-01-11

Corrielus, Jean M (Department: 2162)

Data processing: database and file management or data structures

Organization of data

C707S954000

Reexamination Certificate

active

07870174

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.

REFERENCES:
patent: 6092061 (2000-07-01), Choy
patent: 6453314 (2002-09-01), Chan et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 7366716 (2008-04-01), Agrawal et al.
patent: 2006/0253473 (2006-11-01), Agrawal et al.
patent: 2008/0201296 (2008-08-01), Yu et al.

Affiliated with

Also associated with

Rating

Reference partitioned tables does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Reference partitioned tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Reference partitioned tables will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2738226