Performing a join in a partitioned database system

Details Performing a join in a partitioned database system Performing a join in a partitioned database system

2005-09-13

2005-09-13

Corrielus, Jean M. (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

06944633

ABSTRACT:
A method of performing a join includes identifying a join that identifies a first table and a second table. The first table includes a plurality of first table rows. Each of the plurality of first table rows are grouped into one of a plurality of first table partitions. The second table includes one or more second table rows. Each of the plurality of second table rows are grouped into one or more second table partitions. A determination is made as to whether the first table and the second table are joined on equality constraints. The one or more first table rows are joined with the one or more second table rows using a rowkey merge join where equality exists.

REFERENCES:
patent: 5241648 (1993-08-01), Cheng et al.
patent: 5551031 (1996-08-01), M. Cheng et al.
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5983215 (1999-11-01), Ross et al.
patent: 6226639 (2001-05-01), Lindsay et al.
patent: 6253197 (2001-06-01), Lindsay et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6453314 (2002-09-01), Chan et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6665684 (2003-12-01), Zait et al.

Affiliated with

Also associated with

Rating

Performing a join in a partitioned database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Performing a join in a partitioned database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Performing a join in a partitioned database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3413972