Database Synchronization via Update Frequency Detection

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improveupdate frequencyVSAvoiddata consistency
Core Design Contradiction:
ProductivityVSReliability

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.

Inventive Principle:
Principle #10Preliminary action

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.

Inventive Principle:
Principle #15Dynamics

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

Engineering Contradiction:
Improveinformation completenessVSAvoidsystem stability
Core Design Contradiction:
Adaptability or versatilityVSReliability

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.

Inventive Principle:
Principle #10Preliminary action

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.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS9075857B2Computer-readable non-transitory medium storing therein a control program, management apparatus, and information processing system
Publication Date: 2015.07.07 FUJITSU LTD
  • US9075857B2 patent drawing
  • US9075857B2 patent drawing
  • US9075857B2 patent drawing

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.