Column store main fragments in non-volatile RAM and the column store main fragments are merged with delta fragments, wherein the column store main fragments are not allocated to volatile random access memory and initialized from disk

US10824673B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Oliver Rebholz · Siebeldingen, DE
• Ivan Schreter · Malsch, DE
• Abdelkader Sellami · Heidelberg, DE
• Daniel Booss · Angelbachtal, DE
• Gunter Radestock · Walldorf, DE
• Peter Bumbulis · Kitchener, CA
• Alexander Boehm · Sandhausen, DE
• Frank Renkes · Wiesloch, DE
• Werner Thesing · Herbstein, DE
• Thomas Willhalm · Sandhausen, DE

Key dates

• Filing date: Sep 5, 2017
• Grant date: Nov 3, 2020
• Expiry date: Sep 5, 2037

Classification

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

Abstract

A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.