Workbook Manager Exploration Mode for Cloud Data Editing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users, especially those without advanced query skills, face difficulties in efficiently manipulating and editing large datasets stored in cloud-based data warehouses due to the complexity of constructing and issuing database queries.
Innovation Solution
A system and method for editing data sets via non-editable workbooks, where a workbook manager on a client computing system presents a workbook in exploration mode, allowing users to make edits to a data set from a cloud-based data warehouse without altering the original workbook, and applies these edits to the data set if authorized to do so, while ensuring the user lacks permission to commit changes to the workbook.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If users are granted authorization to edit data sets in cloud-based data warehouses, then data manipulation capability is improved, but the risk of unauthorized workbook modifications increases
Solution Approach 1:
The system segments authorization into two distinct types: data set editing permission and workbook commit permission. Users can be granted data set editing authorization without receiving workbook commit authorization, allowing them to manipulate data while preventing unauthorized workbook modifications. This segmentation resolves the contradiction by enabling data manipulation capability while maintaining workbook integrity through separate permission controls.
Solution Approach 2:
The workbook manager acts as an intermediary between users and the data warehouse system. It receives edit requests from users with data set editing authorization, validates their permissions, and applies edits to data sets without allowing workbook commits. This intermediary mechanism enables data manipulation while protecting workbook integrity through controlled permission enforcement.
2Measurement precision
If complex database queries are required to manipulate data, then data access precision is improved, but ease of operation deteriorates
Solution Approach 1:
The system uses workbooks as simplified copies or representations of complex data warehouse structures. Instead of requiring users to directly construct complex SQL queries, the workbook provides a user-friendly interface that mirrors the data structure, allowing users to manipulate data through intuitive operations while the system handles the complex query generation in the background.
Solution Approach 2:
The workbook manager serves as an intermediary that translates simple user actions performed through the workbook interface into complex database queries. Users interact with the simplified workbook interface for ease of operation, while the workbook manager automatically generates and executes the necessary complex queries to achieve precise data access and manipulation.
Data Source
AI summary
Editing data sets via non-editable workbooks including presenting, by a workbook manager on a client computing system, a workbook in an exploration mode that displays edits to the workbook without altering the workbook, wherein the workbook presents a data set from a cloud-based data warehouse; receiving, by the workbook manager via the workbook, a change to the workbook and an edit to the data set from a client account associated with the client computing system; determining, by the workbook manager, that the client account is authorized to edit the data set on the cloud-based data warehouse and that the client account lacks authorization to commit changes to the workbook; and applying, by the workbook manager, the edit to the data set in the cloud-based data warehouse.