Data Synchronization via Mapping Engine and Continuous Monitoring
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional data processing applications are not designed to handle complex data relationships and synchronization with underlying data-management systems, leading to difficulties in flexible data exchange and timely reflection of data changes between graphical user interfaces and datasets.
Innovation Solution
A data-synchronization solution that integrates a data-processing application with a data-management system, enabling flexible data exchange and synchronization through data queries, version management, and dependency tracking, ensuring that changes made in a graphical user interface are automatically updated in the underlying data stores and vice versa.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If conventional applications are used for data processing, then the applications can display and manipulate data, but the applications cannot flexibly retrieve data from multiple datasets or automatically synchronize data changes with the underlying data-management system
Solution Approach 1:
The patent introduces a data mapping engine as an intermediary component that sits between the graphical user interface and the data store. This engine automatically maps data entries in the spreadsheet to corresponding data items in the data store, enabling flexible data exchange without requiring complex user-configured synchronization logic. The mapping engine handles the complexity internally while presenting a simple interface to users.
Solution Approach 2:
The system implements automatic detection and synchronization of data changes without requiring user intervention. When data in the underlying data-management system changes, the data processing application automatically detects these changes through monitoring mechanisms and updates the corresponding data entries in the graphical user interface. Similarly, user modifications in the interface are automatically propagated to the data store, making the synchronization process self-service rather than manual.
2Speed
If data changes are made in the underlying data-management system, then the data store is updated, but the graphical user interface does not reflect these changes in a timely manner
Solution Approach 1:
The patent implements continuous monitoring of data items in the underlying data-management system. The data processing application maintains an ongoing connection to the data store and automatically detects changes as they occur. This continuous monitoring ensures that data changes are reflected in the graphical user interface in real-time or near-real-time, eliminating delays and keeping the interface continuously synchronized with the underlying data.
Solution Approach 2:
The system establishes a feedback loop between the data store and the graphical user interface through the data mapping engine. When data changes occur in the underlying system, the monitoring mechanism detects these changes and automatically triggers updates to the corresponding data entries in the interface. This feedback mechanism ensures timely propagation of data changes without requiring manual refresh operations.
3Ease of operation
If manual synchronization operations are implemented, then data can be updated between the application and data store, but the synchronization process becomes complicated and requires extensive user actions
Solution Approach 1:
The patent makes the synchronization process entirely self-service by implementing automatic change detection and propagation mechanisms. The data mapping engine continuously monitors both the graphical user interface and the data store, automatically detecting changes in either direction and propagating them without requiring any user actions. This eliminates the need for manual synchronization operations while maintaining data consistency.
Solution Approach 2:
The patent extracts the synchronization complexity from the user's task by implementing an automated background process. The data mapping engine operates independently in the background, handling all synchronization operations without user involvement. This separates the complex synchronization logic from the user's workflow, making the interface simple to use while maintaining robust data consistency in the background.
Data Source
AI summary
Methods, systems, and apparatus, including computer programs encoded on computer storage media for data synchronization are provided. One of the methods includes: receiving, from a client device displaying a spreadsheet interface, a query for data; identifying, from one or more datasets in a data store, a plurality of data items responsive to the query; sending, to the client device, a plurality of data entries for display in a plurality of cells of the spreadsheet interface, wherein the data entries correspond to the identified data items; receiving, from the client device, information associated with one or more changes to one or more of the data entries, wherein the one or more changes are created based on one or more user inputs in the spreadsheet interface; and updating, in the data store based on the one or more changes, one or more of the data items corresponding to the one or more changed data entries.