Managing Transactional Data for High Use Databases

• US 20150039576A1
• Filed: 07/30/2013
• Published: 02/05/2015
• Est. Priority Date: 07/30/2013
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Campbell, John J., Kozin, Daniel, Slinger, Nigel G., Tobler, John B.
• Granted Patent: US 9,917,885 B2
• Time in Patent Office: Days
• US Class Current: 707/703
• CPC Class Codes: G06F 11/3082 the data filtering being achieved by aggregating or compressing the monitored data
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 2201/87 Monitoring of transactions
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.

Claims

1-7. -7. (canceled)

8. A system for managing database transactions comprising:

at least one processor configured to;

compare database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information;

aggregate information from a threshold quantity of conforming database transactions into an aggregated record; and

generate a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted.

9. The system of claim 8, wherein each database transaction is associated with an identifier that is based on transaction information and the performance information is accumulated for the identifiers.

10. The system of claim 8, wherein the database transactions are for database servers within a cloud environment.

11. The system of claim 8, wherein the performance information includes average values for one or more performance metrics and deviation values for the performance metrics.

12. The system of claim 11, wherein the deviation values include one of a standard deviation and an average difference between the database transactions and current average values for the one or more performance metrics.

13. The system of claim 9, wherein aggregating information comprises aggregating the information separately for transactions associated with each of the identifiers.

14. The system of claim 8, wherein the performance information is updated dynamically.

15. A computer program product for managing database transactions comprising:

a computer readable storage medium having computer readable program code embodied therewith for execution on a processing system, the computer readable program code comprising computer readable program code configured to;

compare database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information;

aggregate information from a threshold quantity of conforming database transactions into an aggregated record; and

generate a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted.

16. The computer program product of claim 15, wherein each database transaction is associated with an identifier that is based on transaction information and the performance information is accumulated for the identifiers.

17. The computer program product of claim 15, wherein the database transactions are for database servers within a cloud environment.

18. The computer program product of claim 15, wherein the performance information includes average values for one or more performance metrics and deviation values for the performance metrics.

19. The computer program product of claim 18, wherein the deviation values include one of a standard deviation and an average difference between the database transactions and current average values for the one or more performance metrics.

20. The computer program product of claim 15, wherein the performance information is updated dynamically.