Workbook Manager API Column Automation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Modern businesses face challenges in efficiently manipulating and querying large datasets stored in cloud-based data warehouses, as composing and issuing database queries is often beyond the capabilities of most users.
Innovation Solution
The method involves a workbook manager on a client computing system that presents a table, receives a request to create a new column populated by API values from an API provider, receives these API values, and updates the table to include the new column and values.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users directly manipulate and query data in cloud-based data warehouses using database statement languages, then data access and manipulation capabilities are achieved, but the complexity of constructing and issuing queries exceeds most users' abilities
Solution Approach 1:
The patent introduces an intermediary layer between the user and the cloud-based data warehouse. This intermediary automatically generates and executes database queries based on user-friendly inputs, shielding users from the complexity of SQL or other database statement languages while still enabling efficient data access and manipulation.
Solution Approach 2:
The system enables self-service data manipulation by providing automated query generation and execution capabilities. Users can perform complex data operations through simplified interfaces without needing to manually construct queries, allowing the system to serve itself by automatically handling the complexity of database interactions.
2Measurement precision
If complex database queries are composed and issued manually, then precise data retrieval is achieved, but the time and effort required exceed most users' capabilities
Solution Approach 1:
The system performs preliminary actions by pre-configuring query templates, data transformation rules, and execution workflows. When a user initiates a data retrieval operation, the system has already prepared the necessary query structures and can quickly generate precise queries without requiring users to spend time on manual composition.
Solution Approach 2:
The automated query generation system allows users to obtain precise data retrieval results through self-service interfaces. The system automatically handles the time-consuming aspects of query composition and optimization, delivering precise results without requiring users to invest significant time in query construction.
Data Source
Figure 1
Figure 2
Figure 3
AI summary
Creating a table column using application program interfaces including: presenting, on a client computing system by a workbook manager, a table; receiving, by the workbook manager, a request to create a new column for the table populated by application program interface (API) values from a API provider and based on one or more basis columns of the table; receiving, by the workbook manager, the API values from the API provider; and updating, by the workbook manager, the table to include the new column and the API values.