Method and system for database load balancing

Details Method and system for database load balancing Method and system for database load balancing

1996-08-07

1997-10-07

Amsbury, Wayne

395608, 395610, G06F 1730

Patent

active

056757913

ABSTRACT:
A method and system are provided for partitioning a database and for balancing the processing load among processing nodes in a data processing system. A database partition is stored at each node and a logical owner node is assigned to each partition. The logical owner becomes responsible for all database requests related to the corresponding partition. Techniques for optimally assigning logical owners to all partitions in a system are provided and are responsive to parameters such as the load at each node, the combined load of the system, and the total number of assignments allowed. Techniques are also provided to accomplish the transfer of partition ownership between processing nodes when multiple transactions related to the partition are simultaneously occurring.

REFERENCES:
patent: 4920487 (1990-04-01), Baffles
patent: 5089956 (1992-02-01), MacPhail
patent: 5131087 (1992-07-01), Warr
patent: 5269013 (1993-12-01), Abramson et al.
patent: 5317728 (1994-05-01), Tevis et al.
patent: 5333315 (1994-07-01), Saether et al.
patent: 5355475 (1994-10-01), Tanaka et al.
patent: 5423018 (1995-06-01), Dang et al.
patent: 5440727 (1995-08-01), Bhide et al.
patent: 5440737 (1995-08-01), Uchinuma
patent: 5457793 (1995-10-01), Elko et al.
patent: 5485610 (1996-01-01), Gioielli et al.
patent: 5499354 (1996-03-01), Aschoff et al.
patent: 5506986 (1996-04-01), Healy
patent: 5551020 (1996-08-01), Flax et al.
Sacca et al, "Database Partitioning in a Cluster of Processors", ACM Transactions on Database Systems, vol. 10, No. 1, Mar. 1985, pp. 29-56.

Affiliated with

Also associated with

Rating

Method and system for database load balancing does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for database load balancing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for database load balancing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2365497