Patent · US Active

In-place load unit conversion

US11372845B2 · kind B2 · utility

0Cited by

2References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Deepak Shrivastava · Pune, IN
Chaitanya Gottipati · Pune, IN
Colin Florendo · Marlborough, US
Rolando Blanco · Schreiber, CA
Michael Muehle · Walldorf, DE
Awisha Makwana · Pune, IN

Key dates

Filing date	Jun 5, 2020
Grant date	Jun 28, 2022
Priority date	—
Expiry date	Oct 2, 2040

Classification

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

Abstract

Disclosed herein are system, method, and computer program product embodiments for converting column loadable data in a database into a page loadable format. When a column oriented in-memory database needs to perform an operation on a table, the affected columns must be loaded fully into memory. In some cases, a database may partition tables, allowing for column fragments corresponding to those partitions to be loaded into memory. These column fragments may exceed available memory, such that it is beneficial to convert the column fragment into a page loadable format. Approaches are discussed herein for performing the conversion without the need to update global metadata during the process, allowing for multiple parallel column fragments to be updated, allowing data manipulation language (DML) operations to continue on the column during the conversion process, and reducing the impact of blocked parallel savepoint operations during the conversion process by chunking the conversion process.

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