METHOD FOR REORGANIZING OR MOVING A DATABASE TABLE

• US 20120089566A1
• Filed: 10/11/2010
• Published: 04/12/2012
• Est. Priority Date: 10/11/2010
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Effern, Arndt, Haas, Frank-Martin, Ziegler, Torsten
• Granted Patent: US 8,886,596 B2
• Time in Patent Office: Days
• 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;

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

a data replicator module configured to cause the at least one processor to replicate the data contained in the source table in the target table.

2. The system of claim 1, further comprising:

a table replacer module configured to cause the at least one processor to replace the source table with the target table.

3. The 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.

4. The 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.

5. The system of claim 1, further comprising:

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

6. The 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.

7. The 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.

8. The system of claim 1, 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.

9. The system of claim 1, wherein the table generator module is configured to generate a target table that includes a storage attribute that is different than a storage attribute of the source table.

10. The 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.

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

generating a target table;

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

replicating the data contained in the source table in the target table.

12. The method of claim 11, further comprising:

replacing the source table with the target table.

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

14. The method of claim 11, further comprising:

generating a mapping table.

15. The method of claim 11, further comprising:

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

16. The method of claim 11, further comprising:

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

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

generate a target table;

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

replicate the data contained in the source table in the target table.

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

replace the source table with the target table

19. The computer program product of claim 17, 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.

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

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