Multi-tenant Database Resource Governance via Threshold Monitoring

The patent segments the database system into multiple independent database instances, each capable of processing queries independently. This segmentation allows the system to handle high query volumes by distributing load across instances while maintaining acceptable processing speeds within each instance, thus resolving the contradiction between system utilization and query processing speed.

The patent implements dynamic resource allocation where database instances can be activated or deactivated based on current workload demands. When concurrent access requirements are high, more instances are activated to handle the load; when demands are low, instances are deactivated to conserve resources. This dynamic approach allows the system to adapt to varying concurrent access needs while optimizing resource consumption.

The patent implements self-service mechanisms where database instances automatically monitor their own resource consumption and enforce their own access limits based on predefined policies. Each instance can independently determine whether to process incoming queries based on its current resource state, eliminating the need for complex centralized control mechanisms. This self-service approach controls resource consumption while keeping system complexity manageable.