Database monitoring system with formatted report information delivery

• US 20030233366A1
• Filed: 06/16/2003
• Published: 12/18/2003
• Est. Priority Date: 06/17/2002
• Status: Abandoned Application

• Current Assignee: Aspetuck Systems Incorporated
• Original Assignee: Aspetuck Systems Incorporated
• Inventors: Kesselman, Brian J., Gabriele, Michael
• Application Number:
  US10/462,157
• Publication Number:
  US 20030233366A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27

Abstract

A database monitoring system that resides external to the data to be monitored. The system uses metadata to describe specific information contained in the data, or in a related external system. The system monitors for the occurrence of predetermined conditions or events on a scheduled basis. Upon occurrence of the event, the system takes specific action which can include the creation of a formatted report, containing extracts from the database, which can be sent to a one or more destinations including via email to recipients determined based on data included on the report or recipients with a pre-defined relationship to the data included on the report.

Claims

1. A computer implemented system for monitoring an external database comprising:

a server having a system database and a user interface coupled thereto, said server being connectable with an external database, said external database having data stored therein to be monitored;

said system database having metadata stored therein related to the external database and said monitoring thereof; and

wherein said server includes an executable program for evaluating said data stored in said external database based on information derived from said metadata.

2. The system as defined in claim 1 wherein said metadata is user defined.

3. The system as defined in claim 1 wherein said server includes a report engine for generating reports based on the results of said evaluations.

4. The system as defined in claim 1 wherein said executable program further comprises an event procedure object, said event procedure object being executable for evaluating said data stored in said external database.

5. The system as defined in claim 4 wherein said event procedure object further comprises data stored in said system database.

6. The system as defined in claim 5 wherein said evaluations performed by said event procedure object include testing for the occurrence of predefined conditions of said stored data.

7. The system as defined in claim 4 wherein said evaluations performed by said event procedure object include testing for the occurrence of predefined conditions of at least one of said stored data, said system database, said server, and an external system or application connected to said server.

8. The system as defined in claim 5 wherein said event procedure object further comprises priority information for prioritizing the execution of said event procedure object.

9. The system as defined in claim 5 wherein said event procedure object further comprises one or more scripts defining actions to be performed in conjunction with the execution of said event procedure object.

10. The system as defined in claim 9 wherein said scripts define actions for modifying the stored data in said external database.

11. The system as defined in claim 9 wherein said one or more scripts further comprise a predefined scripting language.

12. The system as defined in claim 9 wherein said one or more scripts are user definable.

13. The system as defined in claim 6 further comprising a report engine accessible to said event procedure object for generating reports based on at least one of said stored data, said evaluations, and the results of said evaluations.

14. The system as defined in claim 13 wherein said event procedure objects forward said reports to predetermined destinations.

15. The system as defined in claim 5 wherein said event procedure object sends information to predetermined destinations.

16. The system as defined in claim 13 wherein said report engine-determines appropriate destinations for said reports based on an evaluation of the content of said report.

17. The system as defined in claim 16 wherein said event procedure object forwards said reports to said destinations.

18. The system as defined in claim 16 further comprising an email database coupled to said report engine for storing email addresses of at least a portion of said destinations.

19. The system as defined in claim 16 wherein said destinations include at least one of an email recipient, a file recipient, a client recipient, and a printer recipient.

20. The system as defined in claim 14 further comprising an output report application coupled to said report engine, said output report application being executable for formating said reports based on information derived from at least one of said stored data, said metadata, said evaluations and the results of said evaluations.

21. The system as defined in claim 14 wherein said reports are formatted based on the destination thereof.

22. The system as defined in claim 5 further comprising a plurality of external databases wherein said system includes a plurality of said event procedure objects stored in said system database wherein each of said event procedure objects corresponds to one of said plurality of external databases.

23. The system as defined in claim 5 wherein the event procedure object includes frequency information for determining the frequency for the execution thereof.

24. The system as defined in claim 5 wherein the event procedure object includes frequency information for determining the frequency for the execution thereof.

25. The system as defined in claim 16 further comprising an event procedure catalog object coupled to said system database and said report engine, said event procedure catalog including data stored in said system database and an executable program for performing at least one of:

reading a plurality of said event procedure objects;

grouping a plurality of said event procedure objects, for scheduling the execution thereof;

executing said event procedure objects; and

generating notifications as to a completion or a failure of the execution of said event procedure objects

