Network Switch Query Flow Control via Storage Monitoring
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In network environments, managing storage capacity in low resource storage tables is challenging, particularly when the rate of output storage exceeds the rate of deletion, leading to potential overflow and resource inefficiency.
Innovation Solution
A network device with a database that monitors the storage capacity of a low resource storage table and disables upstream entities from generating additional output when the capacity reaches a predetermined threshold, while increasing the read rate from the table to prevent overflow.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If the database continues to store output in the low resource storage table at the current rate, then the storage capacity utilization increases, but the storage table will overflow and cause resource inefficiency
Solution Approach 1:
The database monitors the storage capacity of the low resource storage table and uses this feedback information to dynamically control the standing query instance. When the storage capacity reaches a threshold, the database sends a signal to disable the SQI, preventing further output generation that would cause overflow. This closed-loop feedback mechanism ensures reliable storage management while maximizing capacity utilization.
Solution Approach 2:
The database establishes a predetermined storage capacity threshold in advance and monitors the storage table capacity continuously. By taking preliminary action to disable the standing query instance before the storage table becomes full, the system prevents overflow conditions rather than reacting after they occur. This proactive approach maintains system reliability while efficiently utilizing available storage resources.
2Reliability
If the standing query instance is disabled to prevent storage overflow, then storage reliability is maintained, but the productivity of data generation and consumption is reduced
Solution Approach 1:
The system dynamically adjusts the operation state of the standing query instance based on real-time storage capacity conditions. Rather than permanently disabling the SQI or running it at a fixed rate, the database monitors storage usage and controls the SQI's output generation accordingly. This dynamic control allows the system to maintain high productivity when storage is available while ensuring reliability when capacity is near exhaustion.
Solution Approach 2:
The database changes the operational parameters of the standing query instance by disabling it when storage capacity reaches a threshold. This parameter change (from enabled to disabled state) allows the system to balance productivity and reliability - the SQI operates at full productivity when storage is sufficient, and is temporarily disabled when storage capacity needs to be preserved, thus optimizing overall system performance.
3Reliability
If the read rate from the low resource storage table is increased to prevent overflow, then storage reliability improves, but the system complexity increases
Solution Approach 1:
The database performs self-service by autonomously monitoring its own storage capacity and automatically controlling the standing query instance without external intervention. The database manages its storage resources independently, detecting when capacity thresholds are reached and autonomously disabling the SQI to prevent overflow. This self-service approach improves reliability while avoiding the complexity of external control systems.
Data Source
AI summary
A network device includes a standing query instance (SQI) and a database. The SQI is programmed to generate an output stored in a low resource storage table of a database. The database is programmed to monitor a storage capacity of the low resource storage table based on at least, in part, the output stored in the low resource storage table; determine, based on the monitoring, when the storage capacity reaches a predetermined amount; and disable an upstream element in response to the determination.