DBMS Query Execution Signatures for Duplicate Performance Issues
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Identifying and correcting database management system (DBMS) performance issues is resource-intensive, as a single issue may manifest in multiple use cases, increasing the workload for development teams.
Innovation Solution
A testing system utilizes performance data to generate a key operations graph and employs graph neural networks to identify equivalent performance issues across different queries, reducing the need for redundant analysis by identifying and correcting common underlying issues.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If development teams manually analyze performance issues in multiple use cases, then performance issues can be identified and corrected, but the workload and time consumption increase significantly
Solution Approach 1:
The patent creates a virtual replica (clone) of the DBMS system that mirrors the actual system's performance data and operations. This copy allows automated analysis of performance issues across multiple use cases without manually re-examining each case, thereby reducing time consumption while maintaining identification accuracy
Solution Approach 2:
The system automatically analyzes performance data from multiple use cases to identify equivalent performance issues without requiring manual intervention. The automated analysis process serves itself by detecting patterns and equivalents across different queries, eliminating the need for human teams to manually review each performance issue
2Measurement precision
If development teams manually analyze each performance issue separately, then detailed analysis can be performed, but human resource utilization becomes inefficient
Solution Approach 1:
The patent merges the analysis of multiple performance issues by identifying equivalents among them. Instead of analyzing each issue separately, the system combines equivalent issues into unified categories, allowing detailed analysis to be performed once per category rather than repeatedly for each individual issue, thereby improving human resource utilization
Solution Approach 2:
The virtual replica of the DBMS system stores and processes performance data from multiple use cases, enabling automated detailed analysis of performance patterns. This copy allows the system to maintain measurement precision through comprehensive data analysis while freeing human resources from repetitive manual analysis tasks
3Adaptability or versatility
If a testing system analyzes performance data from multiple queries, then equivalent performance issues can be identified, but the system complexity increases
Solution Approach 1:
The virtual replica system serves multiple functions: it stores performance data, executes queries, analyzes performance issues, and identifies equivalents across different use cases. This multi-functional approach consolidates what would otherwise require multiple separate systems into a single unified platform, managing complexity while enhancing versatility
Solution Approach 2:
The virtual replica acts as an intermediary between the actual DBMS system and the analysis process. It captures performance data from multiple queries and provides a standardized interface for analyzing equivalent performance issues, simplifying the overall system architecture by introducing a dedicated intermediary layer that handles complexity
Data Source
AI summary
Various examples are directed to systems and methods for testing a database management system. A testing system may execute a graph neural network using first performance data describing a plurality of operations executed by a database management system to implement a first query, based at least in part on the graph neural network output, generate first query execution signature data describing the execution of the first query at the database management system. The testing system may compare the first query execution signature data to second query execution signature data describing execution of a second query at the database management system.