Preauthorizing Database Transactions for ERP Bandwidth
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Enterprise resource planning (ERP) systems, particularly warehouse management systems (WMS), face challenges in managing network bandwidth and security due to high user traffic and exposure of sensitive data, leading to inefficiencies and cybersecurity risks.
Innovation Solution
Implementing a method for preauthorizing database transactions, which generates and stores transactions based on parameters and values, allowing for conditional commitment to a database at a later time, reducing network congestion and securing sensitive information by limiting exposure.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If the WMS services a large number of users simultaneously, then user coverage is improved, but network bandwidth utilization increases and system performance deteriorates
Solution Approach 1:
The system performs preliminary actions by pre-authorizing database transactions before actual commit operations. Transactions are validated and prepared in advance, storing only essential commit information. When actual commits are needed, the system retrieves pre-prepared transactions rather than processing full transactions in real-time, significantly reducing network bandwidth utilization and improving system performance during high-user periods.
2Ease of operation
If ERP systems are network accessible, then ease of operation is improved, but security risk increases due to exposure of sensitive data
Solution Approach 1:
The system extracts sensitive data from network-transmitted transactions by separating commit information from detailed transaction data. Only essential commit information is stored and transmitted over the network, while sensitive data remains in local databases. This extraction approach maintains network accessibility for ease of operation while minimizing security risks by reducing the exposure surface area for sensitive information.
3Adaptability or versatility
If the WMS handles seasonal traffic spikes, then user coverage is improved, but network congestion increases causing crashes and slow performance
Solution Approach 1:
The system performs preliminary actions by pre-authorizing and preparing database transactions during off-peak periods. Transactions are validated, authenticated, and reduced to compact commit information in advance. During seasonal traffic spikes, the system simply retrieves and executes these pre-prepared commits rather than processing full transactions, dramatically reducing network congestion and preventing system crashes while maintaining the ability to handle large numbers of users.
Data Source
AI summary
A system and method for committing preauthorized database transactions generates a preauthorized database transactions based on a received parameter and a parameter value. The method further includes storing the generated preauthorized database transaction in a temporary storage; accessing a reference database to determine a current value of the received parameter; determining that a current value of the received parameter matches the received parameter value; and committing the preauthorized database transaction to a database.