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 |
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.
|