- 专利标题: Database table re-partitioning using two active partition specifications
-
申请号: US14188541申请日: 2014-02-24
-
公开(公告)号: US10042910B2公开(公告)日: 2018-08-07
- 发明人: Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
- 申请人: Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
- 申请人地址: DE Walldorf
- 专利权人: SAP SE
- 当前专利权人: SAP SE
- 当前专利权人地址: DE Walldorf
- 代理机构: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
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.
公开/授权文献
信息查询