KR100461353B1 - A gateway system and an operating method for managing the integrated network by using a database connection pool - Google Patents

Abstract

The integrated network management gateway system using the database connection pool of the present invention and its operation method reduce the database processing time and process the database by processing the database work through the integrated network management gateway system using the database connection pool in a distributed network environment. The present invention relates to an integrated network management gateway system and its operation method for improving the performance. The present invention provides an integrated network management gateway system using a database connection pool having its own database, which stores a database connection including a pointer of the database information table of its own, and returns the database connection after a database operation. A database connection manager means for generating a plurality of database connection pools, the database connection pool having a predetermined number of database connections, and obtaining and managing pointers included in the database connections from the generated database connection pools, and the database connections Receiving a pointer of the database connection from the manager means and performing a corresponding database operation through a database connection corresponding to the pointer and after completion of the database The connection comprises a servlet means for returning the database to the connection pool.

Description

A GATEWAY SYSTEM AND AN OPERATING METHOD FOR MANAGING THE INTEGRATED NETWORK BY USING A DATABASE CONNECTION POOL}

The present invention relates to an integrated network management gateway system using a database connection pool and a method of operating the same. More specifically, a database access pool including a predetermined number of database connections in a distributed network environment and accessing a database including network management information is provided. The present invention relates to an integrated network management gateway system for reducing database processing time and improving performance by using the database connection stored in the database connection pool.

Recently, due to the rapid development of information and communication, the management of the network environment is becoming more complicated and difficult. Furthermore, efforts to provide faster and more accurate information in the integrated network environment where various types of communication services are provided through various interfaces are integrated. It's happening continuously. In addition, the proportion of the integrated network management system that integrates and manages the network management system that manages various networks is gradually increasing. In particular, the integrated network management gateway system plays an important role in the integrated network management system that provides an interface with a plurality of individual network management systems in a distributed network environment to integrate and manage the plurality of network management systems.

In general, a gateway system is a network point serving as an entrance to another network, and converts data transmitted between the two communication networks into data suitable for each communication network between two communication networks using different data communication protocols. A system that performs a function. Recently, by developing the integrated network management gateway system, a connection between a plurality of network management systems having a plurality of characteristics and an integrated network management system are received, and commands are performed to perform functions such as processing, storing, and calculating data necessary for network management. do.

The conventional integrated network management gateway system is a system that performs an integrated network management system on a plurality of network management systems, and performs a network management function with a consistent interface with the integrated network management system on an individual network management system. In such an integrated network management system, a gateway system receiving a command performs a network management function command required regardless of the characteristics of an individual network management system. In addition, these gateway systems have their own database for data necessary for network management, such as command and network configuration, faults and performance. And as instruction throughput and data increases, so does database access and operations.

Technologies related to these database connections and access include ODBC and JDBC. The ODBC (ODBC) is a standard open application program interface for accessing a database, and can be accessed and used by any application regardless of a database management system (DBMS). It is the first technology to make it possible. It is a standard method developed by Microsoft. The ODBC makes this possible by placing a database processing program between an application and a database management system (DBMS). If you use the ODBC statement in the program, you can access various types of databases such as MS-Access, dBase, DB2, Excel, Text, etc. In addition to the ODBC software, this requires a separate module or driver for each database to be accessed, but it allows database access even if the program does not know about the database's proprietary interface.

In addition, JDBC (JDBC; JAVA DataBase Connetctivity (hereinafter referred to as JDBC)) is an application program interface standard for connecting a program written in Java to a general database. In the Java program, a database query statement (SQL) is called SQL. Java application programming interface (API) for executing. The JDBC provides a standard API for database and application developers and allows you to create database applications with pure Java APIs. This JDBC makes it easy to use SQL statements in any relational database. You can write just one program and send SQL statements from the program to the appropriate database.

However, in the related art, when the gateway system connects to a database for command processing, a method of creating a new connection for each command and releasing the connection after the transaction is terminated has been used. As a result, performance degradation related to the database connection occurred, such as an increase in response time due to the time taken for each database connection.

The above ODBC and JDBC 2.0 did not support a database connection pool and provided the above-described interface.

In order to solve the above problems, the present invention reduces database processing time by creating a database connection pool having a certain number of database connections in a distributed network environment and using database connections stored in the database connection pool when accessing a database. The purpose of the present invention is to provide an integrated network management gateway system and its operation method.

1 is a block diagram according to an embodiment of an integrated network management gateway system connection according to the present invention.

2 is a flowchart of a database command processing of the gateway system according to the present invention.

3 is a flowchart illustrating a process of a database connection manager according to the present invention.

4 is a flowchart illustrating an operation of an integrated network management gateway system according to the present invention.

