Cloud Workbook Execution for Easier Data Warehouse Analysis
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Modern businesses face challenges in efficiently manipulating and composing complex database queries within cloud-based data warehouses due to the limitations of most users in constructing and issuing such queries.
Innovation Solution
A workbook manager system that receives analysis code from a client computing system, executes it on a cloud-based data warehouse, and presents the analysis output within a workbook on the client system, allowing users to manipulate and visualize data through graphical elements and interactive tools.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users directly construct and issue complex database queries to access data in cloud-based data warehouses, then data access capability is improved, but user skill requirements increase and ease of operation deteriorates
Solution Approach 1:
The patent introduces a workbook manager as an intermediary component between the user interface and the data warehouse. This workbook manager receives analysis code from the client, executes it against the data warehouse, and returns results. This intermediary layer allows users to interact with complex data warehouse operations through simplified workbook interfaces without needing to directly construct complex SQL queries, thus improving ease of operation while maintaining access to sophisticated data manipulation capabilities
Solution Approach 2:
The system enables self-service data analysis by allowing users to work with pre-configured workbooks that contain embedded analysis code and data access logic. Users can interact with data through these workbooks without needing to manually construct queries or understand complex data warehouse operations. The workbook manager handles the complexity of query construction and execution automatically, making data access as simple as interacting with prepared workbook interfaces
2Ease of operation
If complex queries are composed and issued to manipulate data in the data warehouse, then data manipulation capability is improved, but user ability requirements increase and ease of operation deteriorates
Solution Approach 1:
The workbook manager serves as an intermediary that handles the complexity of query composition and execution. Users interact with simplified workbook interfaces rather than directly composing complex queries. The workbook manager translates user interactions into appropriate data warehouse queries, executes them, and returns results, thereby enabling complex data manipulation without requiring users to understand or construct complex queries
Solution Approach 2:
The system segments the complex task of data manipulation into simpler components through workbooks. Each workbook represents a discrete, pre-configured analysis task or data access pattern. Users can work with individual workbooks or combine them through the workbook manager, breaking down complex data manipulation into manageable, pre-packaged units that are easier to use while maintaining the capability to perform sophisticated operations
Data Source
AI summary
Executing workbook code within a cloud-based data warehouse including receiving, by a workbook manager from a client computing system, analysis code via a workbook presented on the client computing system, wherein the analysis code references data on a cloud-based data warehouse; executing, by the workbook manager, the analysis code on the cloud-based data warehouse using the referenced data to generate analysis output; and presenting, by the workbook manager, the analysis output within the workbook on the client computing system.