Systems and methods for transformation of reporting schema
First Claim
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, anddetermining 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.
2 Assignments
0 Petitions
Accused Products
Abstract
The present application is directed towards systems and methods for automatically transforming reporting and view database schema during upgrading of a system from a source installation to a target installation. An analyzer executed by a processor of a client device may identify an application of a source installation configured to process a first one or more objects of the source installation. The analyzer may determine that the first one or more objects are modified during upgrading or transformation of the source installation to a target installation. The analyzer may generate 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. A transformer executed by the processor of the client device may modify a schema of the application, according to the generated mapping.
-
Citations
13 Claims
-
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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system for automatically transforming reporting schema, comprising:
-
an analyzer client, in communication with a source system comprising a source installation and a target system comprising a target installation, comprising a processor executing an analyzer and a transformer; wherein the analyzer is configured to; identify an application of the source installation configured to process a first one or more objects of the source installation, determine that the first one or more objects are modified during transformation of the source installation to a target installation, and generate 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, and generate 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 wherein the transformer is configured to; execute the transformation script to modify a schema of the application according to the generated mapping; wherein the object of the source installation and the object of the target installation are different objects. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
Specification