Explanation of symbols on the main parts of the drawings

10: integrated network management system 20: integrated network management gateway system

21: Servlet 22: Database Connection Manager

23 (23a ~ 23n): Database connection pool 24: Database

30: network management system

According to an aspect of the present invention, there is provided an integrated network management gateway system using a database connection pool that connects a plurality of network management systems and an integrated network management system in a distributed network environment and has its own database.

A plurality of database connection pools for retrieving and storing a database connection including a pointer to the own database information table and returning the database connection after a database operation;

Load and register a JDBC driver, create the database connection pool with a predetermined number of database connections according to the properties of the properties file of the database connection pool, and include in the database connection from the created database connection pool. Database connection manager means for obtaining and managing a stored pointer; And

And a servlet means for receiving a pointer of the database connection from the database connection manager means, performing a corresponding database operation through a database connection corresponding to the pointer, and returning the database connection to the database connection pool when the operation is completed. .

In addition, in order to achieve the above object, the present invention provides a method for operating an integrated network management gateway system using a database connection pool having its own database.

A first step of creating a database connection including a pointer to the own database information table by creating a plurality of database connection pools at an initial operation of the system;

A second step of a servlet obtaining a corresponding pointer from the database connection pool in response to a command;

A third step of acquiring a corresponding database connection by using a pointer of the obtained database connection pool and processing a subsequent database job through the obtained database connection; And

And when the processing of the database job is completed, returning the obtained database connection to the database connection pool.

The present invention provides an integrated network management gateway system using a database connection pool for reducing database processing time and improving performance by processing database operations through an integrated network management gateway system using a database connection pool in a distributed network environment. It is about the operation method.

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

1 is a block diagram of an integrated network management gateway system connection according to an embodiment of the present invention, which is a block diagram of an integrated network management system, a gateway system, and an individual network management system to which the present invention is applied. As shown in FIG. 1, the integrated network management system 10 is connected to the network management system 30 through the integrated network management gateway system 20 and exchanges various data for network management between them. The integrated network management gateway system 20 includes a servlet 21, a database connection manager 22, a plurality of database connection pools 23, and a database 24.

When the integrated network management system 10 performs a command and transmits the result to the integrated network management gateway system 20, the servlet 210 in the integrated network management gateway system 20 receives data about the command. Each operation of the command is performed on the database 24 and the network management system 30. When performing a database related operation according to the result of the received command, the servlet 21 obtains a reference of the database connection manager 22. The servlet 21 obtains a database connection from a database connection pool 23 through a database connection manager 22, accesses the database 24 to perform a related database operation, and then connects the database connection. Return to pool 23.

The database connection pool 23 serves to get or return a database connection as described above, and releases all resources and closes the connection in shutdown. It also handles connection failures, such as timeouts and poor communication, and limits connections that exceed the preset maximum in the database connection pool 23.

In addition, the database connection manager 22 is responsible for managing a plurality of database connection pool 23. This loads and registers the JDBC driver and creates the database connection pool 23 according to the attributes defined in the properties file. The database connection pool name is mapped to the database connection pool 23 instance, and all the connection pools are terminated after the final request is performed while monitoring the requests for the database connection pool 23.

The operation flow of the integrated network management system will be described with reference to FIG. 2.

2 is a flowchart of a database command processing of the gateway system according to the present invention.

First, the integrated network management system 10 has its own database 24 for storing data necessary for network management, such as network configuration and shape information, subscriber information, performance information, and failure information, such as a data exchanger, in a table form. The database 24 also stores the results of adding, deleting and changing information about the individual network management system 30.

The database connection pool 23 includes a key of the network management information table stored in the database 24. This is generated by the database connection manager 22 in a predetermined number of frequently applied tables. When the database connection manager 22 is initialized, the database connection pool 23 generates the database connection pool 23 having the predetermined number of database connections as described above (S402), and obtains and manages a pointer from the database connection pool 23. (S403). Here, when the servlet 21 initializes (S401), the database connection manager 22 is also initialized.

The servlet 21 receives a command from the integrated network management system 10 and is responsible for connecting and releasing a database for access to a database. In addition, when the servlet 21 accesses the database 24 to perform a task related to the database 24 according to a command received from the integrated network management system 10, the database connection manager 22 ) Transfers the database connection of the database connection pool 23 to the servlet 21. In this way, the servlet 21 obtains a pointer from the database connection manager 22 (S404).

In addition, the servlet 21 accesses the database 24 through the database connection using the obtained pointer (S405a to S405n) and then performs the related database operation (S406a to S406n).

Thereafter, when all database operations are completed, the servlet 21 returns the database connection to the database connection pool 23.

