Database Client Synchronization with Dynamic Task Time Limits
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for synchronizing clients accessing a database lead to substantial waiting times due to connection losses, causing unnecessary task cancellations and prolonged synchronization times, as they require all clients to wait until one client's task is completed or timed out, even if other clients' tasks could be finished sooner.
Innovation Solution
Implementing a method where clients are allowed to continue opening new tasks if their accumulated task time after a synchronization request does not exceed a defined maximum, allowing for individual or group-based maximum accumulated task times to prioritize clients and reduce waiting times without increasing task cancellations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a timeout period is used to wait for clients to complete their tasks during synchronization, then data consistency is maintained, but waiting times for clients increase substantially when one client loses connection
Solution Approach 1:
The patent introduces a dynamic evaluation mechanism that continuously monitors client task status and connection state. Instead of using a fixed timeout period, the system dynamically adjusts the synchronization waiting strategy based on real-time conditions, allowing clients to proceed when their tasks are complete while maintaining data consistency through continuous status checking
Solution Approach 2:
The patent segments the client population into different groups based on their task completion status and connection state. By treating clients differently according to their individual circumstances rather than applying a uniform timeout to all clients, the system reduces overall waiting time while maintaining synchronization reliability
2Loss of time
If the timeout period is reduced to decrease waiting time for clients, then waiting time is reduced, but the number of cancelled tasks increases
Solution Approach 1:
The patent implements a feedback mechanism that continuously monitors client task status and connection state. This feedback loop allows the system to make informed decisions about which clients can proceed with new tasks and which should wait, reducing unnecessary task cancellations while minimizing waiting time for clients whose tasks are already complete
Solution Approach 2:
The patent performs preliminary status checking of client tasks before allowing new task openings. By evaluating whether clients have already completed their tasks or are actively working on them, the system can prevent premature task cancellations and allow clients to proceed when appropriate, reducing both waiting time and cancellation rate
3Reliability
If all clients must wait until one client's task is completed during synchronization, then data consistency is ensured, but average waiting time for clients increases
Solution Approach 1:
The patent applies different waiting strategies to different clients based on their individual task status and connection state. Instead of requiring all clients to wait until the slowest client completes their task, the system allows clients with completed tasks to proceed immediately, while only requiring clients with active tasks to wait briefly, thus reducing average waiting time while maintaining data consistency
Data Source
AI summary
The invention relates to a method of synchronizing a plurality of clients accessing a database, each client executing a plurality of tasks on the database, wherein the method comprises for each of the clients the steps of accumulating the time of one or more tasks performed by the client after the issuance of a synchronization request and rejecting a request for the opening of a new task of the client, if the accumulated task time exceeds a maximum accumulated task time.