DBMS Tracking via Self-Reporting Agents
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional methods for tracking database management systems (DBMSs) are slow and error-prone, requiring manual data entry and failing to keep pace with DBMS relocations for load balancing and failover, leading to outdated information.
Innovation Solution
A DBMS tracking system that periodically receives server information from a directory service, installs agents on DBMSs to report their location and status, and updates a tracking table to monitor and manage DBMSs, enabling real-time tracking and automated actions such as relocation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If manual data entry is used to track DBMSs, then information accuracy can be maintained through human verification, but the tracking process becomes slow and labor-intensive
Solution Approach 1:
The DBMS instances automatically report their own location and status information to the tracking system through agents, eliminating the need for manual data entry while maintaining accuracy. The system serves itself by having DBMSs self-report their operational state, server location, and movement events.
Solution Approach 2:
The patent replaces the mechanical manual data entry process with an automated electronic reporting system. Agents installed on DBMS instances automatically transmit location and status data to the tracking system, substituting human manual input with automated software-based data collection.
2Loss of information
If manual tracking processes are used, then detailed information can be collected, but the information becomes outdated due to the time required to complete tracking
Solution Approach 1:
The tracking system operates continuously by having agents on DBMS instances constantly report their status and location. This continuous automated reporting ensures information remains current without the time delays inherent in manual periodic tracking, maintaining both completeness and timeliness.
Solution Approach 2:
The system implements feedback mechanisms where DBMS instances automatically notify the tracking system of any changes in location or status. This real-time feedback loop ensures the tracking information remains synchronized with actual DBMS positions, preventing information obsolescence.
3Speed
If automated tracking systems are implemented, then real-time monitoring is achieved, but system complexity increases
Solution Approach 1:
The tracking system is segmented into independent agents deployed on individual DBMS instances rather than a centralized complex monitoring system. Each agent independently reports its local DBMS status, distributing the tracking function and reducing overall system complexity while maintaining real-time capabilities.
Solution Approach 2:
The tracking agents are designed to be universal components that can monitor any DBMS instance regardless of specific configuration or location. This multi-functional agent design simplifies the system by using a single standardized component rather than specialized tracking mechanisms for different scenarios.
Data Source
AI summary
A database management system (DBMS) tracking system tracks location and status of DBMSs running on servers, for example, servers of an organization connected by a network. The DBMS tracking system periodically receives information describing servers from a directory service. The DBMS tracking system maintains a DBMS tracking table. The DBMS tracking system installs database agents on DBMSs. The database agents send tracking messages and status messages to the DBMS tracking system. The DBMS tracking system updates the information stored in the DBMS tracking table based on the tracking messages and status messages.