SYSTEMS AND METHODS FOR TRANSFORMATION OF REPORTING SCHEMA

• US 20190034189A1
• Filed: 10/01/2018
• Published: 01/31/2019
• Est. Priority Date: 08/03/2016
• Status: Active Grant

• Current Assignee: Smartshift Technologies, Inc.
• Original Assignee: Smartshift Technologies, Inc.
• Inventors: Gass, Albrecht, Faradouris, Nikolaos, Flach, Oliver, Hetges, Stefan
• Granted Patent: US 11,099,823 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 8/427 Parsing
• CPC Class Codes: G06F 8/443 Optimisation
• CPC Class Codes: G06F 8/65 Updates security arrangements therefor G06F21/57

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.

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;

generating a transformation script comprising an identification of an object of the source installation and a corresponding object of the target installation, different from the object of the source installation, and a join or association command, according to the generated mapping; and

modifying a schema of the application according to the transformation script, by a transformer executed by the processor of the client device, according to the generated mapping.

2. The method of claim 1, wherein determining that the first one or more objects are modified during transformation further comprises determining that a query of the application is associated with a pre-modified object of the first one or more objects.

3. The method of claim 1, wherein generating the mapping further comprises identifying an association between a first data source of the source installation and a second data source of the target installation.

4. The method of claim 3, wherein the first data source is one of a table, field, key, user interface input, variable, user interface screen, electronic data exchange, or function call response.

5. The method of claim 3, further comprising identifying an association between a third data source of the source installation and the second data source.

6. The method of claim 5, wherein modifying the schema of the application further comprises joining the first data source and third data source of the source installation.

7. The method of claim 3, wherein identifying the association between the first data source and the second data source further comprises identifying an element common to the first data source and second data source.

8. The method of claim 3, wherein identifying the association between the first data source and the second data source further comprises identifying a first field of the first data source associated with a second field of the second data source.

10. The method of claim 1, wherein 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.

21. The method of claim 1, wherein the object of the source installation comprises a data structure in a first data source, and the object of the target installation comprises a data structure in a different second data source.

9. (canceled) .

11. 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,

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, and

generate a transformation script comprising an identification of an object of the source installation and a corresponding object of the target installation, different from the object of the source installation, and a join or association command, according to the generated mapping; and

wherein the transformer is configured to;

modify a schema of the application according to the generated transformation script.

12. The system of claim 11, wherein the analyzer is further configured to determine that a query of the application is associated with a pre-modified object of the first one or more objects.

13. The system of claim 11, wherein the analyzer is further configured to identify an association between a first data source of the source installation and a second data source of the second installation.

14. The system of claim 13, wherein the first data source is one of a table, field, key, user interface input, variable, user interface screen, electronic data exchange, or function call response.

15. The system of claim 13, wherein the analyzer is further configured to identify an association between a third data source of the source installation and the second data source.

16. The system of claim 15, wherein the transformer is further configured to join the first data source and third data source of the source installation.

17. The system of claim 13, wherein the analyzer is further configured to identify an element common to the first data source and second data source.

18. The system of claim 13, wherein the analyzer is further configured to identify a first field of the first data source associated with a second field of the second data source.

20. The system of claim 11, wherein 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.

22. The method of claim 11, wherein the object of the source installation comprises a data structure in a first data source, and the object of the target installation comprises a data structure in a different second data source.

19. (canceled)