KR20000056409A - Method for backing up data of NMS DB and method for extracting data of NMS DB - Google Patents

Abstract

PURPOSE: A data backup and extraction method is provided to make a backup information file and modify a backup table and cycle without compiling again the program necessary for a backup process on a network management database data so that it can automatically perform the backup process. CONSTITUTION: A data backup and extraction method comprises steps of driving a cron demon and opening a log file(s21,s22), setting an environment for a database, reading a backup information file if there exists a backup target information, otherwise recording the log(s23-s26), loading a backup information content to a memory and matching a pattern to information of system tables(s27,s28), extracting a database data appropriate for a backup cycle if a matching result is a right syntax, and otherwise recording the log(s29-s31), and loading the database to a network management system server, and returning to the backup target information existence checking step(s32).

Description

Method for backing up data of NMS DB and method for extracting data of NMS DB

The present invention relates to a data backup construction method and a data extraction method of a network management database system. In particular, a backup table and a backup cycle by putting a backup information file without having to recompile a program required for backup processing for the network management DB data. The present invention relates to a data backup construction method and a data extraction method of a network management database system for automatically constructing a backup efficiently by modifying the system.

In the network management system, the network management DB (Data Base) data for network management is constructed as DB, and these data are stored in related tables, the storage cycle is defined and programmed to back up the network management DB data.

In this way, the backup process is operated without prior consideration of the operational requirements that need to be applied with a separate change.

In addition, the program processes the backup cycle for network management DB data backup, and there is no backup information file to change the backup cycle and backup cycle desired by the operator, and when the backup information and backup cycle are changed, the program must be recompiled and applied. It is cumbersome to deal with, and there is no generality to handle various types of DB data backup to cope with changing network environment and to be easily accommodated in new network management system in the future.

In addition, there is a problem that the operator can not back up the network management DB data freely by saving the network management DB data in the form of backup information file to change the network management DB to the information desired by the operator.

Accordingly, an object of the present invention, which was created to solve the problems of the prior art operating as described above, generates a backup data file required for establishing a backup for network management DB data and calculates DB data suitable for a backup cycle. It provides a means to build a DB as a backup server.

Another object of the present invention is to provide a means for unifying the process so that the network management DB data backup is performed immediately if the operator creates or modifies the backup information file with desired information without program change.

It is another object of the present invention to provide a means for efficient management of a communication facility and DB operation according to a backup construction for network management DB data.

1 is a flow diagram of a processor controller in accordance with the present invention.

2 is a control flowchart of a backup information interpreter and a DB data backup implement according to the present invention;

3 is a diagram showing interprocessor communication for network management DB data backup construction according to the present invention.

<Explanation of symbols for main parts of drawing>

10: network management system server

20: network management system backup server

A preferred embodiment of the data backup method of the network management database system according to the present invention, which was created to achieve the object as described above,

Loading control information into a memory; reading the control information; and backing up the read control information to a DB.

In the present embodiment, the read control information includes a generalized DB classification name, a table name, a reference column name, a backup cycle, and invokes a backup process for network management DB data based on the control information. and the backup step further comprises the step of formatting a backup information interpreter and a data backup builder.

A preferred embodiment of the data extraction method of the network management database system according to the present invention comprises the steps of: running a cron daemon, opening a file for logging, setting an environment for a DB, backing up Checking whether there is target information, recording a log if there is no backup target information, loading contents of backup information into memory if there is backup target information, and matching a pattern with systables information. And, if the syntax is correct, if the syntax is correct, extracting DB data suitable for a backup cycle, or recording a log, and loading the DB on a network management system (NMS) backup server.

In the present embodiment, the information backed up to the memory includes a DB classification name, table name, reference column name, backup period.

Hereinafter, described in detail with reference to the accompanying drawings, preferred embodiments of the present invention.

1 is a flowchart of a processor controller according to an embodiment of the present invention, in which load control information is stored (s10), when control information is terminated (s11), and when it is not terminated, the next information is read (s12) and the DB is backed up. After that (s13), the process returns to the step of determining whether or not the control information is finished.

2 is a flow chart of a backup information interpreter and a DB data backup builder according to an embodiment of the present invention, in which a cron daemon is driven and a file for logging is opened (s21 and s22); Setting up the environment for the database and reading the backup information file if the backup target information exists (s23-s26), loading the backup information contents into memory, and matching the systables information and pattern Step (s27, s28), and if the correct syntax thereafter extracts the DB data suitable for the backup cycle, or write a log (s29-s31), and load the DB to the network management system server and whether the backup target information exists It will be made back to step (s32), the process of which is described as follows.

The DB data backup processor is driven by the cron daemon to show the process of extracting DB data that matches the backup cycle based on the backup information.

Also, this processor extracts DB data about backup cycle of network management DB data by directly analyzing specific backup information file, and calculates network management DB data from it, and stores DB data on Network Management System (NMS) backup server. The process of loading DB data is repeated.

First of all, the network management DB data backup establishment starts by executing the cron daemon to call the network management DB data backup command at a specific time, opening a file to record the log generated when the DB data is backed up, and executing the cron daemon. Set the environment for

If the network management DB data backup process checks whether there is backup information to analyze, if there exists, perform the next step. If not, record the error in the log file and go back and repeat the existence of backup information.

Then, the backup information file is read, the backup information is loaded into the memory, and the backup information is checked for pattern matching with the systables information.

Next, check if it is correct and if it is correct, perform the next step. Otherwise, ignore the backup information and record the error in the log file and then go back.

Also, it extracts the DB data suitable for the backup cycle, loads the DB data to the NMS backup server with the extracted contents from the network management DB, and executes the repetitive work again to construct the backup for the network management DB data. Perform.

3 is a diagram illustrating interprocessor communication for establishing a network management DB data backup according to the present invention. As shown in FIG. NMS) DB is built on backup server.

Therefore, backup of network management DB data that does not exceed the physical area allotted for the DB is calculated in the backup DB table registration file without changing the program. If you register the information you want and modify only the backup cycle, it automatically builds and processes the backup DB.

In the present invention operating as described in detail above, the effects obtained by the representative ones of the disclosed inventions will be briefly described as follows.

The present invention provides a backup information file for network management DB data backup, the operator can easily change the backup information and backup cycle desired, and when changing the backup information and backup cycle has to change the program to recompile and apply Transparency is guaranteed, and it is versatile to handle various types of DB data backup to cope with changing network environment and to be easily accommodated in new network management system in the future.

Claims (6)

Loading control information into a memory; Reading the control information; Backing up the read control information to a DB, a data backup method of a network management database system. The method of claim 1, wherein the read control information, A method for backing up data in a network management database system, including a generalized DB classification name, table name, reference column name, and backup cycle. The data backup method according to claim 1 or 2, which invokes a backup process for network management DB data on the basis of the control information. 4. The method of claim 1 or 3, wherein the backup step further comprises formatting a backup information interpreter and a data backup builder. Driving a cron daemon; Opening a file for logging after the daemon is running; Setting an environment for a DB after opening the file; Checking whether the backup target information exists; Recording a log if there is no backup target information; Loading backup information into memory if the backup target information exists; Matching a pattern with the systables information after the load; Checking that the syntax is correct after the matching; If the syntax is correct, extracting DB data corresponding to a backup cycle and recording a log; And And a step of loading the DB on a network management system (NMS) backup server. The method of claim 5, wherein the information backed up in the memory comprises a DB classification name, a table name, a reference column name, and a backup cycle.