Patent · US Active

Database table re-partitioning using two active partition specifications

US10042910B2 · kind B2 · utility

6Cited by

25References

11Claims

0Family size

Assignee

SAP SE · DE

Inventors

Christian Bensberg · Heidelberg, DE
Lars Fricke · Worms, DE
Juchang Lee · Seoul, KR
Michael Muehle · Walldorf, DE
Thomas Peh · Bukit Mertajam, MY
Wolfgang Stephan · Heidelberg, DE

Key dates

Filing date	Feb 24, 2014
Grant date	Aug 7, 2018
Priority date	—
Expiry date	May 16, 2035

Classification

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

Abstract

Partitioning of source partitions of a table of a database to target partitions is initiated. Thereafter, a transition partition specification is specified that identifies the source partitions and the target partitions. Data is then moved (e.g., asynchronously moved, etc.) from the source partitions to the target partitions. Concurrently with the moving of the data, operates are handled using the transition partition specification. Subsequently, the source partitions are dropped when all of the data has been moved to the target partitions and there are no open transactions accessing the source partitions. Related apparatus, systems, techniques and articles are also described.

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