IMS change mapper
View Patent ↗A method, system and device for monitoring internal database log events in a computer database environment are described. As database updates are detected they are analyzed and used to determine which of several kinds of database maintenance are required. The database administrator is therefore presented with information to allow for more accurate maintenance scheduling and able to prevent unnecessary database maintenance outages.
1. A method of monitoring internal activity within one or more databases comprising:
tracking updates to one or more database segments in the one or more databases based on log record information associated with each of the databases, wherein the log record information identifies a type of update, a location of the update within the database and the database in which the update occurred;
accessing the log record information using a portal to a logger component of the databases;
generating metrics using the accessed log record information including fragmentation metrics and update metrics, wherein the fragmentation metrics include statistics of an extent of database fragmentation and the update metrics include statistics of an extent of changes to a database;
storing the fragmentation metrics and the update metrics in a change map;
analyzing the fragmentation metrics and the update metrics stored in the change map to determine database maintenance requirements by comparing the fragmentation metrics and the update metrics to pre-defined thresholds set in a trigger file to determine when to perform one or more database utilities; and
publishing the database maintenance requirements based on analysis of the metrics.
2. The method of claim 1 wherein the act of publishing further comprises presenting one or more recommended actions to a database administrator.
3. The method of claim 1 wherein the act of publishing further comprises causing another process to automatically perform one or more recommended actions.
4. The method of claim 1 wherein the act of analyzing further comprises analyzing a change map containing information about database updates over a period of time.
5. The method of claim 1 wherein the act of analyzing is performed in real-time.
6. The method of claim 1 wherein the act of analyzing is performed in near real-time.
7. The method of claim 1 wherein the act of analyzing is performed for a specific time period.
8. The method of claim 1 wherein the act of analyzing is performed by a change server process implemented via an internal exit function provided by a database logging function.
9. The method of claim 8 wherein the tracked updates are buffered until a threshold is reached prior to performing analysis by a change server.
10. The method of claim 1 wherein the database maintenance requirements include postponing maintenance based on low change activity.
11. The method of claim 1 wherein the database maintenance requirements include accelerating maintenance based on high change activity.
12. The method of claim 1 wherein the act of analyzing is used to optimize maintenance by minimizing time the one or more databases are taken off-line.
13. The method of claim 1 wherein the act of analyzing is used to predict future maintenance requirements.
14. A computer readable medium containing instructions stored thereon to instruct a processor to perform the method of claim 1 .
15. The method of claim 1 further comprising:
storing the metrics for later analysis; and
analyzing the stored one or more metrics to determine database design changes for optimal use of the one or more databases.
16. A method comprising:
creating one or more change maps related to activity in a database;
monitoring changes to a database via internal database logging exit functions using a portal to a logger component of the database by accumulating the changes to the database in a cache;
updating the one or more change maps based on the accumulated monitored changes from the cache upon an occurrence of an event;
determining, using a processor, database maintenance requirements from the one or more change maps to identify recommended database actions by comparing information in the change maps to pre-defined thresholds set in a trigger file including an analysis based on monitored changes since a previous determination and cumulative monitored changes since a previous database initialization or reorganization to determine when to perform one or more database utilities related to the recommended database actions; and
publishing information about the database maintenance requirements.
17. The method of claim 16 wherein the act of publishing further comprises presenting one or more recommended actions to a database administrator.
18. The method of claim 16 wherein the act of publishing further comprises informing another process to automatically perform one or more recommended actions.
19. The method of claim 16 wherein the act of monitoring is performed in real-time.
20. The method of claim 16 wherein the act of monitoring is performed in near real-time.
21. The method of claim 16 wherein the act of monitoring comprises recording the monitored changes in a buffer until a threshold is reached prior to performing analysis by a change server.
22. The method of claim 16 , wherein the act of determining is performed by a change server process.
23. The method of claim 16 wherein the act of determining comprises postponing maintenance based on a low change activity.
24. The method of claim 16 wherein the act of determining includes accelerating maintenance based on a high change activity.
25. The method of claim 16 wherein the act of determining is used to optimize maintenance by minimizing time the one or more databases are taken off-line.
26. The method of claim 16 further comprising:
storing the monitored changes for later analysis; and
predicting future maintenance requirements based on the stored changes.
27. The method of claim 16 further comprising:
storing the monitored changes for later analysis; and
analyzing the stored changes to determine database design changes for optimal use of the one or more databases.
28. A computer readable medium containing instructions stored thereon to instruct a processor to perform the method of claim 16 .