Spreadsheet Model Data Set for Cloud Warehouse Query Simplification
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users face difficulties in constructing complex queries and retrieving data from cloud-based data warehouses due to varying presentations and configurations, leading to multiple different views of the same data, which complicates data access and organization.
Innovation Solution
A method and system for creating a model data set using a spreadsheet interface, where a reusable modeling layer is generated by creating a worksheet from a data source, generating metadata for the worksheet, and providing it as a data source for other worksheets, allowing users to perform analysis without altering the original data set.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If complex queries are constructed to retrieve and organize data from cloud-based data warehouses, then data retrieval capability is improved, but user difficulty and operation complexity increase
Solution Approach 1:
The patent creates a spreadsheet interface that copies and presents data from the data warehouse in a simplified format. Instead of requiring users to write complex SQL queries, the system generates a spreadsheet view that replicates the data structure and relationships, making data access intuitive and easy to understand while maintaining the underlying complexity of the data warehouse queries.
Solution Approach 2:
The spreadsheet interface acts as an intermediary layer between the user and the data warehouse. It translates complex database queries into simple spreadsheet operations, and vice versa, converting spreadsheet data manipulation into automated database queries. This mediator simplifies the interaction while maintaining full data retrieval capability.
2Adaptability or versatility
If multiple different views of the same data are created for different presentations and configurations, then data adaptability is improved, but system complexity and data organization difficulty increase
Solution Approach 1:
The patent segments the data presentation into a standardized spreadsheet format that can be independently configured. Each spreadsheet can be customized for different presentations and configurations without affecting the underlying data structure. This segmentation allows multiple views to be created by simply creating new spreadsheet files with different configurations, maintaining simplicity while achieving adaptability.
Solution Approach 2:
The spreadsheet interface provides a universal template that can serve multiple purposes - different data presentations, configurations, and analysis requirements can all be achieved within the same spreadsheet framework. The system generates a universal data structure that adapts to various presentation needs through configuration rather than requiring separate systems for each view.
Data Source
AI summary
Creating a model data set using a spreadsheet interface including generating the model data set using the spreadsheet interface and a first data source from a data warehouse, wherein the model data set is a reusable modeling layer comprising at least a portion of the first data source, and wherein generating the model data set comprises: creating a first worksheet using the spreadsheet interface and the first data source; receiving an indication that the first worksheet is a model data set; and generating model data set metadata for the first worksheet; and providing, as a second data source for a second worksheet, the model data set generated from the model data set metadata.