Granted Patent B2

US 12,430,336 · App. 17/956,362 · Granted Sep 30, 2025

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

Assignee: Kinaxis Inc.

G06F16/24552G06F16/2282G06F16/24534

Abstract

Claims (56)

1. A computer-implemented method comprising:

opening, by a processor, a chart;

executing, by the processor, a chart query on the chart, the chart query having a target table, wherein executing the chart query comprises:

sending, by the processor, the chart query to a query engine;

executing, by the processor, the chart query; 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 a record that is external to an 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 chart 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 chart query for the external table comprises:

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

translating, by the processor, the chart query into Structured Query Language (SQL);

fetching, by the processor, one or more records from the external data source over an 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 chart;

execute, by the processor, a chart query on the chart, the chart query having a target table, wherein executing the chart query further configures the apparatus to:

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

execute, by the processor, the chart query; 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 a record that is external to an 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 chart 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 chart 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 chart query into Structured Query Language (SQL);

fetch, by the processor, one or more records from the external data source over an 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 chart;

execute, by the processor, a chart query on the chart, the chart query having a target table, wherein executing the chart query further comprises configuring the computer to:

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

execute, by the processor, the chart query; 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 a record that is external to an 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 chart comprising the loaded external data and the loaded data from the record 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 (API) 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 chart query for the external table comprises:

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

translate, by the processor, the chart query into Structured Query Language (SQL);

fetch, by the processor, one or more records from the external data source over an 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 (2)

Continuity (3)

References Cited (18)