Data base access method and system in management information base of network management protocol

• US 20030110261A1
• Filed: 11/15/2002
• Published: 06/12/2003
• Est. Priority Date: 12/12/2001
• Status: Active Grant

• Current Assignee: Samsung Electronics Co. Ltd.
• Original Assignee: Samsung Electronics Co. Ltd.
• Inventors: Seo, Kwang-Tae, Shin, Hyo-Shin
• Granted Patent: US 7,200,653 B2
• Time in Patent Office: Days
• US Class Current: 709/225
• CPC Class Codes: H04L 41/0213 Standardised network management protocols, e.g. simple network management protocol [SNMP]
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Disclosed is a data base access method and system that can easily access a data base (DB) in a management information base (MIB) of a simple network management protocol (SNMP) or a common management information protocol (CMIP). The method includes making contents of the MIB into an MBean class where members of m_Attrs, m_AttrName, and m_AttrType including information of the MIB and member functions for accessing these members, and members of m_DBJob and m_ConditionClause for a data base (DB) work and member functions for accessing these members exist, extracting an MIB-based class by compiling the MBean class, inputting an MIB-related instruction to use the extracted MIB-based class, performing a corresponding operation such as a data readout from the MIB if the instruction does not refer to a DB operation, loading the extracted MIB-based class and a smart view DB class SvDB including common information required for a DB access if the instruction refers to the DB operation, and accessing the DB by obtaining a DB name and instruction name and type from the MIB-based class. According to the method, the DB can be easily accessed without changing a DB API even if the MIB is changed.

Claims

1. A data base access method in a management information base (MIB) of a simple network management protocol (SNMP) or a common management information protocol (CMIP), the method comprising the steps of:

generating an MIB-based class comprising contents of the MIB by compiling the contents of the MIB;

inputting an MIB-related instruction to use the MIB-based class;

performing a corresponding instruction using the MIB-based class when the instruction does not refer to a data base operation;

loading the MIB-based class for the corresponding instruction and a smart view DB class comprising common information required for the data base access when the instruction refers to the data base operation; and

accessing the necessary data base by obtaining a table name and column name and type of the data base stored in the MIB-based class.

2. A data base access method in a management information base (MIB) of a simple network management protocol (SNMP) or a common management information protocol (CMIP), the method comprising the steps of:

making contents of the MIB into an MBean class where members of m_Attrs, m_AttrName, and m_AttrType comprising information of the MIB and member functions accessing these members, and members of m_DBJob and m_ConditionClause for a data base work and member functions for accessing these members exist;

extracting an MIB-based class by compiling the MBean class made in the making contents step;

inputting an MIB-related instruction to use the extracted MIB-based class (i.e., a data base (DB) table name, column name, and column type);

performing a corresponding operation such as a data readout from the MIB when the instruction inputted at the above step does not refer to a DB operation;

loading the extracted MIB-based class and a smart view DB class SvDB comprising common information required for a DB access when the instruction refers to the DB operation in the performing step; and

accessing the DB by obtaining a DB name and instruction name and type from the MIB-based class.

3. The method of claim 2, said method being absent alteration of the SvDB.

4. A data base access system of a simple network management protocol (SNMP) or a common management information protocol (CMIP) provided with the system comprising:

a management information base (MIB);

a plurality of MIB-based classes;

a plurality of MIB-based data base (DB) tables corresponding to respective ones of said plurality of MIB-based classes,

an Mbean class making contents of the MIB into the MBean class where members of m_Attrs, m_AttrName, and m_AttrType including information of the MIB and member functions for accessing these members, and members of m_DBJob and m_ConditionClause for a DB work and member functions for accessing these members exist;

an MIB compiler extracting DB information (i.e., a DB table name, column name, and column type) including the MIB from the MIB-based classes by the MIB compiler compiling the MBean class; and

a data base application programming interface (DB-API) accessing the DB by loading the extracted DB information comprising the MIB and a smart view DB class SvDB comprising common information required for a DB access when an inputted execution instruction refers to a DB operation, and obtaining a DB name and instruction name and type from the DB information including the MIB.

5. The system of claim 4, said MIB compiler being disposed between said MIB and each one of said plurality of MIB-based classes.

6. The system of claim 5, said DB-API being disposed between said plurality of MIB-based classes and said plurality of MIB-based data base tables.