International business machines corporation (20240193151). OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES simplified abstract
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 Potential Applications
- 1.5 Problems Solved
- 1.6 Benefits
- 1.7 Commercial Applications
- 1.8 Prior Art
- 1.9 Frequently Updated Research
- 1.10 Questions about the Technology
- 1.11 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 20240193151 titled 'OPTIMIZING PERFORMANCE OF COMPLEX TRANSACTIONS ACROSS DATABASES
The patent application describes a method, computer program product, and computer system for capturing query activities from monitored databases, persisting them into a graph-enabled database repository, classifying them based on correlations, analyzing components of total execution time, and identifying problematic queries.
- The technology captures query activities from monitored databases.
- Query activities are stored in a graph-enabled database repository.
- Activities are classified based on correlations between them.
- Components of total execution time for each query are analyzed.
- Problematic queries are identified based on the analysis.
Potential Applications
This technology can be applied in database management systems, data analytics, and performance optimization in various industries such as finance, healthcare, and e-commerce.
Problems Solved
This technology addresses issues related to query performance, database optimization, and workload management in complex database environments.
Benefits
- Improved query performance and database optimization.
- Enhanced workload management and resource allocation.
- Identification and resolution of problematic queries.
- Increased efficiency and productivity in database operations.
Commercial Applications
Optimizing database performance and workload management can lead to cost savings, improved customer satisfaction, and competitive advantages in the market. Industries such as finance, healthcare, and e-commerce can benefit from this technology.
Prior Art
Prior research in database management, query optimization, and workload analysis can provide valuable insights into the development and implementation of this technology.
Frequently Updated Research
Stay updated on the latest advancements in database management, query optimization, and workload analysis to enhance the effectiveness and efficiency of this technology.
Questions about the Technology
How does this technology improve query performance in database management systems?
This technology enhances query performance by analyzing and optimizing query activities based on correlations and total execution time components.
What industries can benefit the most from this technology?
Industries such as finance, healthcare, and e-commerce can benefit significantly from this technology by improving database performance and workload 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.