As such, since the database connection manager 22 creates a database connection of the table pointer of the database 24, a large number of the servlets can reduce the time taken for each connection when requesting a database connection. .

The database connection manager 22 of the present invention loads and registers a JDBC driver, creates the plurality of database connection pools 23 according to the properties of a specified properties file, and requests the plurality of databases at the request of the servlet 21. The database connection is obtained from the connection pool 23 and the database connection is returned to the plurality of database connection pools 23.

3 is a flowchart illustrating a process of a database connection manager according to the present invention. First, the database connection manager 22 receives an initialization command from the servlet 21 (S1). Subsequently, the database connection manager 22 loads and registers a JDBC driver and generates database connection pools 23a to 23n by referring to a property file having values defining a database connection pool (S2). Thereafter, the servlet 21 receives a database connection request (S3).

Subsequently, the database connection manager 22 receives a database connection from the generated database connection pools 23a to 23n and transfers the database connection to the servlet 21 (S4).

When the database processing task in the servlet 210 is finished, the database connection manager 22 receives a return command of the database connection (S5). Then, the database connection manager 22 returns the database connection to the database connection pool 23 (S6). At the end of the database connection manager 22, the database connection of all the database connection pools 23a to 23n is released (S7).

The operation of the integrated network management gateway system is shown in FIG. 4 with reference to the process of FIG. 3. 4 is a flowchart illustrating an operation of an integrated network management gateway system according to the present invention.

First, when initializing the servlet 21 at the start of the integrated network management gateway system, the database connection manager 22 is also initialized (S11). The database connection manager 22 creates a database connection pool having as many database connections as it is initialized (S12). The servlet 21 acquires a database connection through the database connection manager 22 (S13) and performs a database operation through the obtained database connection (S14). It is determined whether the database operation is completed (S15). If it is not completed, the database connection is acquired again (S13), and the database operation is continued (S14). If the database operation is completed, the servlet 21 is the database connection manager 22. The database connection is returned through (S16).

The present invention described above is capable of various substitutions, modifications, and changes without departing from the technical spirit of the present invention for those skilled in the art to which the present invention pertains. It is not limited to the drawings shown.

The present invention speeds up database processing and can efficiently manage system resources. In addition, connections previously created by the database connection manager can reduce the time it takes for a large number of servlets to connect to each database.

Furthermore, the database connection pool performs functions such as connection failure and connection limiting so that the system's resources can be efficiently used.

Claims (8)

In the integrated network management gateway system connecting a plurality of network management system and the integrated network management system in a distributed network environment and using a database connection pool having its own database, A plurality of database connection pools for retrieving and storing a database connection including a pointer to the own database information table and returning the database connection after a database operation; Loads and registers a DBC driver, creates the database connection pool having a predetermined number of database connections according to the properties of the properties file of the database connection pool, and includes the database connection from the generated database connection pool. Database connection manager means for obtaining and managing a pointer; And Servlet means for receiving a pointer of the database connection from the database connection manager means, performing a corresponding database operation through a database connection corresponding to the pointer, and returning the database connection to the database connection pool when the operation is completed. Integrated network management gateway system using a database connection pool, characterized in that. The method of claim 1, wherein the database connection manager means, Integrated network management gateway system using a database connection pool, characterized in that for generating a predetermined number of database connection pool set at the time of initialization. delete The method of claim 1, wherein the database connection manager means, Integrated network management using a database connection pool, wherein the database connection is obtained from a plurality of database connection pools according to a request of the servlet means, and the database connection is returned to the database connection pool after a database operation is completed. Gateway system. The method of claim 1, wherein the database connection pool, The integrated network management gateway system using a database connection pool, characterized in that the resource is released at shutdown to close the connection, handle connection failure, and limit the connection exceeding a preset maximum value in the database connection pool. In the operating method of the integrated network management gateway system using a database connection pool having its own database, A first step of creating a database connection including a pointer to the own database information table by creating a plurality of database connection pools at an initial operation of the system; A second step of a servlet obtaining a corresponding pointer from the database connection pool in response to a command; A third step of acquiring a corresponding database connection by using a pointer of the obtained database connection pool and processing a subsequent database job through the obtained database connection; And And a fourth step of returning the obtained database connection to the database connection pool when processing of the database job is completed. The method of claim 1, wherein the first step, A method of operating an integrated network management gateway system using a database connection pool, comprising loading and registering a JDBC driver and creating the plurality of database connection pools according to properties of a property file. The method of claim 6, wherein the database connection pool, A method of operating an integrated network management gateway system using a database connection pool, characterized in that the resource is released during shutdown to close the connection, handle connection failure, and limit the connection exceeding the maximum value set in the database connection pool.