Transient Exploratory Editing of Data Warehouse Input Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users face challenges in efficiently manipulating and composing complex database queries for cloud-based data warehouses, as most users lack the skills to construct and issue such queries efficiently, and existing solutions do not provide a straightforward method for transient exploratory editing of input tables without altering the underlying data.
Innovation Solution
A system and method for transient exploratory editing of input tables in a cloud-based data warehouse, where a workbook manager presents an input table in exploration mode on a client computing system, allowing users to make changes without altering the original table, by modifying the presentation of the table and storing temporary changes for subsequent access.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users directly edit input tables in the cloud-based data warehouse, then data manipulation capability is improved, but data integrity and safety deteriorate
Solution Approach 1:
The patent introduces an exploration mode as an intermediary layer between users and the actual data warehouse tables. This mode allows users to edit and manipulate table data through a virtual interface without directly modifying the source tables in the cloud-based data warehouse. The workbook manager mediates all edit operations, enabling safe exploration while preserving data integrity in the underlying warehouse.
2Productivity
If complex database queries are required for data manipulation, then data access capability is improved, but user accessibility deteriorates
Solution Approach 1:
The patent creates a virtual copy of the input table in exploration mode that can be freely manipulated without affecting the original. This copying mechanism allows users to work with replicated data structures and perform complex operations on the copy while the original remains intact. The workbook manager handles the complexity of query construction and execution, making advanced data access capabilities available to users without requiring them to master complex query languages.
3Adaptability or versatility
If exploratory edits are allowed on input tables, then user interaction capability is improved, but system complexity deteriorates
Solution Approach 1:
The patent implements a dynamic exploration mode that can be activated and deactivated as needed. The workbook manager dynamically creates virtual table instances for exploration, applies user edits only within the exploration context, and manages the lifecycle of these temporary data structures. This dynamic approach allows flexible user interaction capabilities while containing system complexity within the exploration mode framework, preventing permanent complexity accumulation in the core data warehouse system.
Data Source
AI summary
Transient exploratory editing of input tables on a data warehouse including: presenting, on a client computing system by a workbook manager, an input table in a cloud-based data warehouse, wherein the input table is presented in an exploration mode that displays edits to the input table without altering the input table in the cloud-based data warehouse; receiving, by the workbook manager, a change to the input table; and modifying, by the workbook manager, a presentation of the input table reflecting the change without modifying the input table in the cloud-based data warehouse.