Latency management and advising tool for a database management system
First Claim
Patent Images
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
14 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. - View Dependent Claims (2, 3, 4, 5)
-
-
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. - View Dependent Claims (7, 8, 9, 10)
-
-
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. - View Dependent Claims (12, 13, 14)
-
Specification