US 12,277,135 B2
Publishing to a data warehouse
Andrew Blom, Cambridge, MA (US); Darren Miller, Westford, MA (US); and Marshall A. Isman, Newton, MA (US)
Assigned to Ab Initio Technology LLC, Lexington, MA (US)
Filed by Ab Initio Technology LLC, Lexington, MA (US)
Filed on Oct. 23, 2023, as Appl. No. 18/492,425.
Application 18/492,425 is a continuation of application No. 16/517,320, filed on Jul. 19, 2019, granted, now 11,893,036.
Claims priority of provisional application 62/700,684, filed on Jul. 19, 2018.
Prior Publication US 2024/0104113 A1, Mar. 28, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 7/00 (2006.01); G06F 8/34 (2018.01); G06F 16/25 (2019.01); G06F 16/901 (2019.01); G06F 17/00 (2019.01); H04L 67/565 (2022.01)
CPC G06F 16/254 (2019.01) [G06F 8/34 (2013.01); G06F 16/258 (2019.01); G06F 16/9024 (2019.01); H04L 67/565 (2022.05)] 20 Claims
OG exemplary drawing
 
1. A method for automatically generating an executable application to transform and load data into a data store, the method, comprising:
receiving at least one metadata file that specifies one or more logical rules for mapping a source field of a data record to a target field and transforming the data record into transformed data for storing in the data store;
validating that the one or more logical rules are not inconsistent for transforming the data record;
generating, based on the validating, data rules that specify one or more standards for storing the transformed data in the data store in accordance with the one or more logical rules; and
generating, based on the data rules that specify the one or more standards, an executable data processing application for a runtime environment, the executable data processing application configurable to:
receive source data comprising a data record from one or more data sources;
determine, based on the one or more logical rules in the metadata file, (i) a source field of the data record that includes at least one source key value of the data record and (ii) a format for at least one transformed key value in a target field of the transformed data in the data store; and
transform the source data into the transformed data, the at least one source key value of the source field being transformed to have the format of the at least one transformed key value of the target field.