26. The system as defined in claim 16 further comprising an event procedure catalog object coupled to said system database and said report engine, said event procedure catalog including data stored in said system database and an executable program for performing at least one of:

reading a plurality of said event procedure objects;

grouping a plurality of said event procedure objects, for scheduling the execution thereof;

executing said event procedure objects; and

determining which of said reports have a common destination;

27. The system as defined in claim 26 further comprising an executable program for grouping said reports having a common destination for aggregate delivery thereof.

28. The system as defined in claim 25 wherein said event procedure catalog object includes frequency information for determining the frequency for the execution of said event procedure objects.

29. The system as defined in claim 5 wherein said event procedure object includes frequency information for determining the frequency for the execution of said event procedure objects.

30. The system as defined in claim 25 further comprising a manager application having a timer, the manager application including a service mode wherein a plurality of the event procedure catalog objects are retrieved and executed at predetermined intervals in accordance with said timer.

31. The system as defined in claim 30 wherein said manager application further comprises a user controlled maintenance mode wherein the execution of said event procedure catalog objects is suspended for user updating of said metadata.

32. The system as defined in claim 1 wherein the system is scalable.

33. The system as defined in claim 3 wherein the system further comprises a plurality of connectable servers for monitoring one or more external databases in a distributed system.

34. The system as defined in claim 33 wherein at least one of said plurality of servers is designated for performing a specific function of said system.

35. The system as defined in claim 25 wherein said system further comprises a plurality of connectable servers for monitoring one or more external databases, said plurality of servers being configured for optimizing the execution of said event procedure objects and said event procedure catalog objects.

36. The system of claim 35 wherein said system further comprises an optimization scheme for optimizing the execution of at least one of said event procedure objects and said event procedure catalog objects wherein said optimization scheme utilizes at least one of a metric, a mathematical formula and a weighting system.

37. The system of claim 1 wherein said system further comprises said server being connectable with an external database through a network.

38. A method for monitoring an external database comprising the steps of:

coupling a server to an external database having data stored therein to be monitored;

providing metadata accessible to said server, said metadata being related to said external database and the monitoring thereof;

accessing at least a portion of said stored data; and

evaluating said stored data based on said metadata.

39. The method for monitoring an external database as defined in claim 38 further comprising a step of generating a report based on at least one of said metadata and the results of said evaluations.

40. The method for monitoring an external database as defined in claim 39 further comprising a step of forwarding said report to at least one destination.

41. The method for monitoring an external database as defined in claim 39 further comprising a step of determining said at least one destination for said report based on at least one of said evaluations and the content of said report.

42. The method for monitoring an external database as defined in claim 40 further comprising a step of determining said destination for said report, wherein said step of determining includes comparing an email database content with the content of said report.

43. The method for monitoring an external database as defined in claim 40 further comprising a step of formatting said report prior to said step of forwarding.

44. The method for monitoring an external database as defined in claim 43 wherein said step of formatting of said report includes a step of determining a format for said report based on at least one of said metadata, the results of said evaluations and the destination for said report.

45. The method for monitoring an external database as defined in claim 38 wherein said step of coupling includes said server being connectable to a plurality of external databases to be monitored and wherein said step of providing metadata includes providing an event procedure object corresponding to each of said plurality of external databases.

46. The method for monitoring an external database as defined in claim 45 further comprising a step of defining said event procedure objects via a user interface.

47. The method for monitoring an external database as defined in claim 38 wherein said step of evaluating said stored data further comprises a step of testing said stored data for the occurrence of predefined conditions.

48. The method for monitoring an external database as defined in claim 38 wherein said step of evaluating further comprises executing at least one script defining an action to be performed in conjunction with said evaluating.

49. The method for monitoring an external database as defined in claim 48 wherein said at least one script is selected based on the results of said evaluations.

50. The method for monitoring an external database as defined in claim 38 wherein said script includes modifying said stored data.

51. The method for monitoring an external database as defined in claim 48 wherein said at least one script is user defined.

52. The method for monitoring an external database as defined in claim 45 further comprising a step of grouping said event procedure objects for establishing an order for the execution thereof.

53. The method for monitoring an external database as defined in claim 52 wherein said step of grouping said event procedure objects includes at least one of determining a frequency for the execution of said event procedure objects and determining a priority for the execution of event procedure objects.

54. The method for monitoring an external database as defined in claim 38 further comprising employing a plurality of servers for monitoring said external database.

55. The method for monitoring an external database as defined in claim 38 further comprising repeating said evaluations based on a frequency stored in said metadata.