公开(公告)号：IL295463B1

公开(公告)日：2025-03-01

申请号：IL29546322

申请日：2022-08-08

Applicant: IBM ,  DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

Inventor： DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

IPC: G06F16/23 ,  G06F16/2453 ,  G06F16/2458

Abstract: Methods and systems for generating database statistics. Table statistics in a metadata catalog of a source database system are observed, statistics generation costs utilizing a target database system are estimated, and source statistics generation costs utilizing a source database system are estimated. The statistics generation costs are compared and statistics generation queries by the target database system are triggered in response to the statistics generation costs utilizing the target database system having a predefined relationship with the source statistics generation costs utilizing the source database system. The statistics generation queries are performed by the target database system in response to the triggering by the source database system. The generated statistics are sent from the target database system to the source database system, the table statistics in a metadata catalog are updated based on the generated statistics, and the updated table statistics are used to optimize a query plan.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：GB2590239B

公开(公告)日：2022-07-06

申请号：GB202100676

申请日：2019-05-13

Applicant: IBM

Inventor： OLIVER BENKE ,  TOBIAS BERGMANN

IPC: G06F21/70

Abstract: Secure operations are performed on encrypted code. A processor in a first operating mode obtains encrypted code. The processor switches from the first operating mode to a second operating mode, and decrypts the encrypted code to obtain decrypted code. The decrypted code is executed, based on the processor being in the second operating mode, to provide a result. The result is encrypted, and the encrypted result is sent to a user, based on the processor switching back to the first operating mode.

公开(公告)号：GB2590239A

公开(公告)日：2021-06-23

申请号：GB202100676

申请日：2019-05-13

Applicant: IBM

Inventor： OLIVER BENKE ,  TOBIAS BERGMANN

IPC: G06F21/70

Abstract: Secure operations are performed on encrypted code. A processor in a first operating mode obtains encrypted code. The processor switches from the first operating mode to a second operating mode, and decrypts the encrypted code to obtain decrypted code. The decrypted code is executed, based on the processor being in the second operating mode, to provide a result. The result is encrypted, and the encrypted result is sent to a user, based on the processor switching back to the first operating mode.

公开(公告)号：IL295463A

公开(公告)日：2022-10-01

申请号：IL29546322

申请日：2022-08-08

Applicant: IBM ,  DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

Inventor： DENNIS BUTTERSTEIN ,  OLIVER BENKE ,  TOBIAS ULRICH BERGMANN ,  FELIX BEIER ,  TERENCE P PURCELL

IPC: G06F16/2453

Abstract: Methods and systems for generating database statistics. Table statistics in a metadata catalog of a source database system are observed, statistics generation costs utilizing a target database system are estimated, and source statistics generation costs utilizing a source database system are estimated. The statistics generation costs are compared and statistics generation queries by the target database system are triggered in response to the statistics generation costs utilizing the target database system having a predefined relationship with the source statistics generation costs utilizing the source database system. The statistics generation queries are performed by the target database system in response to the triggering by the source database system. The generated statistics are sent from the target database system to the source database system, the table statistics in a metadata catalog are updated based on the generated statistics, and the updated table statistics are used to optimize a query plan.

公开(公告)号：GB2532469A

公开(公告)日：2016-05-25

申请号：GB201420602

申请日：2014-11-20

Applicant: IBM

Inventor： OLIVER BENKE ,  STEFAN LETZ ,  JAN KUNIGK

IPC: G06F17/30

Abstract: A distributed database method comprises a first set of database tables, wherein data of a logical database table is distributed (102) among the first set of database tables according to a first distribution key. The method further comprises maintaining a second set of database tables (104) using a second distribution key that is different from the first distribution key. Furthermore, the method comprises maintaining (106) at least one performance metric value for the stored query when executing a query, and determining the second distribution key (108) based on the at least one performance metric value, preferably workload, query execution time or network traffic.