Managing nodes of a DBMS

US11656957B1 · kind B1 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Martin Jungfer · Ostelsheim, DE
• Jens Seifert · Schrobenhausen, DE
• Karl Fleckenstein · Malsch, DE
• Thomas Rech · Rittersheim, DE
• Alexander Zietlow · Sandhausen, DE
• Dirk Nakott · Eppelheim, DE
• Holger Hellmuth · Nuremberg, DE
• Hans-Jürgen Zeltwanger · Weinsberg, DE

Key dates

• Filing date: Dec 1, 2021
• Grant date: May 23, 2023
• Expiry date: Dec 1, 2041

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/25
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.