Hybrid column store providing both paged and memory-resident configurations

US11755565B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Colin Florendo · Marlborough, US
• Mihnea Andrei · Issy-les-Moulineaux, FR
• Amit Pathak · Pune, IN
• Robert Schulze · Walldorf, DE
• Adrian Dragusanu · Garches, FR
• Reza Sherkat · Waterloo, CA
• Sebastian Seifert · Heidelberg, DE
• Christian Lemke · Karlsruhe, DE

Key dates

• Filing date: Oct 7, 2021
• Grant date: Sep 12, 2023
• Expiry date: Oct 7, 2041

Classification

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

Abstract

Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.