Database Background Synchronization via Snapshot Metadata
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In mobile computing environments, data synchronization between remote systems and centralized databases is resource-intensive and often requires restrictive access, diminishing performance and efficiency due to the lack of concurrent transactional access during synchronization operations.
Innovation Solution
Implementing a background synchronization process using metadata to allow transactional access while synchronizing data, employing a 'snapshot' of data with row state metadata to identify changes and manage upload states, enabling efficient data integrity maintenance without restricting access.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data synchronization is performed between remote systems and consolidated database, then data integrity is maintained, but concurrent transactional access is restricted and performance diminishes
Solution Approach 1:
The patent segments the database into multiple snapshots (first snapshot, second snapshot) that can be accessed concurrently. Each snapshot represents a consistent state of the database at a specific point in time, allowing multiple transactions to proceed simultaneously without interfering with each other or with the synchronization process.
Solution Approach 2:
The patent creates snapshots of the database before synchronization operations begin. These pre-created snapshots serve as read-only copies that can be accessed during synchronization, eliminating the need to restrict access to the current database state and enabling concurrent transactions to proceed without waiting for synchronization to complete.
2Productivity
If background synchronization is implemented using snapshots and metadata, then concurrent access is enabled, but system complexity increases
Solution Approach 1:
The patent introduces metadata as an intermediary layer between the snapshots and the application layer. This metadata layer manages the complexity of snapshot management, version tracking, and synchronization state by providing a standardized interface, thereby isolating the complexity from the rest of the system and making the concurrent access mechanism more manageable.
Solution Approach 2:
The patent uses copies of the database (snapshots) instead of directly accessing the live database during synchronization. These copies are created and maintained with the help of metadata, which tracks their state and validity. This copying approach enables concurrent access while the metadata management system handles the complexity of maintaining multiple versions.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
Systems, methods and computer program products for maintaining data integrity in a database environment are described. In operation, a synchronization process is initiated in a remote database system for synchronization of remote data from the remote database system with consolidated data of a consolidated database. Metadata for each row of the remote data is utilized to allow transactional access to the remote data while the synchronization process occurs.