Dynamic translation of network management primitives to queries to a database

• US 5,317,742 A
• Filed: 06/21/1991
• Issued: 05/31/1994
• Est. Priority Date: 06/21/1991
• Status: Expired due to Fees

• Current Assignee: Racal-Datacom, Inc. (Thales SA)
• Original Assignee: Racal-Datacom, Inc. (Thales SA)
• Inventors: Bapat, Subodh
• Primary Examiner(s): Shaw, Gareth D.
• Assistant Examiner(s): BACKENSTOSE, JONATHAN
• Application Number:
  US07/719,214
• Time in Patent Office: 1,075 Days
• Field of Search: 395/700
• US Class Current: 707/714
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/959 Network
• 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 technique for dynamically translating network management primitives into operations on management information stored within a relational database hosting a management information base. A CMIP network management operation and argument is retrieved from a network management processing machine and processed by a full or partial OSI stack. The CMIP operation is examined to ascertain a type of network management operation. If the operation is of a type which interacts with the database, a database query is generated in accordance with the operation type, to perform the network management operation on the relational database.

Claims

1. A method for translating Common Management Information Protocol (CMIP) network management operations using a digital computer, comprising in combination the steps of:

retrieving a network management operation and argument from a network management processing machine;

ascertaining if said network management operation comprises one m-Create, m-Delete, m-Set, m-Get and m-Event Report CMIP operations;

translating said ascertained CMIP operation into a database query, said database query being a Structured Query Language (SQL) query; and

executing said database query with respect to a relational database.

2. The method of claim 1, wherein said translating step generates said database query based upon the CMIP operation in accordance with the following:

space="preserve" listing-type="tabular">______________________________________ CMIP Operation SQL Query ______________________________________ m-Create INSERT INTO (table.sub.-- name) . . . m-Delete DELETE FROM (table.sub.-- name) WHERE . . . m-Get SELECT FROM (table.sub.-- name) WHERE . . . m-Set UPDATE (table.sub.-- name) SET . . . m-EventReport INSERT INTO (table.sub.-- name) . . . ______________________________________

where (table_-- name) represents a name of a database table on which the SQL query is to be performed.

3. The method of claim 1, further comprising the step of ascertaining whether or not said network management operation is of a type which interfaces with said relational database.

4. The method of claim 1, further comprising processing said network management operation on an Open System Interconnection (OSI) protocol stack.

5. The method of claim 4, wherein said OSI protocol stack is a full OSI protocol stack having all layers present.

6. The method of claim 4, wherein said OSI protocol stack is a partial OSI protocol stack having at least one layer missing.

7. The method of claim 1, further comprising processing said network management operation on a protocol stack which is not an Open System Interconnection (OSI) protocol stack.

8. The method of claim 1, wherein said generating step includes joining a plurality of database tables and creating a query that spans said joined tables.

9. The method of claim 1, wherein said generating step generates a query against a view of a plurality of database tables.

10. The method of claim 1, further comprising the step of executing said database query against said database.

11. The method of claim 1, further comprising the steps of:

obtaining a result from said executed step;

analyzing said result to determine if further database queries are required to satisfy said network management operation; and

if said analyzing step requires an additional database query, issuing said additional database query.

12. An apparatus for translating a Common Management Information Protocol (CMIP) network management operation into a database query, comprising:

a database containing information relevant to said network management operation;

receiving means for receiving said network management operation;

decoding and analyzing means for determining if said network management operation is one of m-Create, m-Delete, m-Set, m-Get and m-Event Report CMIP operations;

translating means for for converting said decoded CMIP operation to a Structured Query Language (SQL) database query corresponding to the ascertained type of said CMIP operation; and

means for executing said database query in a relational database.

13. The apparatus of claim 12, wherein said decoding means comprises a full or partial Open System Interconnection (OSI) protocol stack.

14. The apparatus of claim 12, wherein said analyzing means comprises a CMIP protocol machine.

15. An apparatus for translating a Common Management Information Protocol (CMIP) network management operation into a database query, comprising:

a relational database containing information relevant to said network management operation, said relational database being compatible with Structured Query Language (SQL) queries,

an Open System Interconnection (OSI) interface for receiving said CMIP network management operation;

an OSI protocol stack for decoding said network management operation;

a CMIP protocol machine for analyzing said decoded network management operation to determine if said decoded network management operation requires interaction with said database;

translating means for converting said decoded and analyzed network management operation into a SQL database query.