US 12,443,625 B2
Archiving a table in a data analysis system
Manogari Nogi Simanjuntak, San Jose, CA (US); Sowmya Kameswaran, San Jose, CA (US); Björn Broll, Waldenbuch (DE); and Daniel Martin, Leinfelden-Echterdingen (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Apr. 20, 2023, as Appl. No. 18/303,810.
Prior Publication US 2024/0320237 A1, Sep. 26, 2024
Int. Cl. G06F 16/27 (2019.01); G06F 16/215 (2019.01); G06F 16/23 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/278 (2019.01) [G06F 16/215 (2019.01); G06F 16/2343 (2019.01); G06F 16/2379 (2019.01); G06F 16/2445 (2019.01); G06F 16/24554 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for archiving data in a data analysis system, the data analysis system comprising a source database system and a target database system, the source database system comprising a source table, the source table being partitioned into source partitions by ranges of an attribute of the source table, the target database system comprising a target table corresponding to the source table, wherein a data synchronization in the data analysis system enables a replication of data of the source table from the source database system to the target database system; the method comprising:
receiving a request to archive a source partition of the source table;
determining whether the source table is partitioned into partitions by ranges of an attribute of the source table;
in response to determining that the source table is partitioned by range, locking the source partition to prevent changes of the source partition;
determining whether the source partition is synchronized with a corresponding partition in the target table;
in response to determining that the source partition is synchronized with the corresponding partition in the target table, removing data of the source partition from the source table;
receiving a query referencing a whole range of the source table;
offloading the received query to the target database system for executing the received query at the target database system on the target table that comprises archived and non-archived partitions of the source table; and
creating at the target database system a first database view representing the non-archived partitions, and a second database view representing the archived and the non-archived partitions, wherein execution of the received query is performed using the second database view.