Analytics driven in-memory data grid (IMDG) hydration
View Patent ↗Embodiments of the present invention provide a method, system and computer program product for analytics driven IMDG cache hydration. In an embodiment of the invention, a method of analytics driven IMDG cache hydration includes retrieving from an analytics engine data utilization metrics for data in a database of a DBMS, selecting a subset of the data according to the data utilization metrics, and hydrating an IMDG cache of the DBMS with the selected subset. In one aspect of the embodiment, the data utilization metrics indicate one of a frequency and a recency of retrieval of the data in the database. In another aspect of the embodiment, the method additionally includes adding subsequent data to the IMDG cache when the subsequent data has been requested for retrieval a threshold number of times.
1. A method of analytics driven in memory data grid (IMDG) cache hydration, the method comprising:
retrieving from an analytics engine data utilization metrics for data in a database of a database management system (DBMS);
selecting a subset of the data according to the data utilization metrics;
testing the selected subset of the data against a caching rule to determine whether the selected subset of the data meets the caching rule;
hydrating an IMDG cache of the DBMS with the selected subset upon determining that the selected subset of the data meets the caching rule.
2. The method of claim 1 , wherein the data utilization metrics indicate at least one of a frequency and a recency of retrieval of the data in the database.
3. The method of claim 1 , further comprising adding subsequent data to the IMDG cache when the subsequent data has been requested for retrieval a threshold number of times.
4. A database management system (DBMS) configured for analytics driven hydration of an in memory data grid (IMDG) cache of the DBMS, the system comprising:
a database;
a DBMS executing in memory of a host computing system and managing access to the database;
an IMDG cache for the DBMS;
an analytics engine coupled to the DBMS and analyzing access to data in the database; and,
an IMDG hydration module coupled to the DBMS, the IMDG cache and the analytics engine, the IMDG hydration module comprising program code enable to retrieve from the analytics engine data utilization metrics for the data in the database of the DBMS, to select a subset of the data according to the data utilization metrics, to test the selected subset of the data against a caching rule to determine whether the selected subset of the data meets the caching rule, and to hydrate the IMDG cache of the DBMS with the selected subset upon determining that the selected subset of the data meets the caching rule.
5. The system of claim 4 , wherein the data utilization metrics indicate at least one of a frequency and a recency of retrieval of the data in the database.
6. The system of claim 4 , wherein the program code of the IDMG hydration module is further enabled to add subsequent data to the IMDG cache when the subsequent data has been requested for retrieval a threshold number of times.