KR100507798B1 - apparatus and method for generating database table of Management Information Base - Google Patents

Abstract

The apparatus and method for generating a MIB database table according to the present invention are a module for compiling an arbitrary MIB in a manager of a network management system to generate a table of a MIB database. Based on the members of the statement and any base classes that define member functions that call them, the MIB compiler generates a class that compiles the MIB and inherits each class that inherits the base classes based on the attributes that exist in the MIB. It is composed of one API that creates database table corresponding to each class and grasps management type of each generated class and performs database operation accordingly. Determine the type of work and write the necessary statements in the database accordingly As, MIB changes, or even change the type of class DB API can also be accessed the database without changing.

Description

Apparatus and method for generating database table of Management Information Base}

The present invention relates to an apparatus and method for generating a database table 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, and the management information base data that allows each class to be processed through one API even if the number of classes generated by the compiler increases in managing MIB information. An object of the present invention is to provide an apparatus and method for generating a base table.

According to an aspect of the apparatus for generating a table of the MIB database by compiling any MIB in the manager of the network management system according to the present invention for achieving this object, the type of the database management operation for the MIB and the members of the conditional statement And a MIB compiler that compiles the MIB and generates each class that inherits the base class based on the attributes that exist in the MIB, based on any base class that has a defined member function that calls and its members. It creates a database table, and includes one API that grasps the management work type of each generated class and performs the database work accordingly. On the other hand, according to one aspect of the method for generating a table of the MIB database by compiling any MIB in the manager of the network management system according to the present invention, the type of the database management operation and the member of the conditional statement for the MIB and calling the member Based on any base class in which a member function is defined, compiling the MIB to generate each class that inherits the base class according to attributes present in the MIB; Generating a database table corresponding to each of the generated classes, and identifying a management task type of each of the generated classes and performing a 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 in SvDB Class is to make Mbean value itself not to be called 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 the same name for each MIB-based class (30) is defined. 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, set the data command required by the MIB-based class (30) that inherits the MBean class 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.

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.

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.

Claims (10)

An apparatus for generating a table of a MIB database by compiling arbitrary MIBs in a manager of a network management system, The MIB is compiled and inherited from the base class according to the attributes present in the MIB based on a type of database management operation for the MIB, a member of a conditional statement, and a member class that calls a member function. A MIB compiler that generates each class, An apparatus for generating a database table of a MIB, comprising: an API for generating a database table corresponding to each of the generated classes, and grasping a management task type of each generated class and performing a database operation accordingly. The method of claim 1, wherein the type of management operation is A device for generating a database table in a MIB that includes at least one of insert, delete, update, and select operations. The method of claim 1, wherein the base class, And at least one of an attrit, an attrit name, an attrit type, a type of management task, a member including a conditional clause, and a member function for calling the member. The method of claim 1, wherein the API, A device for generating a database table of a MIB including a member function that performs a database update or a query for generating a list according to a management task type of a corresponding class. The method of claim 4, wherein in the API, When the management task type is one of insert, delete, and update, a member function for performing the update is called. If the management task type is a select task, a list is provided. Database table generation device of the MIB that calls a member function that performs a query operation to create a.  In the method of generating a table of the MIB database by compiling any MIB in the manager of the network management system, Compile the MIB and inherit the base class according to the attributes that exist in the MIB based on the type of database management work for the MIB, the member of the conditional statement, and any base class that defines the member function that calls the member. Generating each class; Generating a database table corresponding to each of the generated classes, and identifying a management task type of each of the generated classes and performing a database operation according to the generated class table. The method of claim 6, wherein the type of management operation, A method of creating a database table in a MIB that includes at least one of insert, delete, update, and select operations. The method of claim 6, wherein the base class, A method of creating a database table for a MIB, comprising at least one of an assertion, an assertion name, an assertion type, a type of management task, a member including a conditional clause, and a member function that calls the member. The method of claim 6 or 8, wherein performing the database operation comprises: A method of creating a database table of a MIB by performing a database update or a query for generating a list according to the management operation type of the class by using the member function. The method of claim 9, wherein in the step of performing the database operation: When the management task type is one of insert, delete, and update, a member function for performing the update is called. If the management task type is a select task, a list is provided. How to create a database table in the MIB that calls a member function that performs a query operation to create a query.