Smart Mapping for Seamless Data Migration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Migrating multiple heterogeneous and distributed database systems to a common technology platform is disruptive, costly, and can disrupt data integrity and consistency, making it challenging for enterprises to provide continuous and meaningful information to customers.
Innovation Solution
The implementation of a data management system that uses smart mappings to selectively map global data records to either pre-migration or post-migration local data records, allowing for transparent data access and maintaining consistent views of data before and after migration, based on defined conditions and functions such as billing, orders, or repairs.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If data is migrated from heterogeneous distributed database systems to a common technology platform, then data consolidation and platform standardization are improved, but data integrity and consistency are compromised
Solution Approach 1:
The patent introduces a data integration subsystem as an intermediary layer between the common technology platform and multiple distributed database systems. This subsystem maintains mapping information that links global data records to their corresponding local data records across different database systems, allowing the platform to access consolidated data without forcing actual data migration, thus preserving data integrity while achieving platform standardization
Solution Approach 2:
The patent segments the data architecture into global data records at the platform level and local data records at the distributed database level. The mapping information is segmented to associate each global data record with specific local data records, allowing the system to maintain a unified view of data while respecting the boundaries and integrity of individual distributed database systems
2Device complexity
If data is migrated to a common technology platform, then system complexity is reduced, but customer access to consistent information is disrupted
Solution Approach 1:
The patent creates a copy or representation of local data records as global data records in the data integration subsystem. These global data records maintain the essential information and structure of the original local records, allowing customers to access consistent information through the common platform without actually migrating the underlying data, thus preventing information loss while reducing system complexity
3Adaptability or versatility
If data migration is performed, then platform consolidation is achieved, but time and expense are increased
Solution Approach 1:
The patent establishes mapping information in advance that defines the relationships between global and local data records before any data access operations. This preliminary action allows the system to be configured for platform consolidation upfront, and once the mapping is in place, data access can be redirected without time-consuming migration operations, thus achieving platform consolidation while minimizing migration time and expense
Data Source
AI summary
In one of many possible implementations, an exemplary system includes a plurality of data subsystems configured to store local data associated with an external party, the data subsystems configured to be maintained by an internal party. The system further includes a data integration subsystem configured to store global data and a defined mapping of the global data to the local data, the global data including a global data record mapped to a local data record having a first data schema type, recognize a migration event in the local data, the migration event including migration of the first schema type local data record to a second schema type local data record, and associate a smart mapping record with the global data record, the smart mapping record configured to selectively map the global data record to one of the first schema type local data record and the second schema type local data record.