US 11,726,985 B2
Hybrid in-memory/pageable spatial column data
Colin Florendo, Marlborough, MA (US); Surendra Vishnoi, Jodhpur (IN); Janardhan Hungund, Pune (IN); and Manuel Caroli, Mannheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jun. 2, 2020, as Appl. No. 16/890,020.
Claims priority of provisional application 62/858,693, filed on Jun. 7, 2019.
Prior Publication US 2020/0387502 A1, Dec. 10, 2020
Int. Cl. G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 12/02 (2006.01); G06F 3/06 (2006.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)] 16 Claims
OG exemplary drawing
 
1. A computer-implemented method for maintaining a first geometric object in a database, comprising:
maintaining a first page storing a first data block in an on-disk store of the database, wherein the first data block stores at least one byte of the first geometric object;
processing a request for the first geometric object;
loading the first page from the on-disk store into an in-memory store of the database, thereby providing a copy of the first page in the in-memory store such that the copy of the first page stores a copy of the first data block comprising a copy of the geometric object;
determining a size of the first geometric object based on the copy of the first data block; and
storing the copy of the first geometric object in the in-memory store directly or a heap of the in-memory store based on the size of the first geometric object.