KR20040075382A - module for generating database table of Management Information Base - Google Patents

Abstract

PURPOSE: A module for generating a database table of an MIB(Management Information Base) is provided to process each class through one API(Application Program Interface) even if a number of the classes generated by a complier is increased. CONSTITUTION: An MIB compiler(20) succeeds to the basic class depending on an attribute existing in the MIB(10) by compiling the MIB based on a sort of a database management task for the MIB, a member of the MIB, and the basic class that a member function calling the member is defined. While generating the database table matched with each generated class(30), a table generating module comprises one API(40) executing the database task by understanding the sort of a management task of each generated class.

Description

Module for generating database table of Management Information Base

The present invention relates to a database table generation module of a management information base.

As networks grow in size, management of network equipment has become an indispensable element in many areas.

In general, network management systems use the Simple Network Management Protocol (SNMP) to manage and monitor network devices.

SNMP is a network management protocol developed by the Internet Engineering Task Force (IETF). It is a network management protocol, Manager (not shown), which is a network system management program, and Agent (not shown), which is a top-level program of network equipment. Management information bases are interchangeable, allowing network equipment to be managed externally.

There are four basic commands in this protocol: 'get' and 'get-next' for viewing network device information from outside, 'set' for changing information, and events specific to the external management system. ) Traps to inform.

MIB is a formal expression for storing network management information in SNMP or CMIP.

The format of the MIB is defined as part of SNMP. MIB-I refers to the initial MIB definition, and MIB-II refers to the current definition. SNMPv2 includes MIB-II and adds some new objects.

In order to store such MIB information in a database, tables related to the database must be created, and these database tables are manually created by a programmer.

If any alarm occurs, the SNMP agent converts the alarm information into the MIB format and sends it to the SNMP manager. The SNMP manager analyzes any MIB information transmitted from the SNMP agent, identifies the operation status of the agent, and performs management accordingly.

Therefore, when any management information is received from any agent, the manager must have a foundation for accessing the MIB database in order to interpret the information.

1 is a functional block diagram of a program for processing MIB information in a conventional manager.

Looking at the software functional block implemented in the conventional manager with reference to Figure 1, the MIB (1) defined in any format, the compiler (2) for compiling the MIB, and each of the generated by the compiler (2) Class 3, MIB based DB table 5 generated corresponding to each class 3, and each API (Application Program Interface) 4 for generating the MIB based DB table 5 do.

In general, a MIB-based program uses a separately defined structure or class (3) to represent information defined in the MIB.

Such a structure or class 3 is generally generated automatically by using the MIB compiler 2. The MIB compiler 2 compiles the information defined in the MIB 1 to generate a separately defined structure or class 3. The generated classes 3 should have a table related to a database to store arbitrary MIB information through each DB API 4, and these database tables are created manually by the programmer.

API (4) is an abstract concept that makes it easy to access an operating system (OS) service or protocol. It is a library of various functions used internally. Application programs typically use APIs to request low-level services of the operating system, such as data communications, data recovery, and system resource access.

In this way, each class has a separate API (4) (A, B, C ...) to execute each API to form a respective database table.

Therefore, when the number of classes is small, it is less expensive to generate APIs individually. However, when the number of classes is large, generating each API is inefficient for the system. That is, in order to access the database using automatically generated structures or classes, the DB API corresponding to each structure or class must be changed together, so if the number of classes increases, the DB API that must be changed manually increases. There is a problem in the operation of the.

The present invention has been made to solve such a conventional problem, the management information base database to manage each class through a single API even if the number of classes generated by the compiler in managing the MIB information increases Its purpose is to provide a table creation method and a system therefor.

1 is a functional block diagram of a program for processing MIB information in a manager of a conventional network management system.

2 is a functional block diagram of a program for processing MIB information in a manager of a network management system according to the present invention.

FIG. 3 is a diagram illustrating an example of a MIB-based class in FIG. 2. FIG.

4 is a view showing a DB API in FIG.

FIG. 5 is a diagram illustrating an example of a structure of a MIB, a MIB-based class, and a MIB-based DB table shown in FIG. 2; FIG.

