Variant Master Table Parallel Insertion Handling
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing technologies face challenges in ensuring data uniqueness and efficiency when multiple processes update a variant master table in parallel, leading to potential deadlocks and reduced processing efficiency due to composite primary key constraint violations.
Innovation Solution
The implementation of a system with plural processors that read and encode variant information, where each processor attempts to insert unentered variant patterns into a variant master table with a composite primary key constraint set by the variant ID and pattern code columns, and reattempts insertion with updated codes to avoid violations, ensuring data uniqueness and parallel processing efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If multiple processors update the variant master table in parallel, then processing efficiency is improved, but composite primary key constraint violations occur leading to deadlocks
Solution Approach 1:
The system performs preliminary actions by having processors attempt insertions with generated codes before final commitment. When a constraint violation is detected, the system reattempts with updated codes from the variant master table, preventing deadlocks while maintaining parallel processing capability.
Solution Approach 2:
The system implements feedback mechanisms where processors monitor for composite primary key constraint violations and respond by reattempting insertions with corrected codes obtained from the variant master table, ensuring data uniqueness while maintaining high throughput.
2Reliability
If processors reattempt insertion with updated codes, then data uniqueness is maintained, but additional processing time is required
Solution Approach 1:
The system changes the code parameter in reattempted insertions by obtaining updated codes from the variant master table. This parameter change resolves constraint violations while minimizing time loss through efficient code retrieval and retry mechanisms.
3Stability of the object's composition
If processors encode variant information based on variant master table, then data consistency is improved, but complexity of handling constraint violations increases
Solution Approach 1:
The system implements self-service by having processors automatically detect constraint violations and reattempt insertions with updated codes without external intervention. This self-correcting mechanism maintains data consistency while managing complexity through automated retry logic.
Data Source
AI summary
A variant master table includes respective columns for variant ID, variant pattern, and pattern code. A composite primary key constraint for the variant master table is set by the columns for variant ID and pattern code. The respective processors reads variant information, verifies whether or not variant patterns for variant positions have been entered into the table, and for unentered variant patterns, attempts to insert a row of information into the table that includes the unentered variant pattern, a corresponding variant ID, and a pattern code allocated based on the variant master table. In cases in which the row of information violates a composite primary key constrain, the respective processor reattempts to insert an updated row of information in which the pattern code has been changed. The processors encode the variant information based on information entered into the variant master table.