Performance of join operations in parallel database systems

Details Performance of join operations in parallel database systems Performance of join operations in parallel database systems

2006-05-30

2006-05-30

Corrielus, Jean M. (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S707000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07054852

ABSTRACT:
A database system includes a plurality of storage modules, with a first storage module storing rows of a first table and a second storage module storing rows of a second table, and a plurality of access modules adapted to manage access of respective storage modules. A first access module corresponds to the first storage module, and a second access module corresponds to the second storage module. The first access module is adapted to distribute rows of the first table to the second access module in response to a join request, and the first access module is adapted to further distribute row identifiers with the distributed rows. The distributed rows contain one or more columns that are part of one or more join conditions of the join request, but does not contain one or more columns that are in a specified result list of the join request or that are part of a subsequent operation specified in the join request.

REFERENCES:
patent: 5655080 (1997-08-01), Dias et al.
patent: 5666525 (1997-09-01), Ross
patent: 5864842 (1999-01-01), Pederson et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6625593 (2003-09-01), Leung et al.

Affiliated with

Also associated with

Rating

Performance of join operations in parallel database systems does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Performance of join operations in parallel database systems, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Performance of join operations in parallel database systems will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3546501