Distribution of join operations on a multi-node computer system

Details Distribution of join operations on a multi-node computer system Distribution of join operations on a multi-node computer system

2009-02-10

2011-11-08

Lewis, Cheryl (Department: 2155)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S705000

Reexamination Certificate

active

08055651

ABSTRACT:
A method and apparatus distributes database query joins on a multi-node computing system. In the illustrated examples, a join execution unit utilizes various factors to determine where to best perform the query join. The factors include user controls in a hints record set up by a system user and properties of the system such as database configuration and system resources. The user controls in the hints record include a location flag and a determinicity flag. The properties of the system include the free space on the node and the size join, the data traffic on the networks and the data traffic generated by the join, the time to execute the join and nodes that already have code optimization. The join execution unit also determines whether to use collector nodes to optimize the query join.

REFERENCES:
patent: 5649112 (1997-07-01), Yeager et al.
patent: 5752017 (1998-05-01), Bhargava et al.
patent: 5806059 (1998-09-01), Tsuchida et al.
patent: 6256621 (2001-07-01), Tsuchida et al.
patent: 7941424 (2011-05-01), Xu et al.
patent: 2007/0033159 (2007-02-01), Cherkauer

Affiliated with

Also associated with

Rating

Distribution of join operations on a multi-node computer 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 Distribution of join operations on a multi-node computer system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Distribution of join operations on a multi-node computer system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4264759