公开(公告)号：GB2586109B

公开(公告)日：2021-07-14

申请号：GB202018112

申请日：2019-05-07

Applicant: IBM

Inventor： SOWMYA KAMESWARAN ,  PETER BENDEL

IPC: G06F17/00 ,  G06F16/25

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.

公开(公告)号：GB2534373A

公开(公告)日：2016-07-27

申请号：GB201500934

申请日：2015-01-20

Applicant: IBM

Inventor： OLIVER BENKE ,  OLIVER DRAESE ,  ROLAND SEIFFERT ,  KNUT STOLZE ,  PETER BENDEL ,  NAMIK HRLE ,  MARYELA WEIHRAUCH ,  RUIPING LI

IPC: G06F17/30

Abstract: A computer-implemented method for processing data (118) in a distributed system (112) comprising a first DBMS (110) and an accelerator system (120). The method comprises: maintaining (302), by the first DBMS, a catalogue (116), the catalogue comprising first metadata (MD1) descriptive of first data containers (124.1) in the first DBMS and second metadata (MD2) descriptive of second data containers (124.2, 128) in the accelerator system; providing (304) a single interface (138) of the distributed system for receiving a database query (140); evaluating (306), by the single interface, the received database query (140); if the received database query comprises a DDL statement related to the creation or modification of a first data container, providing (310) said DDL statement to the first DBMS and processing (322) said DDL statement by the first DBMS; if the database query comprises a DDL statement related to the creation or modification of a second data container, providing (312) said DDL statement to the first DBMS and processing (324) said DDL statement by the first DBMS, thereby creating a trigger signal; if the received database query comprises a DML statement, determining (3 14), by the single interface, if said DML statement shall be processed by the first DBMS or shall be dispatched to the accelerator system for being processed; in response to the generation of the trigger signal, creating, deleting or updating (318), by the accelerator system, the second data container to which the DDL statement relates in the accelerator system; and updating, by the accelerator system, the second metadata (MD2) in the catalogue (116) accordingly; if the DML statement is dispatched to the accelerator system, processing (320), by the accelerator system, the dispatched DML statement on data (118.2) contained in the second data containers.

公开(公告)号：GB2604758A

公开(公告)日：2022-09-14

申请号：GB202205338

申请日：2020-08-21

Applicant: IBM

Inventor： PETER BENDEL ,  OLIVER HARM ,  KNUT STOLZE ,  BJÖRN BROLL

IPC: G06F12/02 ,  G06F16/21

Abstract: The present disclosure relates to a method for 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. The method comprises determining a first usage speed of free storage units 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.

公开(公告)号：GB2586109A

公开(公告)日：2021-02-03

申请号：GB202018112

申请日：2019-05-07

Applicant: IBM

Inventor： SOWMYA KAMESWARAN ,  PETER BENDEL

IPC: G06F17/00 ,  G06F16/25

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.

公开(公告)号：GB2534374A

公开(公告)日：2016-07-27

申请号：GB201500937

申请日：2015-01-20

Applicant: IBM

Inventor： OLIVER BENKE ,  OLIVER DRAESE ,  ROLAND SEIFFERT ,  KNUT STOLZE ,  PETER BENDEL

IPC: G06F17/30

Abstract: A distributed system (112) comprises a first DBMS (110) and an accelerator system (120). The first DBMS (110) comprises data (118.1) and a catalogue (116). The catalogue comprises first (MD1) and second (IVED2) metadata. The first metadata is descriptive of the structure of first data containers (e.g. tables or views) (122, 124.1) stored in the first database management system. The second metadata is descriptive of the structure of second data containers (124.2, 128) stored in the accelerator system. The accelerator system comprises a copy (118.2) of at least some parts of the data (118.1). The distributed system (112) further comprises a single interface (138) for receiving a database query (140). At least the accelerator system is configured for solely processing database queries received by the distributed system (112) via the single interface, the single interface being configured for accessing the catalogue. The first DBMS is configured for: detecting a trigger event for calculating a computational task; creating incomplete second metadata for a second data container which is absent from the accelerator system at the moment of the detection, the incomplete second metadata comprising a name or a namespace for the absent second data container and lacking structural information of said second data container; causing the accelerator system to execute program logic of the accelerator system, the execution of the program logic, said execution comprising: dynamically identifying (414) information being indicative of structural features the absent second data container shall comply to; transmitting (416) the dynamically identified information to the first database management system; creating the second data container in accordance with said structural features; storing the created second data container in the accelerator system and filling said second data container with data; supplementing the incomplete second metadata with the transmitted information, thereby creating complete second metadata being descriptive of the name and structure of the created second data container.