Online Table Move

• US 20090319581A1
• Filed: 06/19/2008
• Published: 12/24/2009
• Est. Priority Date: 06/19/2008
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Seifert, Jens
• Application Number:
  US12/141,991
• Publication Number:
  US 20090319581A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures

Abstract

A method of moving a table in a database management system includes: copying contents of a first table to a second table; monitoring operations performed on the first table during the copying; selectively storing changes performed on the first table to a temporary table based on the monitoring; and copying the changes from the temporary table to the second table.

Claims

1. A method of moving a table in a database management system, the method comprising:

copying contents of a first table to a second table;

monitoring operations performed on the first table during the copying;

selectively storing changes performed on the first table to a temporary table based on the monitoring; and

copying the changes from the temporary table to the second table.

2. The method of claim 1 wherein the monitoring operations is based on at least one of an update operation, a delete operation, and an insert operation.

3. The method of claim 2 further comprising identifying at least one of an update before operation and an update after operation based on the operations performed on the first table and wherein the selectively storing changes performed on the first table is based on the identifying.

4. The method of claim 1 wherein the selectively storing changes performed on the first table is based on an index of the first table.

5. The method of claim 4 further comprising associating an index with each change of the changes and wherein the selectively storing changes performed on the first table is based on a comparison of the indexes.

6. The method of claim 1 further comprising naming the second table based on a name of the first table.

7. The method of claim 1 further comprising naming at least one of the temporary table and the second table based on at least one of a hash function and an object identifier.

8. The method of claim 1 further comprising locking access to the first table during the copying of the changes from the temporary table to the second table.

9. A table management system, the system comprising:

a copy module that copies content of a first table to a second table;

a replay module that selectively stores changes performed on the first table to a temporary table based on operations performed on the first table, and that copies the changes from the temporary table to the second table; and

a swap module that associates properties of the first table with properties of the second table.

10. The system of claim 9 wherein the replay module further monitors the operations performed on the first table and selectively stores the changes based on the operations.

11. The system of claim 10 wherein the operations include at least one of an update operation, a delete operation, and an insert operation.

12. The system of claim 10 wherein the replay module identifies at least one of an update before operation and an update after operation based on the operations performed on the first table and wherein the selectively storing changes performed on the first table is based on the at least one of the update before operation and the update after operation.

13. The system of claim 9 wherein the replay module selectively stores the changes performed on the first table based on an index of the first table.

14. The system of claim 12 wherein the replay module associates an index with each change of the changes and wherein the replay module selectively stores the changes performed on the first table based on a comparison of the indexes.

15. The system of claim 9 further comprising naming the second table based on a name of the first table.

16. The system of claim 9 further comprising an initialization module that creates at least one of the temporary table and the second table and that names at least one of the temporary table and the second table based on at least one of a hash function and an object identifier.

17. The system of claim 9 wherein the swap module locks access to the first table during the copying of the changes from the temporary table to the second table.

18. The system of claim 9 further comprising a cleanup module that deletes the first table and the temporary table.

19. A computer program product that enables a computer to manage tables of a database management system, the computer program product comprising:

software instructions for enabling the computer to perform predetermined operations; and

a computer readable medium bearing the software instructions;

the predetermined operations including the steps of;

copying contents of a first table to a second table;

monitoring operations performed on the first table during the copying;

selectively storing changes performed on the first table to a temporary table based on the monitoring; and

copying the changes from the temporary table to the second table.