Efficient creation of a secondary database system

US11960369B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

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

Key dates

• Filing date: Oct 26, 2021
• Grant date: Apr 16, 2024
• Expiry date: Jun 3, 2042

Classification

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

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.