Patent · US Active

Two phase move of database tables

US11899645B1 · kind B1 · utility

0Cited by

0References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Fei Qiu · Richmond, US
Hans-Joerg Leu · Dossenheim, DE
Srinivas Gajjalakonda · Heidelberg, DE
Dan Ding · Hong Kong, CN

Key dates

Filing date	Sep 9, 2022
Grant date	Feb 13, 2024
Priority date	—
Expiry date	Sep 9, 2042

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/27
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A two phase move technique for moving groups of tables may reduce cross-host communication and length of table locks. A group including a first table and a second table may be moved to the destination host system. This is done by creating a third table replicating the first table and creating a fourth table replicating the second table on the destination host, and replicas of other tables in the group. The tables in the group are not locked against modifications during the creation of the replica tables. After the creation of the replicas, roles of the original tables and the created tables are switched such that the original tables are set to the replica role and the created tables stored on the destination are set to the source role. The original tables are dropped after the switching of the roles.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.