Abstract: The present application is directed towards systems and methods for automatic retrofitting of customized code objects during transformation of a system from a source installation to a target installation. In many instances, new objects may be created or objects modified on an online or production system while a development system is being upgraded. Simply copying the upgraded development system to the production system when complete would delete these new objects or modifications. Accordingly, the modifications or new objects may need to be retrofitted, or propagated to the development system and upgraded or transformed for compatibility with the new software, prior to placing the system online.

Abstract: The present application is directed towards systems and methods for providing a heat map interface for analyzing and reporting transformation capabilities of a source installation to a target installation of an application. Characteristics of the source installation are displayed in an easy, intuitive interface, providing improved efficiency in analysis and planning. Furthermore, the interface is interactive, allowing an administrator or user to select and apply transformation dispositions to code objects grouped into regions and sub-regions, providing versatility and accuracy of configuration.

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.

Abstract: The present application is directed towards systems and methods for providing a heat map interface for analyzing and reporting transformation capabilities of a source installation to a target installation of an application. Characteristics of the source installation are displayed in an easy, intuitive interface, providing improved efficiency in analysis and planning. Furthermore, the interface is interactive, allowing an administrator or user to select and apply transformation dispositions to code objects grouped into regions and sub-regions, providing versatility and accuracy of configuration.

Abstract: The present application is directed towards systems and methods for identifying and grouping code objects into functional areas with boundaries crossed by entry points. An analysis agent may select a first functional area of a source installation of an application to be transformed to a target installation of the application from a plurality of functional areas of the source installation, each functional area comprising a plurality of associated code objects; and identify a first subset of the plurality of associated code objects of the first functional area having associations only to other code objects of the first functional area, and a second subset of the plurality of associated code objects of the first functional area having associations to code objects in additional functional areas, the second subset comprising entry points of the first functional area.

Abstract: The present application is directed towards systems and methods for cluster-based code analysis and transformation. Cluster-based analysis may group code objects based on their similarity across functional areas, such as where a code object is cloned in multiple areas (e.g. sort functions that are duplicated across areas, or reports or tables that are identical). In some implementations, objects may be grouped into clusters by type, or based on reading from or writing to a common table. In some implementations, clustering at different layers may be possible.

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

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 automatic retrofitting of customized code objects during transformation of a system from a source installation to a target installation. In many instances, new objects may be created or objects modified on an online or production system while a development system is being upgraded. Simply copying the upgraded development system to the production system when complete would delete these new objects or modifications. Accordingly, the modifications or new objects may need to be retrofitted, or propagated to the development system and upgraded or transformed for compatibility with the new software, prior to placing the system online.

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.

Abstract: The present application is directed towards systems and methods for automated analysis and transformation of databases and related applications and functions from a row-oriented syntax to a column-oriented syntax. An analyzer client executed by a processor of a client device may analyze a first database of a business management system comprising a plurality of arrays in a row-oriented syntax. A transformer executed by the processor may execute a first array of a second database having a column-oriented syntax. Iteratively, for each array of the plurality of arrays of the first database, the transformer may read an element at a first position of said array, and write the element to a next position of the first array of the second database.

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.

Abstract: The present application is directed towards systems and methods for applying one or more rules that transform objects of an application from a previous instance of the application. Customized functions, objects, databases, and code of the instance of the application may be analyzed by an application transformation tool to identify one or more objects that have been modified. The modified objects may be further analyzed to detect if they are permissibly alterable. The application transformation tool may determine whether each of the permissibly alterable objects reference a standard interface of the application. The application transformation tool may apply one or more rules that transform objects to those permissibly alterable objects that do not reference the standard interface of the application.

Abstract: The present application is directed towards systems and methods for dynamically creating a substitution template from a conditional pattern template to transform code objects from a source installation to a target installation. Variable tokens in a pattern template may be dynamically replaced with corresponding values from a source object, and conditional statements of the pattern template analyzed and dynamically applied to build a substitution template for creating a replacement object for the source object.

Abstract: The present application is directed towards systems and methods for analyzing and transforming an application from a source installation to a target installation. Customized functions, objects, databases, and code of the source installation may be analyzed in accordance with analysis rules to create a meta-model representative of the elements of the customized elements and their relationships with each other and objects of the source installation. Responsive to transformation rules, the meta-model may be modified to create a transformed meta-model representative of the elements and their relationships with each other and objects of the target installation. The transformations may then be applied to the customized functions, objects, databases, and code of the source installation to convert them into transformed functions, objects, databases, and code, compatible with the target installation.

Abstract: The present application is directed towards systems and methods for dynamically deploying an application transformation tool over a network for analyzing and transforming an application from a source installation to a target installation. By using a cloud service for application transformation, the system can provide both flexibility in deployment and advantages in parallel and concurrent processing and transformation of objects of the application.

Abstract: The present application is directed towards systems and methods for analyzing and transforming changes in customized code of an enterprise resource planning (ERP) application from a previous instance of transformation of the customized code of the ERP application. Customized functions, objects, databases, and code of the application may be analyzed to identify changes in application code from a previous instance of the application code. Changed code may be further analyzed to determine which portions violate a predetermined set of coding rules of the application. Portions that violate the predetermined set of coding rules may be enumerated by one of developer, time, or type of object. Transformation rules may be applied to the code that violates the predetermined coding rules to generate a transformed instance of the application that is in conformance with the coding rules.

Abstract: The present application is directed towards systems and methods for dynamically creating a substitution template from a conditional pattern template to transform code objects from a source installation to a target installation. Variable tokens in a pattern template may be dynamically replaced with corresponding values from a source object, and conditional statements of the pattern template analyzed and dynamically applied to build a substitution template for creating a replacement object for the source object.