Data Integration System for Schema Translation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Enterprise data storage systems often consist of separate on-premises and online solutions with different schemas, making data sharing and consistency across interfaces and platforms difficult, leading to disparate data and inefficient storage.
Innovation Solution
An integration system that translates data between different schemas using mapping modules, allowing for the creation and maintenance of duplicate records across multiple data storage systems, and includes a machine-learning-based forecasting module for resource allocation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If separate on-premises and online data storage solutions are used with different schemas, then each system can be optimized for its specific interface and platform, but data sharing and consistency across systems becomes difficult
Solution Approach 1:
The patent introduces a data integration system as an intermediary component that sits between the on-premises data storage system and the online data storage system. This integration system translates data between different schemas and formats, enabling seamless data exchange while maintaining the independence and optimization of each individual system. The intermediary resolves the contradiction by allowing each system to retain its specialized schema while ensuring data consistency across systems through automated translation and synchronization.
2Adaptability or versatility
If separate data storage systems with different schemas are maintained, then data can be optimized for specific uses, but disparate data exists among systems and storage efficiency decreases
Solution Approach 1:
The patent implements a data replication strategy where the integration system creates translated copies of data across different storage systems. Instead of requiring data to physically move between systems, the integration system maintains synchronized copies in both on-premises and online environments, with each copy optimized for its specific schema. This copying approach eliminates data duplication waste while maintaining storage efficiency, as the system intelligently manages replication without requiring redundant full copies of all data.
3Ease of operation
If separate data storage systems are used, then each system can independently manage its data, but the need for duplicate data entry increases and user convenience decreases
Solution Approach 1:
The patent implements an automated data synchronization mechanism where the integration system performs self-service by automatically detecting changes in one system and propagating them to the other system without human intervention. When data is added, modified, or deleted in either the on-premises or online system, the integration system autonomously translates and synchronizes the changes to the corresponding system, eliminating the need for manual duplicate data entry while preserving independent data management capabilities.
4Adaptability or versatility
If multiple separate data storage systems are maintained, then system independence is preserved, but server workload increases and processing efficiency decreases
Solution Approach 1:
The patent segments the data management functionality by introducing a dedicated integration system that handles translation and synchronization tasks separately from the core on-premises and online data storage systems. This segmentation allows each system to focus on its primary function while the integration system专门 handles data exchange, reducing the server workload of individual systems. The integration system processes data translation requests efficiently using cached schema mappings and incremental synchronization, thereby improving overall productivity without compromising system independence.
Data Source
AI summary
An integrated electronic information system includes a first information storage system storing information in a first form, a second information storage storing information in a second form that is different from the first form, and an electronic integration system, in electronic communication with the first information storage system and the second information storage system. The electronic integration system is configured to receive an indication from the first information storage system of data that is newly-added to the first information storage system, receive the data from the first information storage system in the first form, and in response to the indication from the first information storage system, translate the data from the first form to the second form, and transmit the data in the second form to the second information storage system.