Patent · US Active

Online reorganization of database tables with concurrent updates using virtual partitions

US11354337B1 · kind B1 · utility

1Cited by

1References

20Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Reinhold Geiselhart · Liebfrauenhöhe, DE
Felix Beier · Haigerloch, DE
Knut Stolze · Jena, DE
Luis Eduardo Oliveira Lizardo · Böblingen, DE

Key dates

Filing date	Jan 12, 2021
Grant date	Jun 7, 2022
Priority date	—
Expiry date	Feb 11, 2041

Classification

Technology area (CPC G)Physics
CPC primaryG06F2212/152
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

In an approach to online reorganization of database tables with concurrent updates using virtual partitions, responsive to receiving a table to reorganize, rows of the first table are selected, where the rows of the first table create a first virtual partition. A memory for a second virtual partition is allocated, where the second virtual partition is appended to a second table. A union view is created comprising a union of remaining rows of the first table with the second table, where the remaining rows of the first table have not been copied to the second table. The first virtual partition is copied into the second virtual partition. Responsive to receiving queries before copying the first virtual partition into the second virtual partition is complete, the queries are allowed to access the union view.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.