Cloud Data Warehouse Usage Report Access via Management Module
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Modern businesses face difficulties in accessing and managing usage reports from cloud-based data warehouses due to complex queries and dissociation between user interactions and database activities, which complicates data access and security for administrators.
Innovation Solution
A management module maintains a metadata table with usage reports for multiple organizations, allowing administrators to access a filtered portion of the data based on their organization identifier, ensuring secure and relevant data access while preventing exposure to other organizations' data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If complex queries are used to access data from cloud-based data warehouses, then data retrieval capability is improved, but ease of operation deteriorates
Solution Approach 1:
The patent introduces a management module as an intermediary between users and the cloud-based data warehouse. This module provides a simplified interface that automatically generates and executes complex queries on behalf of users, eliminating the need for users to directly interact with complex SQL queries while maintaining efficient data retrieval capabilities
Solution Approach 2:
The management module enables self-service by automatically handling query generation, execution, and result retrieval. The system autonomously manages the complex interactions with the data warehouse, allowing users to access data through simple interfaces without needing to understand or write complex queries
2Ease of operation
If access to the complete metadata table is provided to administrators, then data accessibility is improved, but security deteriorates
Solution Approach 1:
The patent segments the metadata table by organization identifier, creating separate accessible portions for different organizations. The management module divides the complete metadata table into organization-specific segments, allowing administrators to access only their organization's data while maintaining overall system accessibility
Solution Approach 2:
The system implements local quality by providing different access rights to different portions of the metadata table based on organization boundaries. Each organization's administrator receives access rights tailored to their specific organization's data, ensuring appropriate access at the local level while maintaining global security
3Ease of operation
If a simplified interface is provided to reduce query complexity, then ease of operation is improved, but device complexity increases
Solution Approach 1:
The management module serves as a complexity-absorbing intermediary that handles the complex interactions with the data warehouse internally. The simplified user interface appears simple, but the management module underneath manages query generation, execution, error handling, and data retrieval, containing the complexity within the system rather than exposing it to users
Data Source
AI summary
Providing access to usage reports on a cloud-based data warehouse including maintaining, by a management module, a metadata table on the cloud-based data warehouse, wherein the metadata table comprises usage reports for a plurality of organizations; receiving, by the management module, a request for the metadata table from an administrator account for a first organization of the plurality of organizations; granting, by the management module, the administrator account permission to access a filtered portion of the metadata table, wherein the filtered portion of the metadata table is generated by filtering the metadata table by an organization identifier of the first organization; and providing, by the management module, the filtered portion of the metadata table to the administrator account.