US 11,914,607 B2
Generic data staging and loading using enhanced metadata and associated method
Rubesh Mehta, Irving, TX (US)
Assigned to Blue Yonder Group, Inc., Scottsdale, AZ (US)
Filed by Blue Yonder Group, Inc., Scottsdale, AZ (US)
Filed on Aug. 19, 2019, as Appl. No. 16/544,323.
Application 16/544,323 is a continuation of application No. 12/056,555, filed on Mar. 27, 2008, granted, now 10,387,440.
Claims priority of provisional application 60/908,731, filed on Mar. 29, 2007.
Prior Publication US 2019/0370265 A1, Dec. 5, 2019
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) 20 Claims
OG exemplary drawing
 
1. A system to reduce data loading time from one or more source systems, minimize any effect on the one or more source systems during data loading, and correct any error in the data, comprising:
a computer system comprising a processor and a memory, the computer system configured to:
invoke batch data loading of data of one or more source systems into an unconstrained area of an input staging area to reduce data loading time from the one or more source systems and minimize any effect on the one or more source systems during data loading;
automatically select one or more staging and master interfaces based on metadata of the one or more source systems;
automatically select relational table structures based on semantic mapping metadata;
evaluate the data loaded into the input staging area by an error correction workflow;
move any error records into an error table;
correct any error records in the error table by a spooler within the error correction workflow;
load the data from the input staging area and corrected data from the error table into a master repository; and
load the data from the master repository into an output staging area.