US 12,292,884 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 May 24, 2024, as Appl. No. 18/674,387.
Application 18/216,218 is a division of application No. 16/890,020, filed on Jun. 2, 2020, granted, now 11,726,985, issued on Aug. 15, 2023.
Application 18/674,387 is a continuation of application No. 18/216,218, filed on Jun. 29, 2023, granted, now 12,019,622.
Claims priority of provisional application 62/858,693, filed on Jun. 7, 2019.
Prior Publication US 2024/0311371 A1, Sep. 19, 2024
Int. Cl. G06F 3/06 (2006.01); G06F 9/48 (2006.01); G06F 12/02 (2006.01); G06F 12/0875 (2016.01); G06F 12/0882 (2016.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2455 (2019.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:
one or more memories; and
at least one processor each coupled to at least one of the memories and configured to perform operations comprising:
storing a geometric object on one or more pages of an on-disk store of the database system, wherein the one or more pages are a part of a chain of pages stored in the on-disk store sequentially;
receiving a request for the geometric object; and
loading the requested geometric object from the on-disk store to an in-memory store comprising one or more pages of the in-memory store and a user record table including a vector of user records, a user record providing a location of the requested geometric object, the one or more pages of the in-memory store including a copy of the requested geometric object.