Spreadsheet Server System for Online Data Tracking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current network-based systems for delivering electronic content face challenges in providing efficient access and manipulation of large data sets, particularly in structured data formats like spreadsheets, which require advanced presentation capabilities but often lack them, limiting user interaction and data management functionalities.
Innovation Solution
A system that separates data management from presentation, using a data server to communicate with a client device and a spreadsheet server to format and present data within a web page, allowing users to interact with data through embedded spreadsheets, enabling bulk data operations, customizable reporting, and data analysis without requiring extensive new programming.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If a data server system stores and manages large data sets, then data storage capacity and management efficiency are improved, but the system lacks advanced presentation capabilities and user interaction functionalities
Solution Approach 1:
The system is divided into two independent components: a data server system for storing and managing large data sets, and a spreadsheet server system for formatting and presenting data. This segmentation allows each component to specialize in its respective function, enabling the data server to handle large quantities of data while the spreadsheet server provides advanced presentation capabilities.
Solution Approach 2:
The spreadsheet server system acts as an intermediary between the data server system and the client device. It receives data from the data server, formats it into spreadsheet presentations with advanced capabilities, and delivers it to the client. This intermediary enables data manipulation and presentation functionalities that neither the data server nor the client would have alone.
2Ease of operation
If users directly access and manipulate large data sets through a web interface, then user interaction capability is improved, but system complexity and programming requirements increase
Solution Approach 1:
The spreadsheet server system provides universal spreadsheet functionality that can handle various data formats and operations. By using a standardized spreadsheet interface, users can interact with different types of data from the data server using the same tools and operations, reducing the need for custom programming while maintaining ease of operation.
Solution Approach 2:
The spreadsheet server serves as an intermediary that handles the complexity of data manipulation and formatting. It translates user interactions through the familiar spreadsheet interface into appropriate data operations, shielding users from system complexity while enabling powerful data manipulation capabilities.
3Adaptability or versatility
If a single system provides both data storage and presentation capabilities, then system integration is improved, but the system cannot provide specialized advanced presentation services
Solution Approach 1:
The system architecture is segmented into specialized components: the data server system focuses on storage and management, while the spreadsheet server system focuses on presentation and formatting. This segmentation allows the presentation layer to develop specialized advanced services without being constrained by storage requirements, while maintaining manageable system integration through defined interfaces.
Data Source
AI summary
A computer-implemented method for method for tracking changes in an internet-accessible document is disclosed. The method includes providing, with a presentation server system, data for producing a display of a document at a client computing device; receiving, at the presentation server system from a data server system, a timestamp that is sent by the data server system in response to an indication by a user of the client computing device to record changes to the document, wherein the timestamp indicates a time after which changes have been made to the document; and providing from the presentation server system to the data server system data indicating changes made to the document since a time corresponding to the timestamp.