US 11,669,539 B2
Virtual database tables with updatable logical table pointers
Ruediger Karl, Walbstadt (DE); Mihnea Andrei, Issy les Moulineaux (FR); Juchang Lee, Seoul (KR); Stefan Baeuerle, Rauenberg-Rotenberg (DE); Seyeong Bae, Seoul (KR); and Joo Yeon Lee, Seoul (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jan. 4, 2022, as Appl. No. 17/646,982.
Application 17/646,982 is a continuation of application No. 16/713,850, filed on Dec. 13, 2019, granted, now 11,321,344.
Claims priority of provisional application 62/903,459, filed on Sep. 20, 2019.
Prior Publication US 2022/0197922 A1, Jun. 23, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01); G06F 16/23 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/256 (2019.01) [G06F 16/214 (2019.01); G06F 16/2282 (2019.01); G06F 16/23 (2019.01); G06F 16/24552 (2019.01)] 60 Claims
OG exemplary drawing
 
1. A computing system comprising:
one or more memories;
one or more processing units coupled to the one or more memories; and
one or more computer readable storage media storing computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
creating a first table schema in a data dictionary of a database management system of a first computing system, the first table schema being a schema according to a first virtual table type, the first table schema comprising a first logical pointer usable to specify a location from which data for a table organized at least in part according to the first table schema is to be retrieved, wherein the first table schema is consistent with an organization of data specified by a second table schema;
assigning a first value to the first logical pointer, the first value indicating a first location comprising a first table organized according to the second table schema and comprising first data, the first location being a second computing system, the second computing system being a federated database system for the first computing system;
creating a second table in a cache of the first computing system, the second table corresponding to a first instance of the first table schema;
receiving at least a portion of the first data;
storing the at least a portion of the first data in the second table;
assigning a second value to the first logical pointer, the second value identifying a location in the cache of the second table;
creating a third table schema in the data dictionary, wherein the third table schema is not a schema for a virtual table;
creating a third table in the database management system, the third table being an instance of the third table schema; and
storing second data in the third table, wherein the second data is stored in non-cache storage of the database management system.