US 11,789,715 B2
Systems and methods for transformation of reporting schema
Albrecht Gass, Fullerton, CA (US); Nikolaos Faradouris, Mannheim (DE); Oliver Flach, Leinfelden-Echterdingen (DE); and Stefan Hetges, Mannheim (DE)
Assigned to SMARTSHIFT TECHNOLOGIES, INC., Boston, MA (US)
Filed by smartShift Technologies, Inc., Boston, MA (US)
Filed on Aug. 23, 2021, as Appl. No. 17/408,693.
Application 17/408,693 is a continuation of application No. 16/148,973, filed on Oct. 1, 2018, granted, now 11,099,823.
Application 16/148,973 is a continuation of application No. 15/227,556, filed on Aug. 3, 2016, granted, now 10,089,103, issued on Oct. 2, 2018.
Prior Publication US 2022/0253298 A1, Aug. 11, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 8/65 (2018.01); G06F 8/41 (2018.01)
CPC G06F 8/65 (2013.01) [G06F 8/427 (2013.01); G06F 8/443 (2013.01)] 1 Claim
OG exemplary drawing
 
1. A method for automatically transforming reporting schema, comprising:
identifying, by an analyzer executed by a processor of a client device, an application of a source installation configured to process a first one or more objects of the source installation;
determining, by the analyzer, that the first one or more objects are modified during transformation of the source installation to a target installation;
generating, by the analyzer, a mapping between the first one or more objects of the source installation to a second one or more objects of the target installation, responsive to the determination, by:
identifying an element common to a first data source of the source installation and a second data source, different from the first data source, of the target installation, and
determining that the first data source should be mapped to the second data source responsive to the identification of the common element;
generating a transformation script comprising an identification of an object of the source installation and a corresponding object of the target installation and a join or association command, according to the generated mapping; and
modifying a schema of the application, by a transformer executed by the processor of the client device executing the transformation script, according to the generated mapping,
wherein:
the object of the source installation and the object of the target installation are different objects;
the object of the source installation comprises a field of a first table; and
the object of the target installation comprises a field of a different second table.