Spreadsheet Data Synchronization via Social Network Server
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing spreadsheet sharing and collaboration tools face challenges in data consistency and updates, as users may not receive updated values if they lack the reference documents, leading to incomplete data display and synchronization issues across devices.
Innovation Solution
A computer-implemented social network platform that stores spreadsheet data in a database, allowing users to subscribe to and share spreadsheet cells with controlled access levels, and automatically propagates updates through a network of references, ensuring data consistency and synchronization across users.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If spreadsheet data is shared via local reference documents, then users can access the data on their local devices, but users cannot view or update data if they lack the reference documents
Solution Approach 1:
The patent introduces a server as an intermediary between users and spreadsheet data. Instead of users directly accessing local reference documents, the server stores master copies of spreadsheets and reference documents, mediating all access requests. This resolves the contradiction by ensuring data accessibility through the server while eliminating the need for users to manage complex local document versions.
Solution Approach 2:
The patent creates a centralized digital copy of spreadsheet data stored on the server. Rather than requiring users to possess physical or local digital copies of reference documents, the system maintains a master copy on the server that can be accessed by any authorized user at any time, simplifying document management while ensuring universal accessibility.
2Productivity
If spreadsheet documents are manually distributed to colleagues, then users can have local copies of the data, but updates cannot be propagated automatically to all users
Solution Approach 1:
The patent implements an automated feedback mechanism where the server continuously monitors spreadsheet data for changes. When updates occur, the system automatically notifies subscribed users and propagates the updated data without requiring manual intervention. This resolves the contradiction by enabling rapid data update propagation while eliminating the time loss associated with manual document distribution.
Solution Approach 2:
The system enables self-service data distribution through automated server-side processes. The server autonomously handles data updates, version control, and user notifications without requiring users to manually distribute or synchronize documents. This achieves high productivity in data updates while eliminating manual distribution time.
3Reliability
If reference documents are stored locally at each user's device, then users can access data without network dependency, but data consistency cannot be maintained across users
Solution Approach 1:
The server acts as a central intermediary that maintains the single source of truth for all spreadsheet data. All users access data through the server, which ensures that everyone receives identical, consistent information. This resolves the contradiction by guaranteeing data consistency through centralized control while the server automatically handles all synchronization operations, requiring no user effort.
4Reliability
If users subscribe to spreadsheet cells with access levels, then data security and control are improved, but system complexity increases
Solution Approach 1:
The server intermediary manages all access control operations centrally. Instead of each user device implementing complex access control logic, the server handles authentication, authorization, and permission management for all spreadsheet cells. This resolves the contradiction by ensuring robust data security through centralized control while simplifying the user interface and reducing system complexity at the client level.
Data Source
AI summary
A spreadsheet application platform facilitates accessing a spreadsheet stored using a spreadsheet database at a server computer. The spreadsheet application platform includes a computer-implemented social network, and a publisher may use the social network to publish a spreadsheet so that other users of the social network may subscribe to and access the spreadsheet's data. Further, a subscribed user may generate other spreadsheets that reference the publisher's spreadsheet via the application platform. When a stored value for a cell of the publisher's spreadsheet is updated at the spreadsheet database, the application platform may generate update requests for one or more target spreadsheet cells that reference the updated cell. An update request may indicate that a target cell is to be updated, and the application platform may process a plurality of update requests in parallel to update the stored values for a corresponding plurality of spreadsheet cells.