US 11,868,363 B2
Method and system for persisting data
Frank Thomas, Toronto (CA)
Assigned to Kinaxis Inc., Ottawa (CA)
Filed by Kinaxis Inc., Ottawa (CA)
Filed on Mar. 17, 2022, as Appl. No. 17/697,317.
Application 17/697,317 is a continuation of application No. 16/088,149, granted, now 11,308,115, previously published as PCT/CA2017/050330, filed on Mar. 14, 2017.
Claims priority of provisional application 62/307,889, filed on Mar. 14, 2016.
Prior Publication US 2022/0253453 A1, Aug. 11, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01); G06Q 10/06 (2023.01); G06Q 10/10 (2023.01); G06F 16/22 (2019.01); G06Q 10/067 (2023.01)
CPC G06F 16/254 (2019.01) [G06F 16/2228 (2019.01); G06F 16/25 (2019.01); G06Q 10/06 (2013.01); G06Q 10/067 (2013.01); G06Q 10/10 (2013.01)] 16 Claims
OG exemplary drawing
 
1. A method for persisting and reconciling one or more data sources on a computer system, the method comprising:
periodically extracting batch data from at least one primary data source,
transforming the batch data into a first format specified by a data schema for a database;
loading the transformed batch data into the database
continuously receiving real-time data from at least one secondary data source;
indexing the received real-time data to generate an index;
transforming the real-time data into the first format, wherein transforming the real-time data comprises discarding any real-time data that is available in the batch data;
loading the transformed real-time data into the database;
generating business intelligence reports comprising the real-time data in the index, the transformed real-time data in the database, the extracted batch data and the transformed batch data in the database; and
storing the real-time data by key-value in a distributed key-value store for subsequent integration into the database, wherein transforming the real-time data comprises transforming the real-time data stored in the distributed key-value store.