OLAP Resource Governor for Query Access Control
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current OLAP systems face inefficiencies in processing queries and report requests, leading to poor response times and resource overload due to unlimited user access and handling of large or incorrectly formatted queries, which affects all users.
Innovation Solution
Implementing a system with governors that manage access and resource utilization by setting limiting values at different levels (user, project, server) to control the number of jobs, sessions, and queries, allowing only partial processing when resources are overwhelmed, and queuing requests until resources are available.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If unlimited user access is allowed to the OLAP system, then system versatility and user availability are improved, but system resource overload and response time degradation occur
Solution Approach 1:
The patent implements dynamic resource allocation by allowing the OLAP system to adjust resource allocation based on current system load and user needs. The system monitors resource utilization and dynamically grants or denies access to individual users or groups, ensuring that system responsiveness is maintained while maximizing user availability when resources are abundant.
Solution Approach 2:
The system changes operational parameters by adjusting resource allocation limits, queue priorities, and access thresholds based on system conditions. Administrators can modify parameters such as maximum concurrent users, resource quotas per user, and queue depth limits to optimize the balance between user availability and system performance under different load conditions.
2Adaptability or versatility
If all queries are processed without limitation, then system completeness and data availability are improved, but system resource exhaustion and performance degradation occur
Solution Approach 1:
The system implements partial processing by allowing queries to be executed up to certain resource thresholds and then queued or denied when limits are reached. This ensures that critical queries are processed completely while less urgent queries are handled partially or deferred, preventing total system shutdown while maintaining resource availability for high-priority operations.
Solution Approach 2:
The patent introduces a resource management intermediary layer that sits between query submission and execution. This intermediary monitors resource consumption, enforces quotas, manages queues, and makes decisions about query prioritization and scheduling, thereby mediating between unlimited query capability and finite system resources.
3Adaptability or versatility
If large or incorrectly formatted queries are accepted, then system robustness and user flexibility are improved, but processing time increase and system efficiency decrease
Solution Approach 1:
The system performs preliminary validation and formatting checks on queries before they are submitted to the OLAP engine. By pre-processing queries to verify syntax, format, and resource requirements, the system rejects or corrects malformed queries early, preventing them from consuming excessive processing resources and improving overall query throughput and efficiency.
Data Source
AI summary
A technique for limiting access to the resources of a system is disclosed. In one embodiment, wherein the system has a server for processing requests, and wherein the server supports a plurality of projects, the technique includes receiving a request to access the resources of the system. The request is denied based upon an application level and a setting level, wherein the application level is associated with one of a plurality of functional layers within the system that is affected by the request, and wherein the setting level is a limiting value associated with one of the server alone and the server with one or more of the plurality of projects. The limiting value limits an operation on one of the plurality of functional layers, thereby limiting access to the resources of the system.