Selective Data Import System Preserving Customizations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data transfer methods between mobile computing devices and central databases often result in the overwrite or deletion of customized data on mobile devices during updates, posing challenges for users and software vendors who need to manage delta changes and customizations.
Innovation Solution
A system that allows users to selectively copy delta changes from a source database to a target database by generating an export data file, displaying user interfaces for selection, and propagating changes across various computing environments, including development, test, and production landscapes, while preserving customizations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is copied from source database to target database using traditional update methods, then data synchronization is improved, but user customizations are lost
Solution Approach 1:
The patent extracts user customizations from the target database before the update process, stores them separately, and then restores them after the update. This separation allows the update to proceed without losing customizations, resolving the contradiction between data synchronization and preservation of user modifications.
Solution Approach 2:
The patent performs preliminary actions by backing up customizations before the update and restoring them after the update completes. This preliminary preservation ensures that synchronization can occur without permanent loss of user customizations, as they are restored in the post-update phase.
2Loss of information
If selective copying with user interface is implemented, then preservation of customizations is improved, but data transfer time is increased
Solution Approach 1:
The patent segments the data transfer process into distinct phases: extraction of customizations, execution of update, and restoration of customizations. This segmentation allows automated processing of each phase, reducing the need for manual user interaction while still preserving customizations, thus mitigating the time loss.
Solution Approach 2:
The system performs self-service by automatically managing the backup and restoration of customizations without requiring continuous user intervention. The user interface is used only for critical decisions, while the system handles the time-consuming backup and restoration operations autonomously.
3Manufacturing precision
If complete database updates are performed, then data accuracy is improved, but operational continuity is disrupted
Solution Approach 1:
The patent applies partial action by updating only the necessary portions of the database while preserving existing customizations. Instead of performing a complete overwrite, the system selectively applies updates, reducing the overall update duration while maintaining data accuracy for the updated elements.
Data Source
AI summary
A system is disclosed that allows users of computing devices to control the copying of business information between computing systems and various computing environments. The system includes a method for accessing at least one data element from a source database of a source system. The at least one data element may represent a delta change in data existing in a first collection of data stored in the source database. The method includes copying the at least one data element to an export data file and transporting the export data file to a target system. Once transported, the method further includes displaying a user interface on the target system that identifies ones of the at least one data elements that exist in a second collection of data stored in the target database, prompting user selection of desired ones of the at least one data element to be copied in the target database, and copying selected one of the at least one data element to the target database in response to the prompt.