US 12,443,598 B2
Transparent access to an external data source within a data server
Jian Wu, Ottawa (CA); Adrian Petrescu, Ottawa (CA); Yingbei Lu, Ottawa (CA); Hung Nguyen, Ottawa (CA); Harveer Singh, Ottawa (CA); and Daniel Lee, Ottawa (CA)
Assigned to Kinaxis Inc., Ottawa (CA)
Filed by Kinaxis Inc., Ottawa (CA)
Filed on Sep. 13, 2022, as Appl. No. 17/943,657.
Claims priority of provisional application 63/261,178, filed on Sep. 14, 2021.
Prior Publication US 2023/0077833 A1, Mar. 16, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01); G06F 16/245 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/245 (2019.01) [G06F 16/2282 (2019.01); G06F 16/283 (2019.01)] 12 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
opening, by a processor, a workbook;
executing, by the processor, a workbook query on the workbook, the workbook query having a target table, wherein executing the workbook query comprises:
opening, by the processor, a worksheet from the workbook;
sending, by the processor, a worksheet query to a query engine;
executing, by the processor, the worksheet query on a record that is external to an in-memory database and
returning, by the processor, one or more query results;
loading, by the processor and based on the one or more query results, external data from an external data source to the record that is external to the in-memory database, for a target table that is an external table;
loading, by the processor and based on the one or more query results, data from a record block stored in the in-memory database, for a target table that is a regular table; and
creating, by the processor, a composite worksheet comprising the loaded external data and the loaded data from the record block.