Multi-system Database Workload Management via Dynamic Routing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current workload management techniques fail to effectively manage unforeseen impacts and planned situations in computing systems, leading to inconsistent response times and inefficiencies in resource allocation across multiple systems, particularly in dynamic environments with diverse workloads and shared resources.
Innovation Solution
A computer-implemented method and system for managing multi-system workloads, which monitors and adjusts system resources across multiple systems to meet workload expectations, using closed-loop system management and dynamic query optimization to regulate response times and resource allocation, and employs SQL event interfaces to create and remove events that adjust system states.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If current workload management techniques are used, then system operation continues, but response times become inconsistent and resource allocation becomes inefficient across multiple systems
Solution Approach 1:
The patent implements closed-loop system management that continuously monitors system conditions and workload characteristics across multiple database systems, compares actual performance against target response times, and dynamically adjusts workload routing decisions based on this feedback to maintain consistent response times and optimize resource allocation
Solution Approach 2:
The system dynamically adjusts workload routing between multiple database systems based on real-time system conditions, workload characteristics, and performance targets, rather than using static routing rules, allowing the system to adapt to changing conditions and maintain optimal performance
2Productivity
If multiple database systems are used to handle diverse workloads, then system capacity increases, but managing unforeseen impacts and planned situations becomes difficult
Solution Approach 1:
The closed-loop management system continuously monitors system conditions across multiple database systems and dynamically adjusts workload routing in response to unforeseen events such as system failures, performance degradation, or unexpected workload spikes, enabling the system to adapt to planned and unplanned situations while maintaining capacity
Solution Approach 2:
The system automatically detects and responds to system conditions and workload changes without requiring manual intervention, using real-time monitoring and dynamic routing rules to self-adjust workload distribution across multiple database systems in response to various events
3Reliability
If dynamic workload adjustment is implemented, then response time consistency improves, but system complexity increases
Solution Approach 1:
The closed-loop system uses automated monitoring and control mechanisms that continuously adjust workload routing based on real-time feedback, reducing the need for manual system management while maintaining consistent response times across multiple database systems
Solution Approach 2:
The dynamic workload management system operates autonomously, automatically detecting system conditions and adjusting routing decisions without requiring complex manual configuration or intervention, thereby reducing operational complexity despite the dynamic nature of the system
Data Source
AI summary
A computer-implemented apparatus, method, and article of manufacture provide the ability to manage a plurality of database systems. A domain contains a plurality of database systems. A system event monitor, on each of the database systems, monitors the database systems' system conditions and operating environment events within the domain. A multi-system regulator manages the domain, communicates with the system event monitor, and creates a dynamic event on one of the database systems based on the system conditions and operating environment events. The dynamic event causes an adjustment to a state of the database system.