Granted Patent B2

US 12,443,598 · App. 17/943,657 · Granted Oct 14, 2025

Inventors: Jian Wu (Ottawa, CA); Adrian Petrescu (Ottawa, CA); Yingbei Lu (Ottawa, CA); Hung Nguyen (Ottawa, CA); Harveer Singh (Ottawa, CA); Daniel Lee (Ottawa, CA)

Assignee: Kinaxis Inc.

G06F16/245G06F16/2282G06F16/283

Abstract

Claims (59)

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.

2. The computer-implemented method of claim 1 , wherein loading the external data from the external data source comprises:

using, by the processor, an Application Programming Interface (API) for accessing a database.

3. The computer-implemented method of claim 1 , wherein the external data source is at least one of a public cloud, an external system and an external disk.

4. The computer-implemented method of claim 1 , wherein executing the worksheet query for the external table comprises:

creating, by the processor, an instance of an external data source class;

translating, by the processor, the worksheet query into Structured Query Language (SQL):

fetching, by the processor, one or more records from the external data source over an Application Programming Interface (API) using SQL;

filtering, by the processor, results by applying one or more column search expressions; and

sending, by the processor, the results to an application server.

5. A computing apparatus comprising:

a processor; and

a memory storing instructions that, when executed by the processor, configure the apparatus to:

open, by the processor, a workbook;

execute, by the processor, a workbook query on the workbook, the workbook query having a target table, wherein when executing the workbook query, the apparatus is configured to:

open, by the processor, a worksheet from the workbook;

send, by the processor, a worksheet query to a query engine;

execute, by the processor, the worksheet query on the record that is external to the in-memory database; and

return, by the processor, one or more query results;

load, 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; and

load, 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

create, by the processor, a composite worksheet comprising the loaded external data and the loaded data from the record block.

6. The computing apparatus of claim 5 , wherein when loading the external data from the external data source, the apparatus is configured to:

use, by the processor, an Application Programming Interface for accessing a database.

7. The computing apparatus of claim 5 , wherein the external data source is at least one of a public cloud, an external system and an external disk.

8. The computing apparatus of claim 5 , wherein when executing the worksheet query for the external table, the apparatus is configured to:

create, by the processor, an instance of an external data source class;

translate, by the processor, the worksheet query into Structured Query Language (SQL):

fetch, by the processor, one or more records from the external data source over an Application Programming Interface (API) using SQL;

filter, by the processor, results by applying one or more column search expressions; and

send, by the processor, the results to an application server.

9. A non-transitory computer-readable storage medium, the computer-readable storage medium including instructions that when executed by a computer, cause the computer to:

open, by a processor, a workbook;

execute, by the processor, a workbook query on the workbook, the workbook query having a target table, wherein executing a workbook query further causes the computer to:

open, by the processor, a worksheet from the workbook;

send, by the processor, a worksheet query to a query engine;

execute, by the processor, the worksheet query on a record that is external to an in-memory database; and

return, by the processor, one or more query results;

load, 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;

load, 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

create, by the processor, a composite worksheet comprising the loaded external data and the loaded data from the data block.

10. The computer-readable storage medium of claim 9 , wherein loading the external data from the external data source comprises:

using, by the processor, an Application Programming Interface for accessing a database.

11. The computer-readable storage medium of claim 9 , wherein the external data source is at least one of a public cloud, an external system and an external disk.

12. The computer-readable storage medium of claim 9 , wherein executing the worksheet query for the external table comprises:

create, by the processor, an instance of an external data source class;

translate, by the processor, the worksheet query into Structured Query Language (SQL):

fetch, by the processor, one or more records from the external data source over an Application Programming Interface (API) using SQL;

filter, by the processor, results by applying one or more column search expressions; and

send, by the processor, the results to an application server.

Assignments (1)

Continuity (2)

References Cited (20)