	US 12,321,348 B2
	Query-based isolator
Pedram Falsafi, Ottawa (CA); Sriprasadh Raghunathan, Ottawa (CA); and Prabhakar Regmi, Ottawa (CA)
Assigned to Kinaxis Inc., Ottawa (CA)
Filed by Kinaxis Inc., Ottawa (CA)
Filed on Sep. 21, 2022, as Appl. No. 17/949,541.
Application 17/949,541 is a continuation of application No. 16/595,973, filed on Oct. 8, 2019, granted, now 11,481,393.
Prior Publication US 2023/0018471 A1, Jan. 19, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01)

CPC G06F 16/24542 (2019.01) [G06F 16/22 (2019.01); G06F 16/2425 (2019.01); G06F 16/2455 (2019.01)]

6 Claims

1. A computer-implemented method comprising:

receiving, by a processor, a query and an expected result of the query obtained after executing the query on a database;

tracking, by the processor, records associated with the query, in response to the query;

identifying, by the processor, an initial set of linked records;

running, by the processor, the query on the initial set of linked records;

iteratively amending, by the processor, the initial set to a final set of linked records, wherein a result obtained by executing the query on the final set matches the expected result; and

extracting the final set into a new database;

wherein when amending the initial set to the final set, the method further comprises:

running, by the processor, the query on the initial set;

determining, by the processor, whether the result obtained by running the query on the initial set matches the expected result;

when the result does not match the expected result:

a) setting, by the processor, the initial set as a current set;

b) expanding, by the processor, the current set to an expanded set;

c) saving, by the processor, the expanded set;

d) when a further result obtained by running the query on the expanded set does not match the expected result, repeating, by the processor, step (b) and step (c); and

e) when the further result obtained by running the query on the expanded set matches the expected result, saving, by the processor, the expanded set as the final set; and

when the result obtained by running the query on the initial set matches the expected result:

f) setting, by the processor, the initial set as the current set;

g) reducing, by the processor, the current set to a reduced set;

h) saving, by the processor, the reduced set;

i) when a further result obtained by running the query on the reduced set matches the expected result, repeating, by the processor, step (g) and step (h); and

j) when the further result obtained by running the query on the reduced set does not match the expected result, saving, by the processor, the reduced set as the final set.