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.

Abstract: The present application is directed towards systems and methods for automated analysis and transformation of applications and automated pushdown of code from application layer to database layer, or from a data-to-code to code-to-data paradigm, including analyzing and extracting application layer code, relocating to and restructuring the code for the database layer, optimizing the code for better performance at the database layer, and adding communication interconnections between other applications and the pushed down code.