-
公开(公告)号：GB2586109A
公开(公告)日：2021-02-03
申请号：GB202018112
申请日：2019-05-07
Applicant: IBM
Inventor： SOWMYA KAMESWARAN , PETER BENDEL
Abstract: Loading a set of data into a target database management system (DBMS) from a source DBMS to increase workload performance and decrease resource usage is provided. Using a size and a change rate of tables eligible to be offloaded to the target DBMS, a total central processor unit (CPU) cost corresponding to loading the set of data into to the target DBMS and workload cost savings corresponding to executing one or more workloads on the target DBMS is determined based on a set of one or more load strategies. The total CPU cost is compared with the workload cost savings of each load strategy. An optimal load strategy is selected based on comparing the total CPU cost with the workload cost savings of each load strategy. The set of data is automatically loaded into to the target DBMS from the source DBMS in accordance with the selected optimal load strategy.
-
公开(公告)号：GB2628381A
公开(公告)日：2024-09-25
申请号：GB202304143
申请日：2023-03-22
Applicant: IBM
Inventor： MANOGARI NOGI SIMANJUNTAK , SOWMYA KAMESWARAN , BJÖRN BROLL , DANIEL MARTIN
Abstract: The present disclosure relates a method and system for archiving data in a data analysis system comprising a source database table 601.1 and a target database table 602.1 corresponding to the source table, wherein a data synchronisation enables a replication of data of the source table to the target database. The method comprises receiving a request to archive a source partition P1,P2 of a source table of source database system of the data analysis system. In response to determining that the source table is partitioned by range, the source partition is locked for preventing changes of the source partition 601.2. In response to determining that the source partition is synchronized with the corresponding partition in the target table 602.2, data in the source partition is removed from the source table 601.3. At the target database system a first database view 604 may be created representing the non-archived partitions, and a second database view 605 representing the archived and non-archived partitions, wherein execution of a query is performed using the second database view.
-
公开(公告)号：GB2586109B
公开(公告)日：2021-07-14
申请号：GB202018112
申请日：2019-05-07
Applicant: IBM
Inventor： SOWMYA KAMESWARAN , PETER BENDEL
Abstract: Loading a set of data into a target database management system (DBMS) from a source DBMS to increase workload performance and decrease resource usage is provided. Using a size and a change rate of tables eligible to be offloaded to the target DBMS, a total central processor unit (CPU) cost corresponding to loading the set of data into to the target DBMS and workload cost savings corresponding to executing one or more workloads on the target DBMS is determined based on a set of one or more load strategies. The total CPU cost is compared with the workload cost savings of each load strategy. An optimal load strategy is selected based on comparing the total CPU cost with the workload cost savings of each load strategy. The set of data is automatically loaded into to the target DBMS from the source DBMS in accordance with the selected optimal load strategy.
-
-
Search Results
3
records
(took 0.016 seconds)
