US6138121A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Network management event storage and manipulation using relational database technology in a data warehouse
Assignee: Hewlett Packard Enterprise Development LP
•
Filing: 1998-05-29
•
Granted: 2000-10-24
•
Expires: 2018-05-29
Abstract
Abstract A data schema and method for storing network management system event data to allow efficient retrieval of information and aggregation for use in tracking system trends and generating useful reports is presented. The invention provides a standardized system event format that is generically available to the user through standard interfaces, along with a method for populating it. The data is easily accessible via standard interfaces to statistical process control, trend tracking, and report generating applications, which present information of interest relating to the events in a useful manner to thereby increase its value.
Inventors
- 👤 Brian Costa
- 👤 Chris P. Das
- 👤 William C. Kepner
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 22:22
CPC Classifications
H; H04; H04L; H04L41/00; H04L41/02; H04L41/024; H04L41/06; H04L41/0677; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 23
Claim 1
Independent Claim
115 words
A method for storing network management system events, each of said events comprising one of a plurality of different event types, comprising: receiving a network management system event, said network management system event comprising a plurality of event fields; extracting at least a first set of said plurality of event fields from said network management system event; storing said first set of said event fields in a report-ready table in a relational database, said report-ready table capable of storing multiple events and used by a report generator to generate a report, and said first set of said event fields comprising each of said plurality of event fields that are essential for generation of said report.
Claim 2
Independent Claim
115 words
A method for storing network management system events, each of said events comprising one of a plurality of different event types, comprising: receiving a network management system event, said network management system event comprising a plurality of event fields; extracting at least a first set of said plurality of event fields from said network management system event; storing said first set of said event fields in a report-ready table in a relational database, said report-ready table capable of storing multiple events and used by a report generator to generate a report, and said first set of said event fields comprising each of said plurality of event fields that are essential for generation of said report.
Claim 3
Dependent Claim
63 words
A method in accordance with claim 1, comprising: extracting a second set of said plurality of event fields from said network management system event; and storing said second set of said event fields in a detail table, said second set of said event fields comprising at least one of said plurality of event fields that are common to all of said event types.
Claim 4
Dependent Claim
77 words
A method in accordance with claim 2, comprising: extracting a third set of said plurality of event fields from said network management system event; storing a third set of said event fields in a variable binding table, said third set of said event fields comprising at least one of said plurality of event fields that are not common to all of said event types; and wherein said detail table comprises a link to said variable binding table.
Claim 5
Dependent Claim
36 words
A method in accordance with claim 3, wherein: said second set of said plurality of event fields and said third set of said plurality of event fields together comprise all of said plurality of event fields.
Claim 6
Dependent Claim
32 words
A method in accordance with claim 1, comprising: receiving a report query from said report generator; and sending said first set of said said plurality of event fields to said report generator.
Claim 7
Dependent Claim
33 words
A method in accordance with claim 2, comprising: receiving a detail query from a process; and returning said second set of said plurality of event fields from said detail table to said process.
Claim 8
Dependent Claim
60 words
A method in accordance with claim 3, comprising: receiving a full detail query from a process, said full detail query requiring all available information about said event; and returning said second set of said plurality of event fields from said detail table and said third set of said plurality of event fields from said variable binding table to said process.
Claim 9
Dependent Claim
83 words
A method in accordance with claim 7, comprising: storing at least one additional set of said plurality of event fields in a corresponding at least one additional report-ready tables, said at least one additional report-ready tables used by at least one report generator to generate at least one additional report, and said at least one additional set of said event fields respectively comprising each of said plurality of event fields that are required for generation of said respective at least one additional reports.
Claim 10
Dependent Claim
31 words
A method in accordance with claim 3, wherein: said variable binding table comprises all of said event fields for a given event type that are not included in said detail table.
Claim 11
Dependent Claim
26 words
A method in accordance with claim 2, wherein: said detail table comprises all of said event fields that are common to all of said event types.
Claim 12
Dependent Claim
37 words
A method in accordance with claim 1, comprising: maintaining a count of a number of occurrences of events during a predetermined time interval of said event type of said event; storing said count in an aggregation table.
Claim 13
Dependent Claim
37 words
A method in accordance with claim 1, comprising: comparing said event to a pre-specified filter condition; and discarding said event and not storing said event in said data warehouse if said event matches said pre-specified filter condition.
Claim 14
Independent Claim
174 words
A method for retrieving a set of report fields from a network management system event data warehouse, said set of report fields for a given event stored in said data warehouse comprising a first set of a plurality of event fields that together comprise a network management system event, and said set of report fields being stored in a report-ready table that comprises each of said plurality of event fields that are essential for generation of a report, said method comprising: receiving a network management system event, said network management system event comprising a plurality of event fields; extracting at least a first set of said plurality of event fields from said network management system event; storing said first set of said event fields in a report-ready table in a relational database, said report-ready table capable of storing multiple events and used by a report generator to generate a report, and said first set of said event fields comprising each of said plurality of event fields that are essential for generation of said report.
Claim 15
Independent Claim
174 words
A method for retrieving a set of report fields from a network management system event data warehouse, said set of report fields for a given event stored in said data warehouse comprising a first set of a plurality of event fields that together comprise a network management system event, and said set of report fields being stored in a report-ready table that comprises each of said plurality of event fields that are essential for generation of a report, said method comprising: receiving a network management system event, said network management system event comprising a plurality of event fields; extracting at least a first set of said plurality of event fields from said network management system event; storing said first set of said event fields in a report-ready table in a relational database, said report-ready table capable of storing multiple events and used by a report generator to generate a report, and said first set of said event fields comprising each of said plurality of event fields that are essential for generation of said report.
Claim 16
Dependent Claim
32 words
A method in accordance with claim 13, comprising: receiving a report query from said report generator; and sending said first set of said said plurality of event fields to said report generator.
Claim 17
Dependent Claim
37 words
A method in accordance with claim 13, comprising: maintaining a count of a number of occurrences of events during a predetermnined time interval of said event type of said event; storing said count in an aggregation table.
Claim 18
Dependent Claim
117 words
A data warehouse for storing network management system events, each of said events comprising one of a plurality of different event types, each of said network management system events comprising a plurality of event fields, said data warehouse comprising: a plurality of related tables each associated with said event, said plurality of related tables comprising a report-ready event table comprising a first set of said plurality of event fields and stored in a relational database, said report-ready table capable of storing multiple events and used by a report generator to generate a report, and said first set of said event fields comprising each of said plurality of event fields that are essential for generation of said report.
Claim 19
Dependent Claim
117 words
A data warehouse for storing network management system events, each of said events comprising one of a plurality of different event types, each of said network management system events comprising a plurality of event fields, said data warehouse comprising: a plurality of related tables each associated with said event, said plurality of related tables comprising a report-ready event table comprising a first set of said plurality of event fields and stored in a relational database, said report-ready table capable of storing multiple events and used by a report generator to generate a report, and said first set of said event fields comprising each of said plurality of event fields that are essential for generation of said report.
Claim 20
Dependent Claim
83 words
A data warehouse in accordance with claim 16, comprising: an export manager configured to receive said event, said export manager comprising formatting means for formatting a first set of said plurality of event fields into a report-ready table, said report-ready table defined according to a reporting type table class, said report-ready table class comprising each of said plurality of event fields that are essential for generation of said report; and a communications interface for sending said report-ready event table to a data warehouse.
Claim 21
Dependent Claim
40 words
A data warehouse in accordance with claim 16, comprising: an aggregation function which maintains an event count, said event count comprising a total number of occurrences of events of said event type of said event during a specified time interval.
Claim 22
Dependent Claim
53 words
A data warehouse in accordance with claim 16, comprising: a filter function, said filter function creating a filter table specifying a condition; wherein said export manager reads said condition, and is responsive to said condition to discard said event without storing said event in said data warehouse if said event matches said condition.
Claim 23
Dependent Claim
28 words
A data warehouse in accordance with claim 16, comprising: a data retrieval interface for retrieving said first set of said plurality of events fields from said report-ready table.
References Cited (Backward Citations)
US5832504A
Cited
US5934909A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-10-24 | 2004-04-24 | 2004-10-24 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-10-24 | 2008-04-24 | 2008-10-24 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-10-24 | 2012-04-24 | 2012-10-24 | $7700.00 | Window Closed / Lapsed |