Database Active Monitoring via Plugin-Based Threshold Alerting
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database monitoring systems, such as Teradata's Viewpoint, lack specificity in functionality and are not designed to handle fine-grained criteria for monitoring and alerting, leading to inadequate management of database health and user sessions.
Innovation Solution
A code-based Java framework for database active monitoring that allows for customizable monitoring and alerting through plugin-based modules, enabling specific criteria to be set and automated actions to be taken when thresholds are breached, including aborting or modifying user sessions and queries, and providing continuous monitoring with machine learning-based thresholds.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a database monitoring system is designed to be user-friendly with limited functionality, then ease of operation is improved, but adaptability and versatility deteriorate
Solution Approach 1:
The monitoring system is segmented into independent plugin modules that can be selectively loaded and configured. Each plugin handles specific monitoring tasks (e.g., session monitoring, query monitoring, system monitoring), allowing the system to be extended with specific functionality while maintaining a simple core interface for users.
Solution Approach 2:
The system employs a universal plugin architecture that can accommodate multiple types of monitoring functions through a common framework. The same core monitoring engine can handle different monitoring scenarios (user sessions, queries, system resources) by loading appropriate plugins, making the system both user-friendly and highly adaptable.
2Measurement precision
If monitoring criteria are made specific and fine-grained, then measurement precision is improved, but device complexity increases
Solution Approach 1:
Complex monitoring requirements are segmented into individual plugins, each responsible for specific monitoring criteria. For example, session monitoring plugins handle user session parameters, while query monitoring plugins handle SQL statement analysis. This segmentation allows precise monitoring without overwhelming system complexity.
Solution Approach 2:
The plugin architecture acts as an intermediary layer between the simple user interface and the complex monitoring logic. Users interact with a simple configuration interface, while the plugin framework translates these into specific monitoring criteria and coordinates the complex interactions between different monitoring components.
3Productivity
If automated actions are implemented when thresholds are breached, then productivity is improved, but device complexity increases
Solution Approach 1:
The monitoring system implements self-service automation through predefined alert rules and automated responses. When monitoring parameters breach defined thresholds, the system automatically generates alerts and can trigger predefined actions without requiring manual intervention. This allows rapid response to issues while keeping the automation logic manageable through configuration files rather than complex programming.
Data Source
AI summary
System and methods for database active monitoring are disclosed. In one embodiment, in an information processing device comprising at least one computer processor, a method for database activity monitoring may include: (1) a database monitor monitoring data from a database system and a user session with the database system; (2) the database monitor comparing the monitored data to at least one threshold; (3) the database monitor executing an automated action in response to the monitored data breaching one of the thresholds; and (4) the database monitor initiating an alert based on the breached threshold.