APPARATUS, SYSTEM, AND METHOD FOR DATABASE MANAGEMENT EXTENSIONS

• US 20080091978A1
• Filed: 10/13/2006
• Published: 04/17/2008
• Est. Priority Date: 10/13/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Weihrauch, Maryela Evelin, Wansch, Peter, Karn, Holger, McBride, Kevin Michael, Brodsky, Stephen Andrew
• Granted Patent: US 10,031,830 B2
• Time in Patent Office: Days
• US Class Current: 714/38.14
• CPC Class Codes: G06F 11/3466 Performance evaluation by tracing or monitoring
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/81 Threshold

Abstract

An apparatus, system, and method are disclosed for evaluating database accesses. The apparatus may comprise a computer program that causes a computer system to exchange profiling data between a client application module and a database module; execute a database access; determine a database access policy violation at a detection point module; and selectively request context information from a context point module related to the database access.

Claims

1. A computer program product for evaluating database accesses comprising a computer useable medium including a computer readable program, wherein the computer program product when executed on a computer causes the computer to:

exchange profiling data between a client application module and a database module, the profiling data comprising a set of quality of service thresholds and corresponding quality of service results related to a client database access;

determine a database access policy violation at a detection point module, the detection point module, the database access policy violation comprising a database access that violates one of an application policy and a database policy, wherein determining a database access policy violation compares quality of service results with the profiling data; and

selectively request context information from a context point module, in response to the database access policy violation, wherein the detection point module and the context point module are distinct modules.

2. The computer program product of claim 1 further configured to alert one of the client application module and the database module of the database access policy violation in conjunction with satisfying the client database access.

3. The computer program product of claim 1, wherein the request for context information is a synchronous request and context information is returned by the context point module.

4. The computer program product of claim 1, wherein determining a database access policy violation further comprises determining whether the quality of service results satisfy the set of quality of service thresholds.

5. The computer program product of claim 4, wherein the quality of service thresholds and quality of service results are associated with input/output device activity related to a client database access at the detection point module.

6. The computer program product of claim 4, wherein the quality of service thresholds and quality of service results are associated with one or more of concurrency information, network latency, and CPU utilization.

7. The computer program product of claim 4, wherein the quality of service thresholds and quality of service results are associated with network latency related to a client database access.

8. The computer program product of claim 1, wherein the set of quality of service thresholds is defined prior to execution of the computer program product, the set of quality of service thresholds embedded into the computer program product for use at the detection point module.

9. The computer program product of claim 1, wherein the context information comprises runtime parameters associated with the context point module including a program locator value associated with the context point module.

10. The computer program product of claim 9, wherein the runtime parameters comprise database call parameters selected from a group consisting of a database access time, a program stack trace, a source code line number, a database name, a database application identifier, a database transaction identifier, a Java class name, a Java method name, a Java object name, central processing unit (CPU) load statistics, network load statistics, a response time value for the database access, a group response time value for a plurality of database accesses, amount of data retrieved, Java runtime container statistics, and names of applications currently executing on a CPU.

11. The computer program product of claim 10, wherein determining a database access policy violation comprises comparing quality of service results to a corresponding set of quality of service thresholds and identifying a database access policy violation in response to at least one unsatisfied quality of service threshold.

12. An apparatus to evaluate database accesses, the apparatus comprising:

a database module configured to control read, write, update, and delete access to a database;

a detection point module configured to monitor quality of service results related to a database access request;

an application module configured initiate a database access request to access data controlled by the database module; and

a context point module configured to provide context information in response to a synchronous context information request,

the detection point module further configured to compare the quality of service results to a set of quality of service thresholds specific to the detection point module and to signal a database access policy violation to the application module in response to the quality of service results failing to satisfy at least one member of the set of quality of service thresholds,

wherein the context point module records context information for at least the database module in response to the signal from the database policy module.

13. The apparatus of claim 12, wherein the set of quality of service thresholds are included in the context information request.

14. The apparatus of claim 12, wherein the quality of service thresholds and quality of service results are associated measurements related to a database access at the detection point module.

15. The apparatus of claim 14, wherein the quality of service results are measurements of response time related to a database access.

16. The apparatus of claim 14, wherein the quality of service results are measurements of network latency related to a database access.

17. The apparatus of claim 16, wherein the set of quality of service thresholds is defined prior to the execution of the computer program product, the set of quality of service thresholds embedded into the computer program product for use at the detection point module by one of the application module and the database module.

18. The apparatus of claim 17, wherein the context information comprises runtime parameters associated with the context point module including a program pointer locator value associated with the context point module.

19. A system configured to evaluate database accesses, the system comprising:

a computer network;

a computing device connected to the computer network, the computing device configured to execute software applications;

a database application executing on the computing device comprising;

a database module configured to control read, write, update, and delete access to data,

a detection point module configured to monitor quality of service results related to a database access request, and

a database policy module comprising profiling data comprising a set of quality of service thresholds and corresponding quality of service results related to a client database access, wherein the database policy module evaluates database accesses according to the set of quality of service thresholds and the quality of service results;

a database software client executing on a second computing device and configured to execute a database access to the database module over the network, the second computing device connected to the computer network;

wherein the detection point module detects quality of service results related to the database access;

wherein business logic of the database policy module detects an access policy violation in response to at least one quality of service result failing to satisfy at least one member of the set of quality service thresholds and notifies the database software client of the policy violation; and

wherein the database software client records runtime parameters specific to the database access in response to the notification by the business logic.

20. A method of diagnosing a database access irregularity, the method comprising:

at a detection point module for a database, recording quality of service results for a database access;

comparing the quality of service results with a set of quality of service thresholds;

determining that a database access policy violation has occurred based on the quality of service results failing to satisfy the set of quality of service thresholds; and

recording runtime parameters associated with the database access, wherein the runtime parameters are recorded at a context point module.