Method for reorganizing or moving a database table

• US 8,886,596 B2
• Filed: 10/11/2010
• Issued: 11/11/2014
• Est. Priority Date: 10/11/2010
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Effern, Arndt, Haas, Frank-Martin, Ziegler, Torsten
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): BUI, THUY T
• Application Number:
  US12/901,853
• Publication Number:
  US 20120089566A1
• Time in Patent Office: 1,492 Days
• Field of Search: 707/610, 707/611
• US Class Current: 707/611
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing

Abstract

A computer system including instructions recorded on a non-transitory computer-readable storage medium and readable by at least one processor may include a table generator module, a table updater module, and a data replicator module. The table generator module may be configured to cause the at least one processor to generate a target table. The table updater module may be configured to cause the at least one processor to modify data in the target table synchronously with data being modified in a source table. The data replicator module may be configured to cause the at least one processor to replicate the data contained in the source table in the target table.

Claims

1. A computer system including instructions recorded on a non-transitory computer-readable storage medium and readable by at least one processor, the system comprising:

a table generator module configured to cause the at least one processor to generate a target table for reorganizing physical storage of data in a source table, the target table including table storage attributes that are different than table storage attributes of the source table;

a table updater module configured to cause the at least one processor to directly modify data in the target table synchronously with data being modified in a the source table,

wherein the table updater module is configured to cause the at least one processor to update data in the source table synchronously with data being updated in the target table;

a data replicator module configured to cause the at least one processor to replicate, in the target table, the data contained in the source table with the table storage attributes that are different than table storage attributes of the source table; and

a table replacer module configured to cause the at least one processor to;

replace the source table with the target table without relying on a staging table after the data in the source table is replicated in the target table,

redirect an application statement from the source table to the target table while maintaining access to the source table, and

after redirecting the application statement, change access to the target table, and delete the source table.

2. The computer system of claim 1, wherein table updater module is configured to cause the at least one processor to modify data in the target table in response to a trigger being satisfied.

3. The computer system of claim 1, wherein the table updater module is configured to cause the at least one processor to modify data in the target table in response to data being added, deleted, or changed in the source table.

4. The computer system of claim 1, further comprising:

a table mapper module configured to cause the at least one processor to generate a mapping table.

5. The computer system of claim 1, further comprising:

a table mapper module configured to cause the at least one processor to generate a mapping table, the mapping table unambiguously maps data of the source table with data of the target table.

6. The computer system of claim 1, further comprising:

a table mapper module configured to cause the at least one processor to generate a mapping table, the mapping table having a first unique identifier associated with a second unique identifier, the first unique identifier uniquely identifying data in the source table, the second unique identifier uniquely identifying data in the target table.

7. The computer system of claim 1, wherein the target table includes a storage attribute that is different than a storage attribute of the source table.

8. The computer system of claim 1, wherein the source table is stored in a first memory, the table generator module is configured to generate and store the target table in a second memory different than the first memory.

9. The computer system of claim 1, wherein the redirecting is performed after replication of the data has been completed by the data replicator module.

10. The computer system of claim 1, wherein the application statement is an structured query language statement configured to operate on the source table.

11. The computer system of claim 1, wherein the source table is stored in a first memory, the table generator module is configured to generate and store the target table in a second memory different than the first memory, the table replacer module is configured to cause the at least one processor to remove the source table from the first memory.

12. A computer-implemented method for causing at least one processor to execute instructions recorded on a non-transitory computer-readable storage medium, the method comprising:

generating a target table for reorganizing physical storage of data in a source table, the target table including table storage attributes that are different than table storage attributes of the source table;

directly modifying data in the target table synchronously with data being modified in the source table;

modifying data in the source table synchronously with data being updated in the target table;

replicating the data contained in the source table in the target table with the table storage attributes that are different than table storage attributes of the source table;

replacing the source table with the target table without relying on a staging table after the data in the source table is replicated in the target table;

redirecting an application statement from the source table to the target table while maintaining access to the source table; and

after redirecting the application statement, changing access to the target table, and deleting the source table.

13. The computer-implemented method of claim 12, wherein the data in the target table is modified in response to data being added, deleted, or changed in the source table.

14. The computer-implemented method of claim 12, further comprising:

generating a mapping table.

15. The computer-implemented method of claim 12, further comprising:

generating a mapping table that unambiguously maps data of the source table with data of the target table.

16. A computer program product, the computer program product being tangibly embodied on a non-transitory computer-readable medium and comprising instructions that, when executed, are configured to cause at least one processor to:

generate a target table for reorganizing physical storage of data in a source table, the target table including table storage attributes that are different than table storage attributes of the source table;

directly modify data in the target table synchronously with data being modified in a the source table;

modify data in the source table synchronously with data being updated in the target table;

replicate the data contained in the source table in the target table with the table storage attributes that are different than table storage attributes of the source table;

replace the source table with the target table without relying on a staging table after the data in the source table is replicated in the target table;

redirect an application statement from the source table to the target table while maintaining access to the source table; and

after redirecting the application statement, change access to the target table, and delete the source table.

17. The computer program product of claim 16, further comprising instructions that, when executed, are configured to cause the at least one processor to:

generate a mapping table that unambiguously maps data of the source table with data of the target table.