US 11,734,295 B2
Parallel load operations for ETL with unified post-processing
Alexander Ocher, San Jose, CA (US); Sreenivasulu Gelle, San Ramon, CA (US); Richard Joe, San Jose, CA (US); Karoly Daxkobler, Budapest (HU); Maicon Trasel Loebens, Sao Leopoldo (BR); Reinhard Sudmeier, Heidelberg (DE); Manali Pise, Sunnyvale, CA (US); Anil Samudrala, Newark, CA (US); Zoltan Hajnal, Budapest (HU); and Yanlun Ma, Saratoga, CA (US)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jan. 26, 2022, as Appl. No. 17/585,282.
Application 17/585,282 is a continuation of application No. 17/000,032, filed on Aug. 21, 2020, granted, now 11,269,912.
Claims priority of provisional application 63/051,725, filed on Jul. 14, 2020.
Prior Publication US 2022/0147538 A1, May 12, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 17/00 (2019.01); G06F 16/25 (2019.01); G06F 16/23 (2019.01); G06F 16/28 (2019.01); G06F 9/54 (2006.01)
CPC G06F 16/254 (2019.01) [G06F 9/547 (2013.01); G06F 16/2386 (2019.01); G06F 16/256 (2019.01); G06F 16/258 (2019.01); G06F 16/283 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer implemented method of data processing, the method comprising:
generating, by an extract, transform, load (ETL) system, a single target system transaction having a single transaction identifier as part of performing an ETL operation;
generating, by the ETL system, a plurality of operating system (OS) processes, wherein the plurality of OS processes corresponds to a plurality of load operations of the ETL operation, wherein each of the plurality of load operations is associated with one target table of a plurality of target tables;
executing in parallel, by the ETL system, the plurality of OS processes, wherein each of the plurality of OS processes is associated with the single transaction identifier;
loading, by an online analytic processing (OLAP) system, each of the plurality of target tables according to configuration information for each of the plurality of load operations as a part of the single target system transaction in the OLAP system; and
communicating, by the OLAP system to the ETL system, a plurality of results of loading the plurality of target tables.