Method and system for database load balancing

A method for balancing a processing load in a data processing system having a first physical processing node and a second physical processing node, said first physical processing node having a first data partition stored thereon and said second physical processing node having a second data partition stored thereon, said method comprising the steps of:

• assigning a first logical processing node to said first data partition, said first logical processing node performing one or more database requests using said first data partition;
• and
• reassigning to said first data partition a second logical processing node, said first logical processing node and said second logical processing node being different processing nodes, said second logical processing node performing one or more subsequent database requests using said first data partition.

A system for partitioning a database in a data processing system, said system comprising:

• means for dividing the database into a plurality of data partitions, each of said plurality of data partitions having a physical owner associated therewith;
• and
• means for assigning to each of said plurality of data partitions a logical owner different from said physical owner, wherein said logical owner provides access to its corresponding data partition.

A system for balancing a processing load in a data processing system having a first physical processing node and a second physical processing node, said first physical processing node having a first data partition stored thereon and said second physical processing node having a second data partition stored thereon, said system comprising:

• means for assigning a first logical processing node to said first data partition, said first logical processing node performing one or more database requests using said first data partition;
• and
• means for reassigning to said first data partition a second logical processing node, said first logical processing node and said second logical processing node being different processing nodes, said second logical processing node performing one or more subsequent database requests using said first data partition.