Database Update Device Selecting Partial or Full Refresh
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database updating methods are inefficient, particularly when dealing with large databases that require frequent updates, as they often disrupt data transmission functions and do not utilize the most appropriate updating method based on the database's state.
Innovation Solution
A device management system that determines the database state and selects between a first and second updating process, where the first process updates only unlocked fields and the second process updates the entire database using a high-speed communication protocol when no fields are locked, ensuring quick and efficient updates without disrupting data transmission.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If the entire database is updated by sending all updated data to the device, then the updating speed is improved, but data transmission functions may be disrupted when fields are locked
Solution Approach 1:
The system changes the updating method parameter based on the database state (locked or unlocked fields). When no fields are locked, it switches to the second updating process (entire database update) for speed. When fields are locked, it switches to the first updating process (partial update) to maintain reliability. This dynamic parameter adjustment resolves the contradiction between updating speed and data transmission reliability.
2Reliability
If only updated portions are sent to update unlocked fields, then data transmission function reliability is maintained, but the updating time increases
Solution Approach 1:
The system dynamically adjusts the updating process based on real-time database state information. It monitors whether fields are locked or unlocked and automatically selects the appropriate updating method (first or second process). This dynamic adaptation allows the system to optimize updating time when conditions permit (no locked fields) while maintaining reliability when necessary (locked fields present), resolving the time-reliability contradiction.
3Device complexity
If the updating method is fixed, then the system complexity is reduced, but the updating efficiency decreases when the database state changes
Solution Approach 1:
The updating process is segmented into two distinct methods (first and second updating processes) that can be selectively applied. The first process handles partial updates for unlocked fields, while the second process handles entire database updates when no fields are locked. This segmentation allows the system to maintain relatively simple individual processes while achieving high overall efficiency through intelligent selection, resolving the complexity-efficiency contradiction.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
Updating a database is accelerated. A device management device manages a device having a database, and includes: an acquisition unit configured to acquire database state information from the device; and an updating unit configured to send update data for updating the database to the device, and cause the device to update the database based on the update data. The updating unit selectively executes, based on the database state information, a first updating process of sequentially sending the updated portions of the update data to the device to change the updated portions of the database; or a second updating process of sending all of the update data to the device to refresh the complete database.