Spreadsheet Change Transmission for Complete, Timely Updates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The challenge of online spreadsheets is that as data amounts increase, servers struggle to transmit data to clients in a timely and complete manner, leading to delays in data updates and reduced timeliness.
Innovation Solution
A data processing method that determines the first data amount of target table data for which a change occurs in the spreadsheet and sends it to the client using a data sending mode corresponding to this amount, employing push and pull strategies based on bandwidth availability and data splitting into batches.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the server transmits all spreadsheet data to the client, then data completeness is improved, but transmission delay increases
Solution Approach 1:
The patent divides spreadsheet data into different types (formulas, formats, values, comments) and transmits them selectively based on change detection. Only modified data segments are transmitted to the client, rather than the entire dataset, which reduces transmission delay while maintaining data completeness for changed portions.
Solution Approach 2:
The server extracts and transmits only the changed data portions (target table data) from the complete spreadsheet dataset. By separating changed data from unchanged data and transmitting only the necessary changes, the system achieves both data completeness for updates and reduced transmission delay.
2Speed
If the server transmits data frequently, then data timeliness is improved, but network bandwidth consumption increases
Solution Approach 1:
The system implements periodic change detection and selective transmission based on actual data modifications. Instead of continuous or fixed-interval transmissions, the server periodically checks for changes and transmits data only when modifications occur, achieving timely updates while minimizing unnecessary bandwidth consumption.
Solution Approach 2:
The transmission behavior changes based on the parameter of data modification status. When changes are detected, the system switches to transmission mode; when no changes occur, transmission is suspended. This dynamic parameter-based approach optimizes both timeliness and bandwidth usage.
3Productivity
If the server transmits only changed data portions, then transmission efficiency is improved, but data integrity may be compromised
Solution Approach 1:
The system employs feedback mechanisms where the client reports data changes back to the server, and the server confirms successful transmission of changed portions. This feedback loop ensures that selective transmission of changed data maintains data integrity by verifying each transmission cycle and tracking which data portions have been successfully updated.
Solution Approach 2:
The server performs preliminary change detection and identification of modified data portions before transmission. By pre-processing the data to identify exactly what needs to be transmitted and preparing the changed portions in advance, the system ensures both transmission efficiency and data integrity through careful pre-validation of change data.
Data Source
AI summary
The present disclosure relates to a data processing method for a spreadsheet, a medium, an electronic device and a program product, which relate to the field of computer technology. In the method, a first data amount of target table data for which a data change occurs in a spreadsheet is determined, and the target table data is sent to a client according to a data sending mode corresponding to the first data amount of the target table data, so that the client performs data update on the spreadsheet according to the target table data. In this way, the target table data can be sent to the client in different scenarios using different data sending modes, so as to ensure the reliable transmission of the table data between a server and the client, thereby ensuring the timeliness and integrity of the table data.