Invention Grant
- Patent Title: Updating a partitioning column
-
Application No.: US14973596Application Date: 2015-12-17
-
Publication No.: US10474697B2Publication Date: 2019-11-12
- Inventor: Christian Bensberg , Lars Fricke , Martin Heidel , Holger Bischoff , Joern Schmidt , Edward-Robert Tyercha , Andreas Tonder
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/23 ; G06F16/27

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.
Public/Granted literature
- US20170177700A1 UPDATING A PARTITIONING COLUMN Public/Granted day:2017-06-22
Information query