Bulk Order System for Database Record Updates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Manual updates to large business-to-business transactional databases are labor-intensive, resource-consuming, and error-prone, leading to adverse impacts on businesses due to the need for individual changes to thousands or millions of records.
Innovation Solution
A method involving a bulk order system that allows for a plurality of action sets representing changes to assets and services across multiple accounts, with validation and execution processes to automate and validate changes, reducing manual labor and errors.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If manual updates are used to change database records, then changes can be made to individual records, but labor intensity and time consumption increase significantly
Solution Approach 1:
The bulk order is divided into multiple action sets, where each action set contains a plurality of actions that can be independently validated and executed. This segmentation allows the system to process large numbers of records in manageable chunks while maintaining the ability to make individual record changes through the action set structure.
Solution Approach 2:
The patent introduces a bulk order intermediary system that sits between the user and the database records. This intermediary processes changes in batches, validates actions against product constraints, and executes them systematically, thereby increasing productivity without losing the capability to make individual record modifications.
2Ease of manufacture
If manual entry of changes is performed, then data can be updated, but error likelihood increases
Solution Approach 1:
The system incorporates validation mechanisms that check each action set against product constraints before execution. This feedback loop ensures that only valid changes are applied to the database, significantly reducing errors while maintaining the ability to update data. The validation process provides immediate feedback on whether actions comply with product rules.
Solution Approach 2:
The bulk order system performs self-validation of action sets against product constraints without requiring manual verification. The system automatically checks whether actions obey product constraints and validates user names and associations, thereby improving data accuracy through automated error prevention.
3Productivity
If system resources are allocated for manual updates, then changes can be processed, but system availability decreases
Solution Approach 1:
The bulk order system processes changes in periodic batches rather than continuously tying up system resources. Action sets are validated and executed in discrete units, allowing the system to return to normal operation between bulk update cycles. This periodic processing maintains update capability while minimizing system downtime and preserving availability for other operations.
4Productivity
If bulk processing is implemented, then productivity increases, but validation complexity increases
Solution Approach 1:
The validation process is segmented into discrete steps: validating user names and their associations with accounts and services, then validating each action set against product constraints. This segmentation of the validation process makes the complex validation task manageable and systematic, enabling bulk processing without overwhelming complexity.
Data Source
AI summary
A method includes creating a bulk order. The bulk order includes a plurality of action sets. Each action set represents a set of changes to a plurality of assets, and the bulk order represents, for a plurality of accounts, a plurality of services and assets. The method also includes validating the bulk order. The validating includes verifying a validity of a user name, which includes a validity of an association between the user name and the account and a validity of an association between the user name and the service. The validating also includes verifying the action set obeys a constraint of the product. The method also includes submitting the bulk order for execution of the set of changes. The submitting includes preparing the action set, executing the set of changes and changing a status of the bulk orders header to indicate a completion of the bulk order.