PROGRESS ANALYZER FOR DATABASE QUERIES

• US 20100235349A1
• Filed: 03/10/2009
• Published: 09/16/2010
• Est. Priority Date: 03/10/2009
• Status: Active Grant

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Inventors: Krompass, Stefan, Dayal, Umeshwar, Kuno, Harumi, Wiener, Janet L.
• Granted Patent: US 9,934,261 B2
• Time in Patent Office: Days
• US Class Current: 707/718
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

A data processing system includes a query progress analyzer. The database processing system comprises a receiver that receives database queries including a target query directed to a database and a query analyzer. The query analyzer is coupled to the receiver and analyzes progress status of the target query based on comparison of measured target query resource usage to resource usage predicted from a query plan of the target query and measured system resource usage.

Claims

1. A database processing system comprising:

a receiver that receives database queries including a target query directed to a database; and

a query analyzer coupled to the receiver that analyzes progress status of the target query based on comparison of measured target query resource usage to resource usage predicted from a query plan of the target query and measured system resource usage.

2. The system according to claim 1 further comprising:

the query analyzer that analyzes the target query progress status by predicting performance characteristics based on the query plan, acquiring a snapshot of resource usage of the executing target query for resources included in the prediction, and comparing the snapshot of resource usage to predicted total resource usage.

3. The system according to claim 1 further comprising:

the query analyzer that further acquires a snapshot of performance statistics for the database while the database is running.

4. The system according to claim 1 further comprising:

the query analyzer that further recommends an action based on the comparison of measured target query resource usage to resource usage predicted from a query plan of the target query.

5. The system according to claim 1 further comprising:

a database server that services the database queries wherein the query analyzer executes from the database server.

6. The system according to claim 1 further comprising:

a database server that services the database queries; and

a processor communicatively coupled to the database server wherein the query analyzer executes from the processor.

7. The system according to claim 1 further comprising:

the query analyzer that analyzes the target query in terms of a plurality of resources.

8. The system according to claim 1 further comprising:

the query analyzer that predicts performance characteristics of the target query run in isolation on a selected database system based on the query plan of the target query.

9. The system according to claim 1 further comprising:

the query analyzer that measures system resource usage statistics and overall system usage statistics at runtime of the target query.

10. The system according to claim 1 further comprising:

the query analyzer that categorizes executing queries in terms of ratio of predicted to actual resource usage including consideration of elapsed time.

11. The system according to claim 1 further comprising:

the query analyzer that distinguishes between metrics reflecting resources usable by multiple queries concurrently and resources with shared, alternate usage among multiple queries.

12. A computer-implemented database system comprising:

means for performing query processing in a database comprising;

means for receiving database queries including a target query directed to a database;

means for analyzing progress status of the target query based on comparison of measured target query resource usage to resource usage predicted from a query plan of the target query and measured system resource usage; and

means for distinguishing between metrics reflecting resources usable by multiple queries concurrently and resources with shared, alternate usage among multiple queries.

13. The system according to claim 12 further comprising:

an article of manufacture comprising;

a controller-usable medium having a computer readable program code embodied in a controller for performing query processing in a database, the computer readable program code further comprising;

code causing the controller to receiving database queries including a target query directed to a database;

code causing the controller to analyze the target query progress status;

code causing the controller to predict performance characteristics based on the query plan;

code causing the controller to acquire a snapshot of resource usage of the executing target query for resources included in the prediction; and

code causing the controller to compare the snapshot of resource usage to predicted total resource usage.

14. A method of operating a database processing system comprising:

receiving database queries including a target query directed to a database;

comparing measured target query resource usage to resource usage predicted from a query plan of the target query;

analyzing progress status of the target query based on the comparison; and

distinguishing between metrics reflecting resources usable by multiple queries concurrently and resources with shared, alternate usage among multiple queries.

15. The method according to claim 14 further comprising:

analyzing the target query progress status comprising;

predicting performance characteristics based on the query plan and measured system resource usage;

acquiring a snapshot of resource usage of the executing target query for resources included in the prediction; and

comparing the snapshot of resource usage to predicted total resource usage.