According to an aspect of the present invention for achieving this object, in a module for compiling any MIB in the manager of the network management system to generate a table of the MIB database, the type and conditional statement of the database management operation for the MIB Based on any base class that has a member and a member function that calls that member, a MIB compiler that compiles the MIB and generates each class that inherits the base class based on the attributes present in the MIB, and each generated class Provides a database table generation module of a MIB composed of one API that creates a corresponding database table and grasps management type of each generated class and performs database operation accordingly.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

2 is a functional block diagram of a program for processing MIB information in a manager of a network management system according to the present invention.

Looking at the software function block implemented in the manager according to the present invention with reference to Figure 2, the MIB 10 defined in any format, the compiler 20 for compiling the MIB, and the generated by the compiler 20 Each class 30, one API 40 for generating a database table corresponding to each class 30, and each MIB base generated by the API 40 corresponding to each class 30 It consists of a DB table 50.

When any MIB information (for example, alarm information) is received from the agent by the manager having the MIB database table generation module configured as described above, the alarm information is projected onto the MIB-based class 30.

From this alarm information, you can see that it consists of the alarm time, alarm content, alarm level, alarm addition content (for example, please restore it soon), and store this information in some parts of the database. The manager can read the information about the operation status of the equipment.

FIG. 3 is a diagram illustrating an example of a MIB-based class in FIG. 2 and is referred to as an MBean (hereinafter, referred to as an MBean) for convenience.

Each class 30 generated by the MIB compiler 20 inherits a base class (MBean Class) as shown in FIG.

That is, MBean Class consists of each member of attribute (m_Attrs), attribute name (m_AttrName), attribute type (m_AttrType) that contains MIB information and member functions that access them.

It also has a member (m_DBJob) that indicates the type of job for the database job, a condition clause member (m_ConditionClause) that needs to execute the conditional clause, and a member function that accesses them.

In the figure, the upper part represents a member, and the lower part represents a member function for accessing the member.

Here, the member (m_DBJob) for working with the database may include an insert operation, a delete operation, an update operation, and a select operation.

Here, when the MIB compiler compiles the MIB and generates each class according to the attributes present in the MIB, it is defined in the API 40 that each member is able to indicate the type of operation for managing the DB. When you read the based class (30), it is to identify the database management commands issued to that class.

This allows the MIB 10 to be changed or the MIB-based class 30 to be modified by reading each class in one API to determine the kind of work defined in that class and writing the necessary statements in the database accordingly. Even if it is changed, it is possible to access the database corresponding to each MIB-based class 30 with only one DB API 40.

In addition, the condition clause is defined in order to set a condition for deletion or update as the deletion or update operation cannot be deleted in a batch.

FIG. 4 is a diagram illustrating a DB API in FIG. 2, and is described as SvDB Class as an example in the drawing. In other words, SvDB Class represents a class that provides a common DB API for accessing a database. As shown, the SvDB class contains several member functions for accessing the database.

The characteristic of this member function is to call Mbean value when performing update or query operation (+ execute Update, + execute Query). In other words, the value called by SvDB Class is to make the Mbean value itself call, not the value specified during insert, delete, update, and select.

Therefore, if the operation to read Mbean value and execute to the class is insert operation, insert operation is executed. If delete operation is performed, delete operation is executed, and update operation or select operation is performed. If is to be able to perform the corresponding operation.

That is, SvDB Class is defined to call Mbean value. Accordingly, each MIB-based classes inheriting the Mbean class provide the member functions necessary for accessing the database, and when the database is interworked, the MIB-based classes are received to generate the necessary statements in the database.

Thus, a particular class is assigned a value corresponding to this type of task. For example, referring to FIG. 5, an example of an MBean that selects each class is shown.

That is, when all classes derived from the MIB shown in FIG. 5 are configured by inheriting the MBean class like the System class, are the sub-attributes of the system of mib-2 defined as the System class by inheriting the MBean class? Indicates.

