International Business Machines Corporation

Manogari Nogi Simanjuntak

Daniel Martin

Sowmya Kameswaran

Jia Heng Zhong

Curt Lee Cotner

Yao-Ching Stephen Chen

Jay A Yothers

Tammie Dang

Vassil Radkov Dimov

Claire Willey McFeely

Margaret Zagelow

Yumi Kimura Tsuji

Christian Michel

Baoqiu Cui

Joe Cheng-yu Huang

Björn Broll

Robert Thomas Miller

Xiaoyu Yang

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.

Archiving a table in a data analysis system

Technology for routing queries in a system with a plurality of nodes (for example online analytical processing sub-systems) where each node has an associated replicated local database and a local latency value and replication velocity values. The workload balancing for incoming received queries among and between the plurality of nodes is based, at least in part, on consideration of latency values and/or replication velocity values for the various nodes. The best node to handle a given query is thereby selected and the query is routed to the selected node for response.

Distribution of workloads among online analytics processing systems

Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: receiving by primary database system a query statement that references a first table, wherein the primary database system is associated to a first accelerator database system and a second accelerator database system, wherein modifications performed on tables of the primary database system are iteratively replicated into the first accelerator database system and the second accelerator database system; examining latency data that specifies a latency with which a modification to the first table has been replicated into the first accelerator database system and a latency with which a modification to the first table has been replicated into the second accelerator database system; selecting, in dependence on the examining, the first accelerator database system for execution of the query statement; routing the query statement to the first accelerator database system for execution in response to the selecting.

Reduced latency query processing

A computer-implemented method, system, and non-transitory computer program product for work assignment for parallelized database synchronization. Data changes to a source database are identified from a change log for the source database. The data changes are batched into data change chunks of data changes. An estimated processing cost for processing of each of the data change chunks to apply the data changes in the data change chunks to a target database is determined. A priority queue in which the data change chunks are identified in order of estimated processing cost is generated. Each data change chunk identified in the priority queue is assigned to a processing thread in a plurality of processing threads for processing in order by estimated processing cost from higher estimated processing cost to lower estimated processing cost to apply the data changes in the data change chunks to the target database.

Work assignment in parallelized database synchronization

A method, system, and program product for enabling multiple source database coherency is provided. The method includes detecting an incoming query to be executed with respect to an accelerator server. An initial timestamp of the incoming query is analyzed and additional timestamps of database tables referenced by the incoming query are retrieved. It is determined that each timestamp of the additional timestamps is reached with respect to a corresponding replication engine and target data from the database tables is synchronized with source data of a source database. In response, the incoming query is accelerated for execution with respect to a target database management system.

Multiple source database system consolidation

Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.

Supporting multiple versions of a routine

Growing community of inventors

San Jose, CA, United States of America

Manogari Nogi Simanjuntak