Computer network management

• US 6,615,201 B1
• Filed: 04/25/2000
• Issued: 09/02/2003
• Est. Priority Date: 04/25/2000
• Status: Expired due to Term

• Current Assignee: WSOU Investments, LLC (WSOU Holdings, LLC)
• Original Assignee: Lucent Technologies, Inc. (Nokia Corporation)
• Inventors: Silberschatz, Abraham, Seshadri, Srinivasan
• Primary Examiner(s): KINDRED, ALFORD W
• Application Number:
  US09/558,425
• Time in Patent Office: 1,225 Days
• Field of Search: 707/1-6, 707/9-10, 707/500, 707/500.1, 707/501.1, 707/513, 709/200-203, 709/217, 709/220, 709/223-225
• US Class Current: 1/1
• CPC Class Codes: H04L 41/0213 Standardised network management protocols, e.g. simple network management protocol [SNMP]
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
• CPC Class Codes: H04L 41/044 comprising hierarchical management structures
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A computer network management arrangement employs enhanced network elements that include database technology. This, in turn, allows such enhanced network elements to filter management information intelligently and also to notify an associated network manager of the occurrence of complex events of interest. More specifically, the network elements are enhanced through use of database technology to process declarative queries and to support triggers. Additionally, auxiliary network managers, that perform as proxies for network elements that have not been enhance with database technology, are employed to collect and integrate management information from one or more non-enhanced network elements. Consequently, the management information supplied to a network manager from the auxiliary network mangers could be significantly less than that collected from the network elements. Thus, the auxiliary network managers further reduce the network management traffic. In a specific embodiment of the invention, support is embedded into the individual network elements for a declarative query language, one example being the structured query language (SQL). Support is also added for event notification to the individual network elements. One or more auxiliary network managers are employed that can answer declarative inquiries. Moreover, the management information base information stored in the individual network elements is modeled as relational tables that are queried.

Claims

1. A method for use with a network management unit to be used in a network management system including at least one enhanced network element to obtain query results the method comprising the steps of:

obtaining an inputted query that is a declarative language query;

determining a set of enhanced network elements required to answer said declarative language query;

computing a query execution plan for each determined enhanced network element;

employing a query optimizer to compute each of said query execution plans;

transmitting an associated computed query execution plan to each determined enhanced network element;

obtaining results of said query execution plans from said at least one determined enhanced network elements;

combining said obtained results to generate a query result; and

displaying said query result;

in said at least one enhanced network element

obtaining a query execution plan from said network management unit, a query that is the basis for said query execution plan being a declarative query language query;

translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls;

employing a SNMP wrapper to translate said declarative query language query to said SNMP calls;

executing said sequence of network management calls to obtain a corresponding sequence of query results and correlating said sequence of query results; and

supplying said correlated query results as an output from said at least one enhanced network element to said network unit.

2. The method as defined in claim 1 wherein said step of executing includes a step of employing an evaluator to effect the execution of said query execution plan.

3. The method as defined in claim 1 wherein said declarative query language is a structured query language (SQL).

4. A method for use in a network management unit to be used in a network management system an auxiliary network manager to obtain query results from one or more network elements, the method comprising the steps of:

obtaining an inputted query that is a declarative language query;

determining a set of auxiliary network management units required to answer said declarative language query;

computing a query execution plan for each determined auxiliary network management unit;

employing a query optimizer to compute each of said query execution plans;

transmitting an associated computed query execution plan to each of said determined auxiliary network management units, if any;

obtaining results of said query execution plans from said determined auxiliary network management units,

combining said obtained results to generate a query result; and

displaying said query result;

in at least one auxiliary network management unit

obtaining a query execution plan from said network management unit, a query that is the basis for said query execution plan being a declarative query language query;

translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls;

employing a SNMP wrapper to translate said declarative query language query to said SNMP calls

sending said sequence of network management calls to one or more network elements;

obtaining results of said sequence of network management calls from said one or more network elements;

combining results of said sequence of network management calls to generate a result of said query execution plan; and

supplying said query execution plan result to said network management unit.

5. The method as defined in claim 4 wherein said step of obtaining results includes a step of employing an evaluator to effect the execution of said query execution plan.

6. The method as defined in claim 4 wherein said step of obtaining results includes a step of employing an evaluator to effect the execution of said query execution plan.

7. A method for use in a network management system comprising the steps of:

obtaining an inputted query that is a declarative language query;

determining a set of enhanced network elements and/or a set of auxiliary network management units required to answer said declarative language query;

computing a query execution plan for each determined enhanced network element and each determined auxiliary network management unit, a query that is the basis for said query execution plan being a declarative query language query;

transmitting an associated computed query execution plan to each determined enhanced network element and to each of said determined auxiliary network management units;

obtaining a query execution plan from a network management unit, a query that is the basis for said query execution plan being a declarative query language query;

each of said determined enhanced network elements

translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls,

employing a SNMP wrapper to translate said declarative query language query to said SNMP calls,and

executing said network management calls to obtain query results; and

supplying said query results as an output from said enhanced network element;

each of said determined auxiliary network management units

obtaining a query execution plan from a network management unit, a query that is the basis for said query execution plan being a declarative query language query,

translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls,

employing a SNMP wrapper to translate said declarative query language query to said SNMP calls,

sending said network management calls to one or more network elements,

obtaining results of said network management calls from said one or more network elements,

combining results of said network management calls to generate a result of said query execution plan, and

supplying said query execution result to said network management unit;

combining said obtained results of said query execution plan from said determined enhanced network elements and said determined auxiliary network management units to generate a query result; and

displaying said query result.

8. The method as defined in claim 7 wherein said declarative language query is a structured query language (SQL) query.

9. The method as defined in claim 7 wherein said declarative query language is a structured query language (SQL).

10. The method as defined in claim 9 wherein said step of translating includes a step of employing a SNMP wrapper for translating said SQL query to said SNMP calls.

11. The method as defined in claim 10 wherein said step of executing includes a step of employing an evaluator to effect the execution of said query execution plan.

12. Apparatus for use in a network management unit to be used in a network management system including at least one enhanced network element to obtain query results, the apparatus comprising:

a first receiver for obtaining an inputted query said query being a declarative language query;

a determination unit for determining a set of enhanced network elements required to answer said declarative language query;

a query optimizer for computing a query execution plan for said at least one determined enhanced network element;

a transmitter for transmitting an associated computed query execution plan to said at least one determined enhanced network element;

a second receiver for obtaining results of said query execution plans from said determined enhanced network elements;

a combiner for combining said obtained results to generate a query result; and

a display for displaying said query result;

in said at least one enhanced network element;

a receiver for obtaining a query execution plan from a said network management unit, a query that is the basis for said query execution plan being a declarative query language query;

a translator for translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls, said translator employing a SNMP wrapper to translate said declarative query language query to said sequence of SNMP calls;

an evaluator for executing said network management calls to obtain query results and for correlating said query results; and

a transmitter for supplying said correlated query results as an output from said at least one enhanced network element to said network management unit.

13. Apparatus for use in a network management unit to be used in a network management system including at least one auxiliary network manager to obtain query results from one or more network elements, the apparatus comprising:

a first receiver for obtaining an inputted query, said query being a declarative language query;

a determination unit for determining a set of auxiliary management units required to answer said declarative language query;

a query optimizer for computing a query execution plan for said at least one determined auxiliary management unit;

a transmitter for transmitting an associated computed query execution plan to said at least one determined auxiliary management unit;

a second receiver for obtaining results of said query execution plans from said determined auxiliary management units;

a combiner for combining said obtained results to generate a query result; and

a display for displaying said query result;

in said at least one auxiliary management unit;

a first receiver for obtaining a query execution plan from said network management unit, a query that is the basis for said query execution plan is a declarative query language query;

a translator for translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls, said translator including a SNMP wrapper for translating said declarative query language query to said sequence of SNMP calls;

a first transmitter for sending said sequence of network management calls to one or more network elements;

a second receiver obtaining results of said network management calls from said one or more network elements;

a combiner for combining results of said network management calls to generate a result of said query execution plan; and

a second transmitter for supplying said query execution result to said network management unit.

14. The apparatus as defined in claim 13 wherein said declarative query language is a structured query language (SQL).

15. Apparatus for use in a network management system comprising:

a first receiver for obtaining an inputted query that is a declarative language query;

a determination unit for determining a set of enhanced network elements and/or a set of auxiliary network management units required to answer said declarative language query;

a query optimizer for computing a query execution plan for each determined enhanced network element and each determined auxiliary network management unit, a query that is the basis for said query execution plan being a declarative query language query;

a first transmitter for transmitting an associated computed query execution plan to each determined enhanced network element and to each of said determined auxiliary network management units;

a second receiver for obtaining a query execution plan from a network management unit, a query that is the basis for said query execution plan being a declarative query language query;

each of said determined enhanced network elements including

a first translator for translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls, said translator including a SNMP wrapper to translate said declarative query language query to said SNMP calls, and

a first evaluator for executing said network management calls to obtain query results; and

a second transmitter for supplying said query results as an output from said enhanced network element;

each of said determined auxiliary network management units including

a third receiver for obtaining a query execution plan from a network management unit, a query that is the basis for said query execution plan being a declarative query language query,

a second translator for translating said query execution plan into a sequence of network management calls that are simple network management protocol (SNMP) calls and including a SNMP wrapper to translate said declarative query language query to said SNMP calls,

a third transmitter for sending said network management calls to one or more network elements,

a fourth receiver for obtaining results of said network management calls from said one or more network elements,

a first combiner for combining results of said network management calls to generate a result of said query execution plan, and

a fourth transmitter for supplying said query execution result to said network management unit;

a second combiner for combining said obtained results of said query execution plan from said determined enhanced network elements and said determined auxiliary network management units to generate a query result; and

a display for displaying said query result.

16. The apparatus as defined in claim 15 wherein said declarative language query is a structured query language (SQL) query.

17. The apparatus as defined in claim 15 wherein said declarative query language is a structured query language (SQL).

18. The apparatus as defined in claim 17 wherein said step of translating includes a step of employing a SNMP wrapper for translating said SQL query to said SNMP calls.