Patent · US Active

Updating a partitioning column

US10474697B2 · kind B2 · utility

0Cited by

4References

15Claims

0Family size

Assignee

SAP SE · DE

Inventors

Christian Bensberg · Heidelberg, DE
Lars Fricke · Worms, DE
Martin Heidel · Walldorf, DE
Holger Bischoff · Dielheim, DE
Joern Schmidt · Walldorf, DE
Edward-Robert Tyercha · Heidelberg, DE
Andreas Tonder · Weinheim, DE

Key dates

Filing date	Dec 17, 2015
Grant date	Nov 12, 2019
Priority date	—
Expiry date	Oct 20, 2037

Classification

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

Abstract

An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.

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