Updating a table using incremental and batch updates

US11176140B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Daniel Martin · Stuttgart, DE
• Knut Stolze · Jena, DE
• Jens Müller · Neviges, DE
• Sabine Perathoner-Tschaffler · Nufringen, DE
• Felix Beier · Haigerloch, DE
• Einar Lueck · Bonlanden, DE

Key dates

• Filing date: Jun 24, 2019
• Grant date: Nov 16, 2021
• Expiry date: Aug 26, 2039

Classification

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

Abstract

The invention relates to computer-implemented method for updating a target table with changes introduced into a source table. New data records are stored into partitions of the source table. An incremental update module copies the new data records from the source table into the target table, thereby assigning a new target partition ID contained within a first value domain to each copied data record. A view specifies a set of visible partition IDs as a union of the first value domain and of a current target partition ID set and allows the execution of database queries selectively on target table partitions having assigned a target partition ID that is element of the visible partition ID set. A batch update module performs an atomic batch update operation that comprises copying partitions of the source table into a respective new partition in the target table.