Abstract: The present disclosure relates to a method. A main transaction may be received. The main transaction comprises a set of change records of the at least one source table. Each change record represents at least one data record of a source table of the at least one source table. A least one subset of change records of the set of change records may be determined. Each subset of change records is determined such that it represents a distinct source partition of the at least one source table. A sub-transaction may be determined per subset of change records of the at least one subset of change records. The main transaction may be executed by at least concurrently executing the set of sub-transactions, wherein the execution of each sub-transaction of the sub-transactions comprises concurrently adapting a data store and adapting a metadata store in accordance with the sub-transaction.

Abstract: The present disclosure relates to a method. A main transaction may be received. The main transaction comprises a set of change records of the at least one source table. Each change record represents at least one data record of a source table of the at least one source table. A least one subset of change records of the set of change records may be determined. Each subset of change records is determined such that it represents a distinct source partition of the at least one source table. A sub-transaction may be determined per subset of change records of the at least one subset of change records. The main transaction may be executed by at least concurrently executing the set of sub-transactions, wherein the execution of each sub-transaction of the sub-transactions comprises concurrently adapting a data store and adapting a metadata store in accordance with the sub-transaction.

Abstract: An embodiment for archiving data in a data analysis system. The embodiment may receive a request to archive a source partition of a source table of source database system of the data analysis system. The embodiment may determine whether the source table is partitioned into partitions by ranges of an attribute of the source table. The embodiment may, in response to determining that the source table is partitioned by range, lock the source partition to prevent changes of the source partition. The embodiment may determine 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, the embodiment may remove data in the source partition from the source table.

Abstract: An embodiment for archiving data in a data analysis system. The embodiment may receive a request to archive a source partition of a source table of source database system of the data analysis system. The embodiment may determine whether the source table is partitioned into partitions by ranges of an attribute of the source table. The embodiment may, in response to determining that the source table is partitioned by range, lock the source partition to prevent changes of the source partition. The embodiment may determine 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, the embodiment may remove data in the source partition from the source table.

Abstract: The present disclosure relates to executing concurrent database operations in a database system during a time window. The database operations are configured to use storage units of a storage space of the database system. A first usage speed of free storage units is determined to be used by at least one first database operation and a second usage speed of free storage units to be used by a second database operation. The first and second usage speeds may be used for determining a maximum number of free storage units to be used by the second database operation during the time window. The second database operation may be executed during the time window in accordance with the maximum number. The first database operation may be executed, wherein the execution of the first database operation during the time window being limited to the storage units of the storage space.

Abstract: The present disclosure relates to executing concurrent database operations in a database system during a time window. The database operations are configured to use storage units of a storage space of the database system. A first usage speed of free storage units is determined to be used by at least one first database operation and a second usage speed of free storage units to be used by a second database operation. The first and second usage speeds may be used for determining a maximum number of free storage units to be used by the second database operation during the time window. The second database operation may be executed during the time window in accordance with the maximum number. The first database operation may be executed, wherein the execution of the first database operation during the time window being limited to the storage units of the storage space.