Database Synchronization Sharing Rule Compliance
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data synchronization methods between database systems and client applications often fail to efficiently manage data access and visibility, especially when sharing rules change, leading to outdated or irrelevant data being stored on user devices, which can burden devices with unnecessary data and impact performance.
Innovation Solution
The implementation of enhanced synchronization protocols that allow for real-time compliance with sharing rules by enabling enhanced synchronization for specific objects, which involves querying the database system for updated IDs and removing obsolete data from client databases, ensuring only relevant data is stored and accessed according to the latest sharing rules.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If regular synchronization is performed to update data in client database, then data completeness is improved, but devices store outdated or irrelevant data that burdens storage and impacts performance
Solution Approach 1:
The patent extracts only the necessary data objects from the database system to the client database based on sharing rules. The enhanced synchronization protocol queries for updated object IDs and selectively downloads only those objects that users are authorized to access, removing obsolete data that is no longer relevant. This extraction principle ensures data completeness for authorized objects while eliminating unnecessary data storage.
Solution Approach 2:
The patent applies local quality by making the client database content adaptive to each user's specific authorization level. Sharing rules determine which data objects are relevant to which users, and the enhanced synchronization protocol ensures each user's client database contains only locally relevant data objects. This resolves the contradiction by tailoring data storage to individual user needs rather than uniformly storing all data.
2Reliability
If enhanced synchronization is performed to query updated object IDs and remove obsolete data, then data relevance is improved, but synchronization process complexity increases
Solution Approach 1:
The patent segments the synchronization process into two distinct protocols: regular synchronization for general data updates and enhanced synchronization for managing sharing rule compliance. The enhanced protocol is further segmented into specific steps: querying for updated object IDs, comparing with existing client database objects, and selectively removing obsolete objects. This segmentation makes the complex process more manageable and implementable.
Solution Approach 2:
The patent introduces an intermediary mechanism in the form of object ID querying and comparison. Instead of directly comparing entire data sets, the system uses object IDs as intermediaries to identify which data objects need to be updated or removed. This intermediary approach simplifies the synchronization process by reducing complex data comparison to simple ID matching, thereby managing process complexity while ensuring data relevance.
3Ease of operation
If client database stores subset of data for offline operation, then accessibility is improved, but data accuracy and up-to-dateness deteriorate
Solution Approach 1:
The patent implements periodic action through scheduled synchronization operations. The client database is periodically synchronized with the database system whenever the computing device connects to the network. The enhanced synchronization protocol ensures that during each periodic sync, the latest sharing rules are applied and data accuracy is updated. This periodic refresh mechanism maintains offline accessibility while periodically correcting data accuracy.
Solution Approach 2:
The patent applies dynamics by making the client database content adaptive and changeable based on updated sharing rules. Rather than storing a static subset of data, the system dynamically adjusts the client database contents during synchronization to reflect current authorization levels. This dynamic approach ensures that offline data remains accurate with the latest sharing rule changes while maintaining accessibility.
Data Source
AI summary
Systems and methods for synchronizing data between a database system and its client applications are provided. After a regular synchronization, objects' records on a user computing device may be checked against a new sharing rule. Newly shared records may be synced down to the user computing device regardless of timestamps, and all records which the user no longer has access to may be removed from the user computing device. Consequently, data on the user computing device complies with the new sharing rule.