18062842. OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES simplified abstract (International Business Machines Corporation)
Contents
- 1 OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Key Features and Innovation
- 1.6 Potential Applications
- 1.7 Problems Solved
- 1.8 Benefits
- 1.9 Commercial Applications
- 1.10 Prior Art
- 1.11 Frequently Updated Research
- 1.12 Questions about Database Query Analysis
- 1.13 Original Abstract Submitted
OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES
Organization Name
International Business Machines Corporation
Inventor(s)
OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES - A simplified explanation of the abstract
This abstract first appeared for US patent application 18062842 titled 'OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES
Simplified Explanation
The patent application describes a method, computer program product, and computer system that capture query activities from monitored databases, persist them into a graph-enabled database repository, classify them based on correlations, analyze components of query execution time, and identify problematic queries.
Key Features and Innovation
- Capturing query activities from monitored databases
- Persisting query activities into a graph-enabled database repository
- Classifying query activities based on correlations
- Analyzing components of query execution time
- Identifying problematic queries
Potential Applications
This technology can be applied in database management, performance optimization, and query troubleshooting in various industries such as finance, healthcare, and e-commerce.
Problems Solved
- Efficiently managing and analyzing query activities
- Identifying and addressing problematic queries
- Improving database performance and response times
Benefits
- Enhanced database performance
- Improved query troubleshooting
- Increased efficiency in database management
Commercial Applications
- Database management software for businesses
- Performance optimization tools for IT companies
- Query analysis services for database administrators
Prior Art
Further research can be conducted in the field of database query optimization and performance analysis to explore existing technologies and solutions related to this innovation.
Frequently Updated Research
Stay updated on advancements in database management, query optimization, and performance analysis to leverage the latest technologies and methodologies in this field.
Questions about Database Query Analysis
How does this technology improve database performance?
This technology improves database performance by efficiently managing and analyzing query activities, identifying problematic queries, and optimizing query execution times.
What industries can benefit from this database query analysis technology?
Industries such as finance, healthcare, and e-commerce can benefit from this technology by improving database performance, troubleshooting queries, and enhancing overall efficiency in database management.
Original Abstract Submitted
Method, computer program product, and computer system are provided. A plurality of query activities are captured from one or more monitored databases. The query activities are persisted into a graph-enabled database repository. The plurality of query activities are classified into a plurality of workload rules based on there being a correlations between the plurality of query activities. A plurality of components of a total execution time of each query in a workload rule is analyzed. One or more problematic queries is identified based on the analyzing.