Web Spreadsheet Interaction with Large Data Sets
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 without overwhelming users or information providers with extensive programming requirements.
Innovation Solution
A system that separates data management from presentation, using a data server to communicate with a spreadsheet presentation sub-system, allowing users to interact with data via web pages, enabling bulk data operations, customizable reporting, and data analysis without requiring advanced presentation capabilities from the data server.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Manufacturing precision
If a data server provides advanced presentation capabilities directly, then data presentation quality improves, but device complexity increases
Solution Approach 1:
The system separates data management functions from presentation functions by introducing a dedicated spreadsheet presentation subsystem. This subsystem handles all advanced presentation capabilities (formatting, calculations, visualizations) while the data server focuses solely on data storage and retrieval, thereby improving presentation quality without increasing data server complexity.
Solution Approach 2:
A spreadsheet presentation subsystem acts as an intermediary between the data server and the user interface. This intermediary component receives data from the server, applies presentation logic and formatting, and renders the final output, thus decoupling presentation complexity from the data server while maintaining high presentation quality.
2Adaptability or versatility
If a system integrates data management and presentation capabilities, then functionality improves, but ease of operation deteriorates
Solution Approach 1:
The spreadsheet presentation subsystem provides universal presentation capabilities that can handle various data types and formats through a single unified interface. Users interact with familiar spreadsheet conventions regardless of the underlying data structure, making the system versatile while maintaining ease of operation through consistent interaction patterns.
Solution Approach 2:
The spreadsheet subsystem automatically handles complex presentation tasks such as data formatting, calculation display, and visual representation without requiring user intervention. The system self-adjusts presentation parameters based on the data being displayed, reducing the operational burden on users while maintaining advanced functionality.
3Productivity
If bulk data operations are implemented, then productivity improves, but device complexity increases
Solution Approach 1:
The spreadsheet presentation subsystem pre-processes and formats data before presentation, organizing large datasets into structured spreadsheets with appropriate formatting, calculations, and visualizations ready for user interaction. This preliminary organization enables efficient bulk operations by users without requiring the data server to implement complex batch processing capabilities.
Data Source
AI summary
A computer-implemented method for presenting data is disclosed. The method includes receiving at a data server sub-system, from a browser on a remote client computing system, a request for data stored in a central data store; retrieving the requested data from the central data store and providing data corresponding to the requested data to a spreadsheet presentation sub-system that is in communication with the data server sub-system and with the browser on the remote client computing system; and providing a document key to the browser on the remote client computing system so that the browser can request from the presentation sub-system a spreadsheet document that displays the data corresponding to the requested data.