Automated Code Pushdown for ERP System Upgrades

Solution Overview

Problem

Upgrading ERP systems from a data-to-code paradigm to a code-to-data paradigm is complex and time-consuming, requiring significant manual rewriting of applications, especially when dealing with customized code and large datasets, leading to performance bottlenecks and high costs.

Innovation Solution

A system and method for automated analysis and transformation that moves customized code and business logic from the application layer to the database layer, optimizing performance by executing processing directly on the database server, reducing data transfer between layers and automating the pushdown of code through analysis and transformation of code objects.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If code is manually rewritten during ERP system upgrades, then compatibility with new versions is achieved, but time consumption and cost increase significantly

Engineering Contradiction:

ImprovecompatibilityVSAvoidupgrade time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The system enables self-service automated code pushdown where the transformation process is autonomously performed by the system itself. The code pushdown engine automatically analyzes, transforms, and migrates code from the data-to-code paradigm to the code-to-data paradigm without requiring manual intervention, thereby achieving compatibility while significantly reducing upgrade time and costs.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent replaces the manual mechanical process of code rewriting with an automated computational system. The code pushdown engine uses algorithms and automated analysis to transform code objects, substituting the manual mechanical rewriting process with an automated electronic transformation process that is both faster and more consistent.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Reliability

If code is manually rewritten during ERP system upgrades, then compatibility with new versions is achieved, but cost increases significantly

Engineering Contradiction:

ImprovecompatibilityVSAvoidupgrade cost

Core Design Contradiction:

ReliabilityVSEase of manufacture

Solution Approach 1:

The system enables self-service automated code pushdown where the transformation process is autonomously performed by the system itself. The code pushdown engine automatically analyzes, transforms, and migrates code from the data-to-code paradigm to the code-to-data paradigm without requiring manual intervention, thereby achieving compatibility while significantly reducing upgrade time and costs.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent replaces the manual mechanical process of code rewriting with an automated computational system. The code pushdown engine uses algorithms and automated analysis to transform code objects, substituting the manual mechanical rewriting process with an automated electronic transformation process that is both faster and more consistent.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

3Productivity

If data transfer between application layer and database layer is extensive, then data processing capability is maintained, but performance bottlenecks occur

Engineering Contradiction:

Improvedata processing capabilityVSAvoidprocessing speed

Core Design Contradiction:

ProductivityVSSpeed

Solution Approach 1:

The patent extracts code from the application layer and places it directly into the database layer through the code pushdown process. By taking out the processing logic from the application layer and embedding it within the database layer, the system eliminates the need for extensive data transfer between layers, thereby removing the performance bottleneck while maintaining data processing capability.

Inventive Principle:

Principle #2Taking out (Extraction)

Solution Approach 2:

The patent changes the dimensional architecture by moving code execution from the application layer dimension to the database layer dimension. This dimensional shift allows processing to occur where the data resides, eliminating the vertical data transfer bottleneck between layers and improving processing speed.

Inventive Principle:

Principle #17Another dimension (Dimensionality change)

Data Source

PatentUS10481884B2Systems and methods for dynamically replacing code objects for code pushdown

Publication Date: 2019.11.19 SMARTSHIFT TECHNOLOGIES INC

AI summary

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.