In addition, the MIB-based DB table shown in FIG. 5 (shown as a sytem table at the bottom of the figure) exists as a DB table having the same name as defined in the MIB.

As described above, MIB-based classes (30) inheriting the MBean class are defined according to the attributes present in the MIB when one MIB is given, and each MIB-based class (30) has the same name. There is a MIB-based DB Table with type and type.

These are all automatically generated in a predefined format using the MIB compiler 20, and when necessary to interwork with the database, the necessary database work can be performed using the SvDB class.

Next, the operation of the MIB compiler will be described.

First, the data command required by the MIB-based class (30) that inherits the MBean class is set using the setDB job member function.

Next, set each required attribute according to the database command you set.

That is, in the case of an Insert command, all attributes for inserting into the database are set using the setXXX member functions.

On the other hand, in the case of the Delete command, m_ConditonClause sets a conditional statement for deleting from the database.

On the other hand, in the case of the Update command, the setXXX member function sets the values of all the attributes required to update the database, and m_ConditionClause if necessary.

On the other hand, in the case of the Select command, all attributes to be selected in the database are set to the getXXX member function, and m_CondtionClause is also set if necessary.

Then, the member function call of SvDB is made according to the database command set in any MIB-based class 30. That is, in the case of Insert, Delete, and update commands, the executeUpdate member function of SvDB is called, and in the case of Select command, the executeQuery member function of SvDB is called.

Here, SvDB's executeUpdate function obtains the name, type, and value of the selected attribute of the MIB-based class, by using the getName, getAttrName, getAttrType, and getValueAt functions of the MBean class.

Also, if the condition clause is selected, the value of m_ConditionClause is also obtained.

Combine these values to complete the statements you need for your database.

Using the completed database statement, the SvDB class executes the database command and returns the result.

On the other hand, SvDB's executeQuery function gets the name, type, and value of the selected attribute of the MIB-based class by using getName, getAttrName, and getAttrType functions of the MBean class.

In addition, when the condition clause is selected, the value of m_ConditionClause is also obtained.

Combine these values to complete the statements you need for your database.

Using the completed database statement, the SvDB class executes database commands and stores the results in a list and returns them.

On the other hand, when a change occurs in the attributes present in the MIB 10, the MIB compiler 20 inherits the base class and generates the MIB-based class 30 accordingly, thereby creating the MIB-based class 30 The content of the configuration and the number thereof may be changed.

However, even in this case, the member function defined in the API 30 is defined to call the base class Mbean value, so that the corresponding MIB-based class 30 is read to request the corresponding MIB-based class 30. You will be able to perform database management tasks.

According to the present invention, when the MIB compiler compiles the MIB and generates each class according to the attributes present in the MIB, a member capable of indicating the type of operation for managing the DB, and a deletion or update operation are required. Using the base class where conditional member is defined, by reading each class in one API, grasping the kind of work defined in the class, and writing the necessary statements in the database accordingly, the MIB is changed or the kind of class is changed. If changed, the database API can be accessed without changing the DB API.

Claims (5)

A module for compiling an arbitrary MIB in a manager of a network management system to generate a table of a MIB database. Compile the MIB and inherit the base class according to the attributes present in the MIB, based on the type of database management work for the MIB, the member of the condition statement, and any base class that defines the member function that calls the member. A MIB compiler that generates each class A database table generation module of the MIB, comprising one API that generates a database table corresponding to each of the generated classes, and grasps a management task type of each generated class and performs a database operation accordingly. The method of claim 1, wherein the type of management operation is Module for creating database tables in the MIB, including inserts, deletes, updates, and selects. The method of claim 1, wherein the base class, A member containing an assertion, an assertion name, an assertion type, a type of administrative task, a conditional clause, A database table generation module of a MIB including a member function for calling the member. The method of claim 1, wherein the API, Database table generation module of MIB including member function to update the database or query the list according to the management task of the class. The method of claim 4, wherein when the management task type is one of insert, delete, and update, a member function for performing the update is called, and the management task type is select. The database table generation module of the MIB, in which case it calls a member function that performs a query operation to generate a list.