Database Synchronization via Update Frequency Detection
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In database management systems, integrating multiple databases with different update frequencies leads to inconsistencies due to time differences between old and new data versions, causing system malfunctions when setting system settings with integrated data.
Innovation Solution
A control program is implemented to identify the database with the highest update frequency and request data updates from other databases, ensuring that all data is synchronized based on the updates from the master database, thereby preventing inconsistencies.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If databases update configuration information at different transmission intervals, then each database maintains its own update frequency, but data inconsistencies occur in the integrated database
Solution Approach 1:
The management apparatus determines in advance which database should serve as the reference for integration by comparing update frequencies. The database with the highest update frequency is selected as the target database, and other databases are synchronized to match its update timing. This preliminary determination prevents data inconsistencies by establishing a unified update schedule before integration occurs.
Solution Approach 2:
The system dynamically adjusts the update timing of individual databases based on their respective update frequencies. Instead of using fixed update intervals, the management apparatus modifies the timing of data transmission from each database so that all updates are synchronized to the timing of the target database with the highest update frequency. This dynamic adjustment ensures data consistency while preserving the original update frequencies of source databases.
2Adaptability or versatility
If data is integrated from multiple databases with different update timings, then comprehensive system information is obtained, but mixed old and new data causes system malfunctions
Solution Approach 1:
The management apparatus performs preliminary determination of the target database by comparing update frequencies before integration. It identifies which database has the highest update frequency and designates it as the reference. This preliminary action ensures that all subsequent integrations use consistent timing, preventing the mixing of old and new data versions that would cause system malfunctions.
Solution Approach 2:
The management apparatus acts as an intermediary between multiple databases with different update frequencies and the integrated database. It receives data from source databases at their original frequencies, adjusts the timing of each data transmission based on the target database's update frequency, and coordinates the integration process. This intermediary role ensures that only data with consistent timing is integrated, maintaining system stability while preserving information completeness.
Data Source
AI summary
A computer-readable, non-transitory medium storing therein a control program that causes a management apparatus to execute an operation, the operation comprises specifying, from among a plurality of databases, a database with the highest frequency of update of target data to be integrated which is stored in the database, transmitting, in accordance with acquisition of update data from the specified database, to a database other than the specified database among the plurality of databases, a request to transmit information stored in the database other than the specified database to the management apparatus and updating the target data to be integrated on the basis of the information transmitted to the management apparatus by the database other than the specified database in accordance with the request.


