Partition join in a partitioned database system

Details Partition join in a partitioned database system Partition join in a partitioned database system

2007-04-10

2007-04-10

Alam, Hosain (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10748563

ABSTRACT:
A method for performing a join of a first table and a second table is disclosed. In one instance, each of the plurality of first table rows is grouped into one of a plurality of first table partitions. It is determined that a partitioning column of the first table is specified in an equality condition of the join. One of the plurality of second table rows is selected, and a partition number is generated for the selected one of the plurality of second table rows. For a second table row for which a partition number was generated, a first table partition with a partition number that matches the generated partition number is identified, and a product join is used to join the one or more first table rows in the matching partition with the selected one of the second table rows.

REFERENCES:
patent: 5983215 (1999-11-01), Ross et al.
patent: 6665684 (2003-12-01), Zait et al.
patent: 6999967 (2006-02-01), Ghazal et al.

Affiliated with

Also associated with

Rating

Partition 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 Partition join in a partitioned database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Partition join in a partitioned database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3732327