公开(公告)号：US20230168979A1

公开(公告)日：2023-06-01

申请号：US17539640

申请日：2021-12-01

Applicant: International Business Machines Corporation

Inventor： Martin Jungfer ,  Jens Peter Seifert ,  Karl Fleckenstein ,  Thomas Rech ,  Alexander Zietlow ,  Dirk Nakott ,  Holger Hellmuth ,  Hans-Jürgen Zeltwanger

IPC: G06F11/18 ,  G06F11/30 ,  G06F16/2453

CPC classification number: G06F11/181 ,  G06F11/3006 ,  G06F16/24534

Abstract: A tool for replacing a first database node of a database management system by a second database node. The tool receives an indication that the first database node received a data access request for accessing a database shared between the first database node and the second database node. The tool duplicates the data access request at the first database node. Responsive to a determination that the duplicated data access request includes a data changing statement and a previously executed statement, the tool modifies the duplicated data access request to prevent execution of the data changing statement and the previously executed statement at the second database node. The tool executes the modified duplicated data access request at the second database node. The tool replaces, based on a replacement condition being met, the first database node with the second database node in the database management system.

公开(公告)号：US12093139B2

公开(公告)日：2024-09-17

申请号：US17644569

申请日：2021-12-16

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Karl Fleckenstein ,  Jens Peter Seifert ,  Hans-Jürgen Zeltwanger ,  Thomas Rech ,  Dirk Nakott ,  Holger Hellmuth ,  Alexander Zietlow ,  Martin Jungfer

IPC: G06F16/00 ,  G06F11/14 ,  G06F16/23

CPC classification number: G06F11/1469 ,  G06F16/2379 ,  G06F2201/84

Abstract: A system and method for a database management system. The method comprises: receiving a database transaction for inserting a set of records in a database table of the database management system or for creating indexes. The database transaction may be executed using the database management system. The database management system may rollback the database transaction by truncating the database table or the created indexes.

公开(公告)号：US20250077523A1

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

申请号：US18457379

申请日：2023-08-29

Applicant: International Business Machines Corporation

Inventor： Dirk Nakott ,  Hans-Jürgen Zeltwanger ,  Jens Peter Seifert ,  Holger Hellmuth ,  Jörn Klauke ,  Martin Jungfer ,  Thomas Rech ,  Malte Schünemann

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2458

Abstract: Methods for capturing temporary database tables for analyzing a database query are provided. Aspects include obtaining a capture pattern and the database query having a sequence of statements. Aspects also include determining that a first statement of the sequence of statements matches the capture pattern, creating a list of temporary tables based on the first statement, and determining that a second statement of the sequence of statements includes one of a drop, commit, and truncate commands that correspond to a table in the list of temporary tables. Aspects further include creating a copy of the table in the list of temporary tables, generating an updated first statement by replacing a reference to the table in the list of temporary tables with a reference to the copy of the table, removing the table from the list of temporary tables, and executing the database query by performing the sequence of statements.

公开(公告)号：US20240311358A1

公开(公告)日：2024-09-19

申请号：US18302022

申请日：2023-04-18

Applicant: International Business Machines Corporation

Inventor： Hans-Jürgen Zeltwanger ,  Dirk Nakott ,  Jens Peter Seifert ,  Holger Hellmuth ,  Jörn Klauke ,  Martin Jungfer ,  Thomas Rech ,  Alexander Zietlow

IPC: G06F16/22

CPC classification number: G06F16/2282

Abstract: In several aspects for storing a table, in which the table is configured for comprising records having values of one or more attributes, a processor creates a pseudo table representing the table, the creating comprising defining an empty version of the table in a program. One or more records may be inserted in the pseudo table by encoding attribute values of the one or more records as inline data in the program. In response to determining that the pseudo table satisfies a materialization criterion, the pseudo table may be materialized by creating the table with the records encoded in the program and removing the program.

公开(公告)号：US11960369B2

公开(公告)日：2024-04-16

申请号：US17511018

申请日：2021-10-26

Applicant: International Business Machines Corporation

Inventor： Hans-Jürgen Zeltwanger ,  Karl Fleckenstein ,  Jens Peter Seifert ,  Martin Jungfer ,  Thomas Rech ,  Alexander Zietlow ,  Dirk Nakott ,  Holger Hellmuth

IPC: G06F11/00 ,  G06F11/20 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F11/2028 ,  G06F16/214 ,  G06F16/24568 ,  G06F16/27

Abstract: A method for generating a copy of a database using a data streaming protocol is disclosed. The method comprises setting up a structure of a secondary database, prioritizing data objects to be copied from a primary database to the secondary database, copying data objects from the primary database to the secondary database using a data streaming protocol, restoring data corresponding to the data object in the secondary database in parallel to copying data objects from the primary database to the secondary database, applying changes made to the data corresponding to the data object in the primary database during the time of copying, after the data object has been copied, and making available the secondary database for usage once all data objects have been copied from the primary database to the secondary database so that a usable copy of the primary database is created.

