Latency management and advising tool for a database management system

• US 10,397,314 B2
• Filed: 11/24/2015
• Issued: 08/27/2019
• Est. Priority Date: 11/24/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Arnold, Jason K., Calzaretta, Henry E., Crupi, Gary W., Kethireddy, Shantan, Murphy, Dylan S.
• Primary Examiner(s): Asres, Hermon
• Application Number:
  US14/950,919
• Publication Number:
  US 20170149870A1
• Time in Patent Office: 1,372 Days
• Field of Search: 709224
• CPC Class Codes: H04L 43/0852 Delays
• CPC Class Codes: H04L 67/101 based on network conditions

Abstract

A system, method and program product for providing latency management for use with a database management system. A system is disclosed having: a system for capturing and storing a maximum latency (ML) whenever a derived source is created from a source data; a system for determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query; and a system for causing the source data to be used in response to the difference being greater than the ML, and for causing the derived source to be used in response to the difference being less than the ML.

Claims

1. A latency management system for use with a database management system, comprising:

a maximum latency manager that stores a user-defined maximum latency constraint whenever a derived source is created from a source data;

a timestamp manager that determines a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query;

a data source evaluation system that selects the source data to be used in response to the difference determined by the timestamp manager being greater than the maximum latency constraint and selects the derived source to be used in response to the difference being less than the maximum latency constraint; and

a maximum refresh delta manager that captures and stores a maximum refresh delta when a query is inputted from an application user, wherein the maximum refresh delta defines a maximum latency difference between the source data and the derived source,

wherein the maximum refresh delta is provided to an optimizer to determine whether a derived source can be utilized for the query.

2. The latency management system of claim 1, further comprising an advisor tool, wherein the advisor tool groups maximum refresh delta data for each of a plurality of derived sources.

3. The latency management system of claim 2, wherein the advisor tool determines how often each derived source should be updated.

4. The latency management system of claim 2, wherein the advisor tool groups query data as a function of a refresh level.

5. The latency management system of claim 1, wherein the maximum refresh delta is stored in a statement cache.

6. A method of providing latency management for a database management system, comprising:

storing a maximum latency constraint when a derived source is created from a source data;

determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query;

causing the source data to be used for the query in response to the difference being greater than the maximum latency constraint and for causing the derived source to be used for the query in response to the difference being less than the maximum latency constraint; and

capturing and storing a maximum refresh delta when a query is inputted from an application user, wherein the maximum refresh delta defines a maximum latency difference between the source data and the derived source,

wherein the maximum refresh delta is provided to an optimizer to determine whether a derived source can be utilized for the query.

7. The method of claim 6, further comprising providing an advisor tool, wherein the advisor tool groups maximum refresh delta data for each of a plurality of derived sources.

8. The method of claim 7, wherein the advisor tool determines how often each derived source should be updated.

9. The method of claim 7, wherein the advisor tool groups query data as a function of a refresh level.

10. The method of claim 6, wherein the maximum refresh delta is stored in a statement cache.

11. A computer program product stored on a non-transitory computer readable storage medium, which when executed by a processor, provides latency management for a database management system, the computer program product comprising:

programming instructions for storing a maximum latency constraint when a derived source is created from a source data;

programming instructions for determining a difference between a last refresh timestamp of the source data and the last refresh timestamp of the derived source in response to a query;

programming instructions for causing the source data to be used for the query in response to the difference being greater than the maximum latency constraint and for causing the derived source to be used for the query in response to the difference being less than the maximum latency constraint; and

programming instructions for capturing and storing a maximum refresh delta when a query is inputted from an application user, wherein the maximum refresh delta defines a maximum latency difference between the source data and the derived source,

wherein the maximum refresh delta is provided to an optimizer to determine whether a derived source can be utilized for the query.

12. The computer program product of claim 11, further comprising programming instructions to implement an advisor tool, wherein the advisor tool groups maximum refresh delta data for each of a plurality of derived sources.

13. The computer program product of claim 12, wherein the advisor tool determines how often each derived source should be updated.

14. The computer program product of claim 12, wherein the advisor tool groups query data as a function of a refresh level.