Reporting Schema Transformation for ERP Upgrade Compatibility
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Upgrading ERP systems with customized code and database schema is time-consuming and expensive due to incompatibilities between old and new versions, requiring extensive manual rewriting.
Innovation Solution
Automated systems and methods for transforming reporting and view database schema during system upgrades, using meta-models and transformation rules to adapt custom objects and interfaces to new versions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If manual rewriting of customized code and database schema is performed during system upgrade, then compatibility with new version is achieved, but time consumption and cost increase significantly
Solution Approach 1:
The system performs preliminary analysis of the source schema before upgrade, identifying all customized objects, tables, and fields that require transformation. This advance preparation enables automated mapping and transformation rule generation, eliminating the need for time-consuming manual rewriting during the actual upgrade process while ensuring compatibility with the target version.
Solution Approach 2:
The patent introduces an intermediary transformation system that acts as a mediator between the source schema and target schema. This intermediary automatically generates transformation rules and mapping relationships, converting customized code and database schema from the old version to the new version without requiring direct manual intervention, thus reducing both time and cost while maintaining compatibility.
2Reliability
If manual rewriting of customized code and database schema is performed during system upgrade, then compatibility with new version is achieved, but cost increases significantly
Solution Approach 1:
The transformation system performs self-service by automatically analyzing the source schema, generating transformation rules, and executing the conversion process without requiring extensive manual programming effort. The system autonomously handles the identification of customized objects, creation of mapping relationships, and application of transformation rules, significantly reducing the labor cost associated with manual rewriting while ensuring compatibility.
Solution Approach 2:
The patent creates a copied and adapted version of the source schema through automated transformation. Instead of manually rewriting each customized object, the system copies the structural information and metadata from the source, applies transformation rules to adapt it to the target version, and generates the corresponding code and database schema automatically, thereby reducing cost while maintaining compatibility.
3Adaptability or versatility
If extensive manual rewriting is performed during system upgrade, then custom objects are adapted to new version, but disruption to business operations increases
Solution Approach 1:
The system performs preliminary analysis and generates transformation rules before the actual upgrade execution. This advance preparation allows the transformation process to be applied systematically and efficiently during the upgrade, minimizing the duration of business disruption while ensuring that all custom objects are properly adapted to the new version.
Solution Approach 2:
The automated transformation system acts as an intermediary that handles the adaptation of custom objects in the background, enabling the upgrade process to proceed with minimal disruption to business operations. The intermediary manages the complex transformations automatically, reducing the time required and allowing business operations to continue with minimal interruption.
Data Source
AI summary
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.