Editable Cloud Data Tables via Query Manager Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users of cloud-based data warehouses are unable to incorporate their own data into editable worksheets due to tight management controls, limiting their ability to modify database information.
Innovation Solution
A query manager system that receives a client-provided table, stores it in a schema storage location with write access, generates a database query to create a referencing worksheet using both the client-provided and database tables, and issues the query to the cloud-based data warehouse, allowing users to create editable tables by combining data from unalterable database sources with alterable client-provided data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If database administrators tightly manage changes to cloud-based data warehouses, then data security and integrity are improved, but user ability to incorporate own data into worksheets deteriorates
Solution Approach 1:
The patent segments the data storage structure by creating a separate schema storage location within the cloud-based data warehouse that is distinct from the main database tables. This segmentation allows users to store their own tables in the schema storage location while the main database tables remain protected, thus maintaining data security while enabling user adaptability.
Solution Approach 2:
The patent introduces an intermediary mechanism where the cloud-based data warehouse system acts as a mediator between the protected database tables and user-provided tables. The system generates queries that join these two separate data sources, allowing users to work with both types of data in worksheets without direct access to the protected database, thus resolving the contradiction between security and adaptability.
2Stability of the object's composition
If users are restricted from directly accessing database tables, then database integrity is improved, but user productivity in creating customized worksheets deteriorates
Solution Approach 1:
The patent implements a copying mechanism where user-provided tables are stored in the schema storage location of the cloud-based data warehouse. These copied tables can be freely accessed and modified by users for worksheet creation, while the original database tables remain protected. This copying approach enables user productivity without compromising database integrity.
Solution Approach 2:
The patent makes the schema storage location a universal storage space that serves multiple functions: it stores user-provided tables, allows user customization, and integrates with the protected database tables through query generation. This multi-functional schema storage location resolves the contradiction by providing a universal access point that doesn't require direct database access.
3Reliability
If the cloud-based data warehouse maintains strict access controls, then security is improved, but system functionality for editable tables deteriorates
Solution Approach 1:
The patent applies local quality by creating a schema storage location with different access control characteristics than the main database tables. The schema storage location has more permissive access controls that allow user writing and customization, while the main database tables maintain strict protective access controls. This localized difference in access quality enables editable table functionality without compromising overall system security.
Data Source
AI summary
Enabling editable tables on a cloud-based data warehouse including receiving, by a query manager, a client-provided table; receiving, by the query manager from a query manager client, a request to create a referencing worksheet using, as data sources, the client-provided table and a database table on a cloud-based data warehouse; storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access, and wherein the database table is external to the schema storage location; generating, by the query manager, a database query to create the referencing worksheet, wherein the database query targets the client-provided table in the schema storage location and the database table; and issuing, by the query manager, the database query to the cloud-based data warehouse.