Spreadsheet Queries Linked to Relational Database Calculations

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Spreadsheets become unmanageable with increasing data complexity, leading to performance issues and error identification challenges, while relational databases lack a user-friendly interface for data analysis.

Innovation Solution

A spreadsheet that integrates database queries in cells, allowing formulas to dynamically update based on spreadsheet data, enabling an arbitrarily deep hierarchy of calculations and queries.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If spreadsheets are used to store and analyze large amounts of data with complex relationships, then data analysis capability is improved, but system performance decreases and file size increases

Engineering Contradiction:

Improvedata analysis capabilityVSAvoidsystem performance

Core Design Contradiction:

Adaptability or versatilityVSProductivity

Solution Approach 1:

The patent divides the system into two separate components: a spreadsheet interface layer for user-friendly data analysis and a relational database layer for efficient data storage and retrieval. This segmentation allows each component to optimize for its specific function, preventing the spreadsheet from becoming unmanageable while maintaining high performance.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The patent introduces a database as an intermediary between the user and the data. Instead of storing all data directly in the spreadsheet, the database serves as a mediator that handles data storage, retrieval, and complex relationships, thereby maintaining spreadsheet performance while enabling advanced analysis capabilities.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Adaptability or versatility

If spreadsheets are used to store large amounts of data with complex relationships, then data analysis capability is improved, but file size increases

Engineering Contradiction:

Improvedata analysis capabilityVSAvoidfile size

Core Design Contradiction:

Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

The patent segments data storage from the spreadsheet by using a separate relational database. The database handles the bulk data storage efficiently, while the spreadsheet only contains necessary interface elements and calculations, significantly reducing the spreadsheet file size while maintaining comprehensive data analysis capability.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The database acts as an intermediary that stores the majority of data externally. This allows the spreadsheet to reference data through queries rather than storing all data locally, reducing the spreadsheet file size while preserving the ability to analyze large datasets.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Adaptability or versatility

If spreadsheets are used to store data with complex relationships, then data analysis capability is improved, but difficulty in identifying and fixing errors increases

Engineering Contradiction:

Improvedata analysis capabilityVSAvoiderror identification difficulty

Core Design Contradiction:

Adaptability or versatilityVSDifficulty of detecting and measuring

Solution Approach 1:

The database serves as an intermediary that enforces data integrity rules and relationships centrally. This mediator approach makes it easier to detect and fix errors by providing consistent data validation and relationship constraints, rather than requiring users to manually manage complex relationships in the spreadsheet.

Inventive Principle:

Principle #24Intermediary (Mediator)

4Productivity

If relational databases are used to store and access data efficiently, then data storage and access performance is improved, but ease of operation decreases

Engineering Contradiction:

Improvedata access performanceVSAvoiduser interface friendliness

Core Design Contradiction:

ProductivityVSEase of operation

Solution Approach 1:

The patent introduces the spreadsheet as an intermediary layer between the user and the database. This mediator provides the familiar spreadsheet interface for easy data entry and analysis, while automatically translating user operations into efficient database queries, thus maintaining both ease of operation and data access performance.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The spreadsheet interface is designed to be universal and multi-functional, handling data entry, analysis, visualization, and database interaction through a single user-friendly interface. This eliminates the need for users to learn separate database query languages while maintaining efficient data access through automated query processing.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS20260064665A1Spreadsheet with Dynamic Database Queries

Publication Date: 2026.03.05 CLEARFACTR INC

AI summary

A spreadsheet supports formulas in cells that trigger queries of a data source. The parameters for queries can include or depend on values in other cells in the spreadsheet. Thus, the precise query submitted to the data source is dynamic, being dependent on the data and formulas in the spreadsheet. Furthermore, on receiving the query results, they are added to cells in the spreadsheet, which can be parameters for other queries defined in other cells. Changing the value of a single cell can automatically trigger an update of an arbitrarily deep hierarchy of calculations that can include an arbitrary number of data source queries.