Self-monitoring and trending service system with a cascaded pipeline with a unique data storage and retrieval structures

• US 20030140139A1
• Filed: 06/27/2002
• Published: 07/24/2003
• Est. Priority Date: 01/14/2002
• Status: Abandoned Application

• Current Assignee: Sun Microsystems (Oracle Corporation), Sun Microsystems Incorporated (Oracle Corporation)
• Original Assignee: Sun Microsystems (Oracle Corporation)
• Inventors: Marejka, Richard, Birkbeck, Guy, Dabrowski, Dariusz, Ferrante, Louis
• Application Number:
  US10/184,605
• Publication Number:
  US 20030140139A1
• Time in Patent Office: Days
• US Class Current: 709/224
• CPC Class Codes: H04L 43/06 Generation of reports
• CPC Class Codes: H04L 43/14 using software, i.e. software packages network security related monitoring H04L63/1408
• CPC Class Codes: H04L 43/16 Threshold monitoring

Abstract

A database structure, system and method as part of a self-monitoring system that provides a scalable solution to delivering self-service solutions including system monitoring, trend reporting, asset tracking, and asset time delta reporting. The database structure is represented by Entity Relationship Diagrams (ERDs) that illustrate how tables and columns of data are interrelated. The database is organized to store and retrieve data from customer systems on a customer network, including data about the configuration of the customer systems and customer network and trends occurring on the customer systems and network. The configuration and trend data stored in the database can be processed by service provider system and displayed as custom tailored reports to operators of the customer network through customer management nodes.

Claims

1. A database for a remote computer system monitoring service, the database comprising:

a plurality of configuration data structures, wherein each of said plurality of configuration data structures is associated with a monitored computer system, and wherein each of said configuration data structures comprises a searchable configuration attribute that includes information about the monitored computer system.

2. The database of claim 1, wherein said plurality of configuration data structures include hardware data structures, and software data structures.

3. The database of claim 1, wherein said database comprises a plurality of computer identity data structures, wherein each of the computer identity data structures are associated with a monitored computer system and with one or more of said configuration data structures,

and wherein each of said plurality of computer identity data structures comprises a searchable identity attribute of the monitored computer system.

4. The database of claim 3, wherein said searchable identity attribute is selected from the group consisting of customer system identifying data, relay identifying data, node identifying data, domain identifying data, operating system identifying data, client location data, client timezone data, security certificate data, alarm history data, reboot history data, threshold event history data, upgrade history data, start date data, and a unique identity number assigned by the self-monitoring system.

5. The database of claim 1, wherein said database comprises a plurality of trending data structures.

6. The database of claim 5, wherein said trending data structure includes trending data that is selected from the group consisting of storage system trends, file system trends, operating system trends, network trends, CPU trends, system memory trends, customer system trends, system rebooting trends, and rpc client trends and rpc server trends.

7. The database of claim 1, wherein said database is in electronic communication with a service provider system portion of the self-monitoring system.

8. A method of displaying a message from a self-monitoring system, comprising the steps of:

storing data from the self-monitoring system in a database;

processing the data from the database to generate the message; and

displaying the message at customer management node, wherein the database comprises an identity entity that uniquely identifies a customer system in electronic communication with the self-monitoring system; and

at least one data entity for data from the self-monitoring system.

9. The method of claim 8, wherein said data is selected from the group consisting of configuration data, and trending data.

10. The method of claim 8, wherein said message is an alarm.

11. The method of claim 8, wherein said message is a report.

12. The method of claim 8, wherein said customer management node comprises an internet browser.

13. The method of claim 8, wherein said identity entity comprises at least one attribute selected from the group consisting of customer system identifying data, relay identifying data, node identifying data, domain identifying data, operating system identifying data, client location data, client timezone data, security certificate data, alarm history data, reboot history data, threshold event history data, upgrade history data, start date data, and a unique identity number assigned by the self-monitoring system

14. The method of claim 8, wherein said data entity for data from the self-monitoring system is selected from the group consisting of a configuration data entity, a trending data entity, an alarm data entity, and a report data entity.

15. A self-monitoring system for providing self-service tools from a service provider system linked through a communications network to a customer network, comprising:

a communication pipeline within a customer network adapted for digital data transfer;

a plurality of monitored relays linked to the pipeline comprising end nodes running at least a portion of the provided self-service tools;

a forwarding relay linked to the pipeline upstream of the monitored relays adapted to control flow of data transmitted between the service provider system and the monitored relays, wherein the forwarding relay includes means for storing the transmitted data and selectively forwarding the stored data on the pipeline;

a customer relay linked to the pipeline and to the communications network providing a communication interface between the service provider system and the forwarding relay; and

a data structure stored in memory of the system including data resident in a database used by the service provider system in providing the self-service tool, wherein the data in the database includes data collected at the monitored relays and transmitted over the communication pipeline.

16. The self-monitoring system of claim 15, wherein said database is a relational database.

17. The self-monitoring system of claim 15, wherein said data comprises configuration data.

18. The self-monitoring system of claim 15, wherein said data comprises trending data.

19. The self-monitoring system of claim 15, wherein said communications network is the Internet.

20. The self-monitoring system of claim 15, wherein said self service tool comprises an Internet browser.

21. A database for a remote computer system monitoring service, the database comprising:

a plurality of configuration data structures, wherein each configuration data structure is associated with a particular monitored computer system; and

a system delta data structure, wherein the system delta data structure is associated with at least one of the plurality of configuration data structures, and includes information on a configuration change associated with said at least one configuration data structure.

22. The database of claim 21, wherein said information on the configuration change comprises a description of the configuration change, and a time the configuration change occurred.

23. The database of claim 21, wherein said database further comprises a plurality of trending data structures, wherein the system delta data structure is associated with at least one of the plurality of trending data structures.

24. A database for a remote computer system monitoring service, the database comprising:

a plurality of configuration data structures, wherein each configuration data structure is associated with a particular monitored computer system; and

a RAS system analysis data structure, wherein the RAS system analysis data structure is associated with at least one of the plurality of configuration data structures.

25. The database of claim 24, wherein said RAS system analysis data structure comprises:

a problem data structure, wherein the problem data structure is associated at least one configuration data structure from said plurality of configuration data structures, and includes problem information associated with said at least one configuration data structure; and

a solution data structure, wherein the solution data structure is associated with the problem data structure and includes solution information associated with the problem data structure.

26. The database of claim 25, wherein said RAS system analysis data structure comprises a severity data structure, wherein said severity data structure is associated with the problem data structure and includes a severity information associated with the problem data structure.

27. The database of claim 25, wherein said RAS system analysis data structure comprises an instruction data structure, wherein said instruction data structure is associated with the solution data structure and includes instructions for implementing the solution.