Method, system and program product for identifying caching opportunities

Abstract

A method, system and program product for identifying caching opportunities is provided. The method includes identifying one or more data sources stored on a database system that are utilized by an application, establishing a pre-set read-update ratio threshold for data accessed from a data source, and tracking the read-update ratio threshold for data accessed from the data source, such that exceeding the pre-set read-update ratio threshold for the data accessed identifies a caching opportunity. The method further includes defining an action to be taken when the pre-set read-update ratio threshold for the data accessed from the data source has been exceeded and taking the action defined when the pre-set read-update ratio threshold for the data accessed from the data source has been exceeded. The action defined includes either advising a user of an opportunity to cache the data accessed or automatically caching the data accessed from the data source.

1 . A method for identifying caching opportunities, said method comprising the steps of:
 identifying at least one data source among a plurality of data sources utilized by an application, said plurality of data sources being stored on a computer system;   establishing a pre-set respective read-update ratio threshold for respective data accessed from a respective data source among said plurality of data sources, wherein exceeding said pre-set respective read-update ratio threshold for said respective data accessed identifies a caching opportunity;   defining an action to be taken when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded; and   taking said action defined when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded.   
   
   
       2 . The method according to  claim 1 , further comprising the step of:
 tracking a respective read-update ratio threshold for data accessed from each data source among said plurality of data sources stored on said computer system.   
   
   
       3 . The method according to  claim 2 , wherein said tracking step further comprises the step of:
 determining when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source among said plurality of data sources is exceeded.   
   
   
       4 . The method according to  claim 3 , wherein said taking step further comprises the step of:
 checking said action defined before taking said action defined when said read-update ratio threshold for said respective data accessed from said respective data source has been exceeded.   
   
   
       5 . The method according to  claim 4 , wherein said action defined to be taken when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded comprises at least one of: advise a user of an opportunity to cache said respective data accessed from said respective data source and automatically cache said respective data accessed from said respective data source. 
   
   
       6 . The method according to  claim 5 , wherein if said action defined is to advise said user of said opportunity to cache said respective data when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded, said method further comprises the steps of:
 sending notification to said user that said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded; and   inquiring whether said user wants to cache said respective data from said respective data source.   
   
   
       7 . The method according to  claim 6 , wherein if said user wants to cache said respective data from said respective data source, said method further comprises the steps of:
 receiving an affirmative response from said user to cache said respective data from said respective data source; and   caching said respective data from said respective data source.   
   
   
       8 . A system for identifying caching opportunities, comprising:
 an application server configured to ascertain one or more data sources utilized by an application;   a database manager configured to track a respective read-update ratio threshold for data accessed from at least one data source of said one or more data sources in said database; and   a caching prospector tool configured to receive a pre-set respective read-update ratio threshold for respective data accessed from a respective data source of said one or more data sources, said one or more data sources being stored in a database; said caching prospector tool being further configured to take a defined action when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded, wherein exceeding said pre-set respective read-update ratio threshold for said respective data accessed identifies a caching opportunity.   
   
   
       9 . The system according to  claim 8 , wherein said caching prospector tool is further configured to determine a first use of said respective data accessed from said respective data source and is configured to register with said database manager to receive notification when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded. 
   
   
       10 . The system according to  claim 9 , wherein said caching prospector tool is further configured to receive notification when said pre-set respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded. 
   
   
       11 . The system according to  claim 10 , wherein said defined action to be taken when said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded comprises at least one of: advise a user of an opportunity to cache said respective data accessed from said respective data source and automatically cache said respective data accessed from said respective data source. 
   
   
       12 . The system according to  claim 11 , wherein if said defined action is to advise said user of said opportunity to cache said data, said caching prospector tool is further configured to inquire whether said user wants to cache said respective data from said respective data source when said respective read-update ratio threshold for said data accessed from said respective data source has been exceeded. 
   
   
       13 . The system according to  claim 12 , wherein said caching prospector tool is further configured to request caching of said respective data from said respective data source upon receiving an affirmative response from said user to cache said respective data. 
   
   
       14 . The system according to  claim 13 , wherein if said defined action is to automatically cache said respective data from said respective data source, said caching prospector tool automatically requests caching of said respective data from said respective data source when said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded. 
   
   
       15 . A computer program product for identifying caching opportunities, said computer program product comprising:
 a computer readable medium;   first program instructions to establish a respective read-update ratio threshold for respective data accessed from a respective data source among a plurality of data sources stored in a database, wherein exceeding said read-update ratio threshold for said respective data accessed identifies a caching opportunity;   second program instructions to define an action to be taken when said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded;   third program instructions to take said action defined when said read-update ratio threshold for said respective data accessed from said respective data source has been exceeded; and wherein said first, second and third program instructions are stored on said computer readable medium.   
   
   
       16 . The computer program product according to  claim 15 , further comprising:
 fourth program instructions to track a respective read-update ratio threshold for data accessed from each data source among said plurality of data sources stored in said database; and wherein said fourth program instructions are stored on said computer readable medium.   
   
   
       17 . The computer program product according to  claim 16 , wherein said first program instructions include instructions to identify at least one data source among said plurality of data sources utilized by an application; and wherein said action defined to be taken when said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded comprises at least one of: advise a user of an opportunity to cache said respective data accessed from said respective data source and automatically cache said respective data accessed from said respective data source. 
   
   
       18 . The computer program product according to  claim 17 , wherein if said action defined is to advise said user of said opportunity to cache said respective data when said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded, said third program instructions include instructions to send notification to said user that said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded and to inquire whether said user wants to cache said respective data from said respective data source. 
   
   
       19 . The computer program product according to  claim 18 , wherein if said user sends an affirmative response to cache said respective data from said respective data source, said third program instructions include instructions to cache said respective data from said respective data source upon receiving said affirmative response from said user to cache said respective data. 
   
   
       20 . The computer program product according to  claim 19 , wherein if said action defined is to automatically cache said respective data when said respective read-update ratio threshold for said respective data accessed from said respective data source has been exceeded, said third program instructions include instructions to automatically cache said respective data from said respective data source.