Collaborative Table Data Synchronization Using Citation References
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In collaborative tables with many formulas, the efficiency of data transmission and synchronization is low due to the large amount of data generated by atomic operations when users copy and paste formulas, leading to reduced efficiency in updating the table across clients.
Innovation Solution
A method where a first client acquires a data processing operation on a cell and generates atomic operation information including citation information, which is sent to a second client to update the collaboration table, reducing data amount and improving transmission and synchronization efficiency by using citation information to represent cell operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If users copy and paste formulas in collaborative tables containing a large number of formulas, then the same type of formulas can be calculated in batches, but the atomic operation will produce a large amount of data to describe the formula filled in the cell, causing low data transmission efficiency and low synchronization efficiency
Solution Approach 1:
The patent uses citation information (references) to represent cell operations instead of copying complete formula data. When a user copies a formula, the system generates atomic operation information containing citation information that references the source cell, rather than duplicating the entire formula content. This allows batch calculation while significantly reducing the data amount transmitted during synchronization.
2Loss of information
If atomic operation generates detailed data to describe formula filled in cell, then complete formula information is transmitted, but data transmission efficiency is reduced and synchronization efficiency is reduced
Solution Approach 1:
The patent introduces citation information as an intermediary element between the source cell and the target cell. Instead of transmitting complete formula data, the atomic operation information contains citation information that acts as a reference or pointer to the source cell. This intermediary mechanism preserves the ability to reconstruct complete formula information while dramatically reducing the amount of data that needs to be transmitted and processed during synchronization.
Data Source
AI summary
The present disclosure discloses a method, an apparatus, a device and a medium for processing collaborative table data. The method includes: when a first client uses a collaborative table, acquiring a first data processing operation of a user on a first cell and a second cell in the collaborative table, wherein the second cell is one or more cells to be processed; generating first atomic operation information based on the first data processing operation, wherein the first atomic operation information includes a second cell and citation information; sending the second cell and the citation information to the second client, so that the second client updates the collaboration table according to the second cell and the citation information.