Method and system for database load balancing

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

364DIG1, 3642821, G06F 1730

Patent

active

056258119

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: 3702006 (1972-10-01), Page
patent: 4633387 (1986-12-01), Hartung et al.
patent: 4769772 (1988-09-01), Dwyer
patent: 4819159 (1989-04-01), Shipley et al.
patent: 4843541 (1989-06-01), Bean et al.
patent: 4853843 (1989-08-01), Ecklund
patent: 4925311 (1990-05-01), Neches et al.
D.M. Dias, B.R. Iyer and P.S. Yu, "Hybrid Data Sharing -Function Shipping Architecture for Multi-Systems and Control"; IBM Technical Disclosure Bulletin; vol. 30, No. 10; Mar. 1988, pp. 453-454.
Y.H. Lee and P.S. Yu, "FMRT: An Efficient Transaction Routing and Load Sharing Algorithm"; IBM Technical Disclosure Bulletin; vol. 33, No. 10B; Mar. 1991, pp. 355-360.
M. Auslander, A. Chang, S. Morgan, S. Moore, J.C. O'Quin and J.T. O'Quin, "Mirroring of Data in a Partition Basis", Reproduced from Research Disclosure, Jul. 1990, No. 315; .RTM. Kenneth Mason Publications Ltd., England.
D.W. Cornell, D.M. Dias and P.s. Yu, "On Multisystem Coupling Through Function Request Shipping," IEEE Transactions on Software Engineering, vol. SE-12, No. 10, Oct. 1986, pp. 1006-1017.
P.S. Yu, D. Cornell, D.M. Dias and A. Thomasian, "Performance Comparison of IO Shipping and Database Call Shipping: Schemes in Multisystem Partitioned Databases," North-Holland Performance Evaluation 10 (1989), pp. 15-33.
J.L. Wolf, D.M. Dias, B.R. Iyer, and P.S. Yu, "Multisystem Coupling by a Combination of Data Sharing and Data Partitioning," IEEE Transactions on Engineering, vol. 15, No. 7, Jul. 1989, pp. 854-860.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

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

     

Profile ID: LFUS-PAI-O-714502

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.