Method for automated scaling of a massive parallel processing (MPP) database

An apparatus comprising:

• a processor;
• and
• a computer readable storage medium storing programming for execution by the processor, the programming including instructions to:
• determine that a criteria for rebalancing an existing partition of a massively parallel processing (MPP) database has been satisfied;
• re-allocate a set of entries from the existing partition to a new partition;
• update a catalog to associate the set of entries with both the existing partition and the new partition, wherein updating the catalog causes queries for the set of entries received during a migration period to be directed toward the existing partition and the new partition;
• migrate the set of entries from the existing partition to a new partition;
• and
• re-update the catalog to associate the set of entries with the new partition after migrating the set of entries from the existing partition to a new partition.

A method of managing a massively parallel processing (MPP) database, the method comprising:

• determining that a criteria for repartitioning an existing database partition (DBpartition) of the MPP database has been satisfied, wherein the existing DBpartition comprises a first partition of a first table (t1-p1) and a first partition of a second table (t2-p1);
• re-allocating a first set of entries in the t1-p1 and a second set of entries in the t2-p1 to a new DBpartition;
• and
• updating a catalog to associate the first set of entries and the second set of entries with both the existing DBpartition and the new DBpartition, wherein updating the catalog causes queries for the re-allocated entries received during a migration period to be directed toward both the existing DBpartition and the new DBpartition;
• migrating the first set of entries and the second set of entries from the existing DBpartition to the new DBpartition;
• and
• re-updating the catalog to associate the first set of entries and the second set of entries with the new DBpartition after migrating the set of entries from the existing DBpartition to the new DBpartition.

An apparatus comprising:

• a processor;
• and
• a computer readable storage medium storing programming for execution by the processor, the programming including instructions to:
• determine that a criteria for repartitioning an existing database partition (DBpartition) of a massively parallel processing (MPP) database has been satisfied, wherein the existing DBpartition comprises a first partition of a first table (t1-p1) and a first partition of a second table (t2-p1);
• re-allocate a first set of entries in the t1-p1 and a second set of entries in the t2-p1 to a new DBpartition;
• and
• update a catalog to associate the first set of entries and the second set of entries with both the existing DBpartition and the new DBpartition such that queries for the first set of entries or the second set of entries received during a migration period are directed toward both the existing DBpartition and the new DBpartition;
• migrate the first set of entries and the second set of entries from the existing DBpartition to the new DBpartition;
• and
• re-update the catalog to associate the first set of entries and the second set of entries with the new DBpartition after migrating the set of entries from the existing DBpartition to the new DBpartition.