Database Access Throttling for Device Management Requests
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional device management systems face challenges in managing database loads when multiple devices attempt to access the database simultaneously, leading to increased load and potential performance issues.
Innovation Solution
A device management system that includes a request acceptance portion to set a restriction rate based on database load amounts, selectively permitting or denying access, and a load amount acquisition portion to accumulate sample loads for setting the restriction rate, along with devices randomly retransmitting connection requests after error notifications with varying standby times.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the device management system permits all access requests from devices to the database, then the system maintains high availability and responsiveness, but the database load increases significantly leading to performance degradation
Solution Approach 1:
The system applies partial access control by permitting only a portion of incoming connection requests based on the calculated restriction rate. When database load is high, the system selectively permits some requests while denying others, rather than allowing all requests. This partial action approach maintains system availability for critical operations while preventing overwhelming the database, thus resolving the contradiction between availability and performance.
2Productivity
If the system increases the restriction rate to reduce database load, then database performance is maintained, but system availability and responsiveness decrease
Solution Approach 1:
The restriction rate is dynamically adjusted based on real-time database load conditions rather than being fixed. The load amount acquisition portion continuously monitors database load, and the request acceptance portion adapts the restriction rate accordingly. When load is low, restriction is minimized to maintain availability; when load is high, restriction increases to protect performance. This dynamic adaptation resolves the contradiction by making the system responsive to actual conditions.
3Speed
If devices immediately retransmit connection requests after receiving error notifications, then system responsiveness is improved, but database load increases due to request storms
Solution Approach 1:
The system implements periodic action through randomized standby times before devices retransmit connection requests. Instead of immediate retransmission, devices wait for a randomly determined period before attempting to reconnect. This periodic approach with randomization prevents request storms while still maintaining reasonable responsiveness, as devices do not wait indefinitely but also do not flood the system with immediate retry requests.
Data Source
AI summary
A device management system includes a database and a request acceptance portion which accepts a connection request from a device. The connection request is a request for causing the request acceptance portion to execute access to the database. When the connection request is accepted from the device, the request acceptance portion sets a restriction rate according to a load amount of the database and selectively executes, by a ratio corresponding to the restriction rate, processing of permitting access to the database and processing of not permitting access to the database and notifying the device of an error.