Data Transfer Control Device for Heterogeneous Database Synchronization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems fail to provide a seamless transaction environment when data with different field definitions is transferred between databases, leading to session invalidation and rendering HTML file resources unusable, especially in customized WWW server environments.
Innovation Solution
A data transfer control device and method that issues a session key to synchronize inputs between databases with different field definitions, using a session management device, value transfer destination management, database management, and data request processing to ensure data is correctly transferred and updated between common data fields, avoiding the need for record format or table definition conversion.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is transferred between databases with different field definitions using conventional conversion methods, then data compatibility is improved, but the existing HTML file resources and application resources become unusable in customized WWW server environments
Solution Approach 1:
The patent introduces a data transfer control device as an intermediary between the input form and the back-end database. This mediator handles the data transfer without requiring conversion of the database structure or HTML resources, thus maintaining compatibility while enabling data exchange between databases with different field definitions
Solution Approach 2:
The system separates the data transfer control functionality into distinct components: session management device, value transfer destination management device, database management device, and data request processing device. This segmentation allows each component to handle specific aspects of data transfer independently, preserving the integrity of existing HTML resources while enabling cross-database compatibility
2Reliability
If record format or table definition conversion is performed to enable data transfer between databases, then data compatibility is improved, but the session is invalidated and transaction continuity is lost
Solution Approach 1:
The session management device performs preliminary actions by managing session state throughout the data transfer process. It ensures that the session remains valid from the initial form input through to the final database update, preventing session invalidation that would otherwise occur during format conversion operations
Solution Approach 2:
The data transfer control device provides universal functionality that works across databases with different field definitions without requiring database-specific conversion logic. This multi-functional approach maintains session validity by handling diverse data formats through a unified control mechanism
3Adaptability or versatility
If customized WWW servers are used for each user to maintain individual database structures, then system flexibility is improved, but data transfer between different databases becomes problematic
Solution Approach 1:
The data transfer control device serves as a universal intermediary that works with customized WWW servers and their individual database structures. It enables reliable data transfer between these heterogeneous databases without requiring changes to the customized server configurations or their respective field definitions
Data Source
AI summary
A data transfer control device issues a session key identifying an application running on a user terminal. Then the device specifies a first database as a transfer destination of data input into a common data field for the first and a second database and outputs the data to an application process together with a session key. The device then inputs the data in the common data field together with the session key from the application process and updates the first database. After that, the device retrieves and outputs the data requested by the application process from the updated first database.