公开(公告)号：US20230281218A1

公开(公告)日：2023-09-07

申请号：US17653315

申请日：2022-03-03

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Thomas Rech ,  Hans-Jürgen Zeltwanger ,  Dirk Nakott ,  Jens Peter Seifert ,  Martin Jungfer ,  Holger Hellmuth ,  Jörn Klauke ,  Alexander Zietlow

IPC: G06F16/27 ,  G06F16/2458

CPC classification number: G06F16/27 ,  G06F16/2471

Abstract: An approach includes collecting metadata indicative of a computer system comprising (i) a primary database, configured to connect to a secondary database, and (ii) the secondary database that replicates the primary database. The approach further includes receiving, at the primary database from a requestor, a query referencing the primary database. The approach further includes, responsive to receiving the query, performing an offload including: determining a first load on the primary database; responsive to the first load satisfying a first offload condition, determining, using the metadata, whether a second load on the secondary database satisfies a second offload condition; and responsive to the second load satisfying the second offload condition, offloading at least part of the query to the secondary database in order to cause the at least part of the query to be executed by the secondary database. The method further includes providing to the requestor results of the query.

公开(公告)号：US20230195582A1

公开(公告)日：2023-06-22

申请号：US17644569

申请日：2021-12-16

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Karl Fleckenstein ,  Jens Peter Seifert ,  Hans-Jürgen Zeltwanger ,  Thomas Rech ,  Dirk Nakott ,  Holger Hellmuth ,  Alexander Zietlow ,  Martin Jungfer

IPC: G06F11/14 ,  G06F16/23

CPC classification number: G06F11/1469 ,  G06F16/2379 ,  G06F2201/84

Abstract: A system and method for a database management system. The method comprises: receiving a database transaction for inserting a set of records in a database table of the database management system or for creating indexes. The database transaction may be executed using the database management system. The database management system may rollback the database transaction by truncating the database table or the created indexes.

公开(公告)号：US11656957B1

公开(公告)日：2023-05-23

申请号：US17539640

申请日：2021-12-01

Applicant: International Business Machines Corporation

Inventor： Martin Jungfer ,  Jens Peter Seifert ,  Karl Fleckenstein ,  Thomas Rech ,  Alexander Zietlow ,  Dirk Nakott ,  Holger Hellmuth ,  Hans-Jürgen Zeltwanger

IPC: G06F11/07 ,  G06F11/18 ,  G06F16/2453 ,  G06F11/30

CPC classification number: G06F11/181 ,  G06F11/3006 ,  G06F16/24534

Abstract: A tool for replacing a first database node of a database management system by a second database node. The tool receives an indication that the first database node received a data access request for accessing a database shared between the first database node and the second database node. The tool duplicates the data access request at the first database node. Responsive to a determination that the duplicated data access request includes a data changing statement and a previously executed statement, the tool modifies the duplicated data access request to prevent execution of the data changing statement and the previously executed statement at the second database node. The tool executes the modified duplicated data access request at the second database node. The tool replaces, based on a replacement condition being met, the first database node with the second database node in the database management system.

公开(公告)号：US20230128784A1

公开(公告)日：2023-04-27

申请号：US17511018

申请日：2021-10-26

Applicant: International Business Machines Corporation

Inventor： Hans-Jürgen Zeltwanger ,  Karl Fleckenstein ,  Jens Peter Seifert ,  Martin Jungfer ,  Thomas Rech ,  Alexander Zietlow ,  Dirk Nakott ,  Holger Hellmuth

IPC: G06F11/20 ,  G06F16/21 ,  G06F16/27 ,  G06F16/2455

Abstract: A method for generating a copy of a database using a data streaming protocol is disclosed. The method comprises setting up a structure of a secondary database, prioritizing data objects to be copied from a primary database to the secondary database, copying data objects from the primary database to the secondary database using a data streaming protocol, restoring data corresponding to the data object in the secondary database in parallel to copying data objects from the primary database to the secondary database, applying changes made to the data corresponding to the data object in the primary database during the time of copying, after the data object has been copied, and making available the secondary database for usage once all data objects have been copied from the primary database to the secondary database so that a usable copy of the primary database is created.

公开(公告)号：US09792326B1

公开(公告)日：2017-10-17

申请号：US15338665

申请日：2016-10-31

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Andrei F. Lurie ,  Dirk Nakott ,  Johannes Schuetzner

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30469 ,  G06F17/30474

Abstract: Dynamically switching between a plurality of execution paths to execute a function, such as a user-defined function. The plurality of execution paths include an execution path that uses caching and another execution path that uses inlining. A user-defined function is executed at least once using a first execution path. Then, for a later execution of the function, the execution path is automatically switched to a second execution path.