Dynamically Materialized Views for Sheet Data Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Developing and maintaining data management applications using conventional database systems can be costly and require specialized expertise, making it prohibitive for small teams or individuals, and traditional spreadsheet programs struggle with large data sets and complex relational associations.
Innovation Solution
A sheets-based data management service that supports dynamically materialized views and row links, allowing for easy creation and management of data sets in a web-of-sheets model, with automatic updates and real-time data synchronization across linked tables, eliminating the need for complex database modeling expertise.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional database systems are used for data management, then data processing capability and reliability are improved, but device complexity and ease of operation deteriorate
Solution Approach 1:
The patent introduces a spreadsheet application as an intermediary layer between the user and the underlying database system. The spreadsheet provides a familiar, easy-to-use interface while the system automatically handles complex database operations, SQL queries, and data relationships in the background. This mediator allows users to leverage database power without directly confronting its complexity.
Solution Approach 2:
The system creates a virtual copy of the database structure within the spreadsheet environment. It generates spreadsheet formulas and structures that mirror database relationships, allowing users to work with database data through spreadsheet operations. The system translates spreadsheet actions into database operations, providing a simplified interface that replicates database functionality.
2Reliability
If conventional database systems are used for data management, then data processing capability is improved, but ease of operation deteriorates
Solution Approach 1:
The spreadsheet application serves as an intermediary that translates user-friendly spreadsheet operations into database-specific queries and operations. Users interact with familiar spreadsheet interfaces rather than learning database-specific languages or complex data modeling concepts, significantly reducing the expertise barrier while maintaining access to robust data processing capabilities.
3Ease of operation
If traditional spreadsheet programs are used for managing large data sets, then ease of operation is improved, but productivity and reliability deteriorate
Solution Approach 1:
The patent merges the advantages of spreadsheet interfaces with the capabilities of database systems. It combines the ease-of-use, flexibility, and familiarity of spreadsheets with the performance, reliability, and scalability of databases, creating a hybrid system that delivers both user-friendliness and high performance for managing large data sets.
Solution Approach 2:
The system provides multi-functionality by enabling a single platform to handle both spreadsheet-like data manipulation tasks and database-level data processing requirements. It can perform simple calculations and formatting like spreadsheets while simultaneously executing complex queries, joins, and aggregations on large data sets like databases, serving multiple purposes within one unified environment.
4Ease of operation
If traditional spreadsheet programs are used for managing large data sets with relational associations, then ease of operation is improved, but reliability deteriorates
Solution Approach 1:
The system replaces manual spreadsheet operations with automated database processing for handling relational associations. Instead of requiring users to manually manage complex relationships through spreadsheet formulas and references, the system automatically executes database joins, relationships, and data integrity constraints in the background, ensuring reliable handling of complex relational data while maintaining spreadsheet simplicity.
Data Source
AI summary
A descriptor of a dynamically materialized view is stored. The descriptor includes a query to select a subset of cells from a data sheet, and a result of executing the query. In response to an update directed to the data sheet, the result stored in the descriptor is modified based on re-executing the query, and a notification is transmitted to an execution platform at which an application whose output depends on the dynamically materialized view runs.