US 11,755,565 B2
Hybrid column store providing both paged and memory-resident configurations
Colin Florendo, Marlborough, MA (US); Mihnea Andrei, Issy les Moulineaux (FR); Amit Pathak, Pune (IN); Robert Schulze, Walldorf (DE); Adrian Dragusanu, North Vancouver (CA); Reza Sherkat, Waterloo (CA); Sebastian Seifert, Heidelberg (DE); and Christian Lemke, Walldorf (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Oct. 7, 2021, as Appl. No. 17/496,108.
Application 17/496,108 is a continuation of application No. 16/866,766, filed on May 5, 2020, granted, now 11,151,126.
Claims priority of provisional application 62/858,693, filed on Jun. 7, 2019.
Prior Publication US 2022/0027354 A1, Jan. 27, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/24 (2019.01); G06F 16/23 (2019.01); G06F 12/02 (2006.01); G06F 3/06 (2006.01); G06F 16/22 (2019.01); G06F 12/0882 (2016.01); G06F 16/2455 (2019.01); G06F 12/0875 (2016.01); G06F 9/48 (2006.01)
CPC G06F 16/2379 (2019.01) [G06F 3/0604 (2013.01); G06F 3/064 (2013.01); G06F 3/0673 (2013.01); G06F 9/4843 (2013.01); G06F 12/0223 (2013.01); G06F 12/0246 (2013.01); G06F 12/0875 (2013.01); G06F 12/0882 (2013.01); G06F 16/221 (2019.01); G06F 16/2219 (2019.01); G06F 16/2228 (2019.01); G06F 16/2237 (2019.01); G06F 16/2255 (2019.01); G06F 16/2272 (2019.01); G06F 16/2282 (2019.01); G06F 16/24552 (2019.01); G06F 16/24558 (2019.01); G06F 2212/1024 (2013.01); G06F 2212/1044 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A database system, comprising:
a hybrid column store, comprising:
an in-memory store including a buffer cache configured to store a representation of a database object;
an on-disk store comprising an in-memory primitive store and a paged primitive store including one or more pages located outside the buffer cache, and configured to store a primitive for the representation of the database object, wherein the primitive is saved as an in-memory form primitive in the in-memory primitive store as a compressed version of the representation of the database object by a contiguous block of data or a paged form primitive in the paged primitive store as a compressed version of the representation of the database object on the one or more pages of the paged primitive store, wherein the in-memory form primitive and the paged form primitive are a byte-compatible representation of the database object to provide a unified persistence format for the database object.