Workbook Manager Live Edit Conflict Resolution
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Modern businesses face challenges in efficiently manipulating and editing large datasets stored in cloud-based data warehouses, as composing and issuing complex database queries often exceeds the capabilities of most users.
Innovation Solution
The implementation of a workbook manager system that allows for live editing of workbooks across multiple clients, involving the receipt of workbook patches, version ID matching, application of edits, advancement of version IDs, and acknowledgement of patches.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple clients edit the same workbook simultaneously, then real-time collaboration capability is improved, but conflict resolution complexity increases
Solution Approach 1:
The system performs preliminary version validation by checking if the base version ID in the workbook patch matches the current confirmed workbook version ID before applying edits. This preliminary check prevents conflicts from propagating through the system, resolving the contradiction by validating data integrity upfront rather than dealing with complex conflict resolution scenarios later.
2Reliability
If version ID validation is performed on the workbook manager, then data consistency is improved, but processing overhead increases
Solution Approach 1:
The system performs a partial validation check by only comparing version ID integers rather than performing comprehensive workbook content verification. This partial action approach maintains data consistency through essential version matching while minimizing processing overhead by avoiding exhaustive validation of all workbook elements.
Data Source
AI summary
Live editing a workbook with multiple clients including receiving, by a workbook manager from a first workbook client, a first workbook patch comprising a base version ID and a first workbook edit; determining, by the workbook manager, that the base version ID from the first workbook patch matches the version ID for a confirmed workbook on the workbook manager; applying, by the workbook manager, the first workbook edit to the confirmed workbook on the workbook manager; advancing, by the workbook manager, the version ID for the confirmed workbook; and sending, by the workbook manager, an acknowledgement of the first workbook patch to the first workbook client.