KR100671683B1 - Automatic method for generating ess nms database loader which stores data output from telephone exchange into database - Google Patents

Abstract

1. TECHNICAL FIELD OF THE INVENTION

The present invention relates to a method for automatically generating a switchboard operation management database loader and a computer-readable recording medium having recorded thereon a program for realizing the method.

2. The technical problem to be solved by the invention

The present invention provides a method for automatically generating a switchboard operation management database loader that can automatically generate a database loader when a database building program for the switchboard operation management data is implemented, and a computer-readable recording medium recording a program for realizing the method. To provide.

3. Summary of Solution to Invention

The present invention comprises a first step of generating a lexical analysis rule for a message for network operation management; A second step of generating a token generator using a token generator sample source code and the lexical analysis rule; Generating a token, a token list, and a parsing rule by using the network operation management message and the token generator; A fourth step of generating a parser source code by inserting the lexical rule and the token list into a parser sample source code; And a fifth step of compiling and linking a database input routine for inputting data extracted by a parser to a database, the parsing rules, and the parser source code to generate a database loader.

4. Important uses of the invention

The present invention is used in a network management system.

Database loader, network management, loader auto creation

Description

AUTOMATIC METHOD FOR GENERATING ESS NMS DATABASE LOADER WHICH STORES DATA OUTPUT FROM TELEPHONE EXCHANGE INTO DATABASE}             

1 is an exemplary configuration diagram of a network management system to which the present invention is applied;

2 is a flow chart of an embodiment of an automatic operation of a switchboard operation management database loader according to the present invention;

3A to 3D are detailed flowcharts of an embodiment of a method for automatically generating an exchange operation management database loader according to the present invention.

* Explanation of symbols for the main parts of the drawings

101: exchange 102: database loader

103: Database 104: Network Management Module

The present invention relates to a method for automatically creating a switchboard operation management database loader and a computer-readable recording medium recording a program for realizing the method, and more particularly, for switching operation management to increase the efficiency of network management system development and maintenance work. A method for automatically generating an exchange operation management database loader for automating the creation of a database construction program for data and a computer-readable recording medium having recorded thereon a program for realizing the method.

In the switching network management method in which the switching network management is performed based on the switching output message, the network management system analyzes the output management message output from each switching system and uses the analyzed result as network management data such as network status monitoring and traffic control. You need a database loader program that stores the database in real time.

The messages output from the exchange have different types depending on the items of network management data. Therefore, the database loader has processing routines that are dependent on the type of message.

In the conventional DB loader development method, a developer analyzes a message type for each message, derives a processing algorithm, performs a direct program coding, and has undergone numerous test processes until the program is completed.

Therefore, if a change in message format or a request for adding a network management item occurs due to a version upgrade of the switch software (SW), the processing routine has been newly devised and recoded by the developer, thereby reducing productivity and changing the network management environment. The maintenance and prompt change management were difficult.

The present invention has been made to solve the above problems, realizing a method and the method for automatically creating a switch management database loader that can automatically generate a database loader when the database construction program for the switch management data is implemented. The object of the present invention is to provide a computer-readable recording medium having recorded thereon a program.

In order to achieve the above object, the present invention provides a method for automatically generating a switch management database loader applied to a network management system, comprising: a first step of generating a lexical analysis rule for a message for management of a network operation; A second step of generating a token generator using a token generator sample source code and the lexical analysis rule; Generating a token, a token list, and a parsing rule by using the network operation management message and the token generator; A fourth step of generating a parser source code by inserting the lexical rule and the token list into a parser sample source code; And a fifth step of compiling and linking a database input routine for inputting data extracted by a parser to a database, the parsing rules, and the parser source code to generate a database loader.

The present invention also provides a network management system having a large capacity processor, comprising: a first function of generating a lexical analysis rule for messages for communication network operation management; A second function of generating a token generator using a token generator sample source code and the lexical analysis rule; A third function of generating a token, a token list, and a parsing rule by using the network operation management message and the token generator; A fourth function of generating a parser source code by inserting the lexical rule and the token list into a parser sample source code; And a database input routine for inputting data extracted by a parser into a database, a program for realizing a fifth function of compiling and linking the parsing rules and the parser source code to generate a database loader. Provides a record medium that can be.

In general, even if the management system is already in development and in operation, when the format of the output message is changed due to the addition / change of network management requirements or the change of the operating system version of the exchange, the change of the real-time database construction program must be accompanied. do. Therefore, in order to be able to respond quickly to the changing demands of the management of the switching network, even if the message format changes basically, it should be possible to secure the database construction program according to it as consistently and with little effort as possible.

That is, in the existing DB loader development, the operator had to analyze / design the algorithm one by one, but when using the method proposed in the present invention, after analyzing the DB construction target message, only the DB construction item and DB construction method of the DB construction target message were designated. If you do this, DB loader of the message can be created automatically.

The DB loader is automatically generated by creating a parser (parser) source code for a message and compiling them by writing a DB input routine that constructs a data item output by the parser as a DB. Make DB input routine is a function that includes a DB input command that works in conjunction with a parser. In addition, the parser includes a function to extract the DB construction target items from the message.

The above objects, features and advantages will become more apparent from the following detailed description taken in conjunction with the accompanying drawings. Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is an exemplary configuration diagram of a network management system to which the present invention is applied.

In the network management system to which the present invention is applied, the messages stored in the database (103) are stored in the database (DB) 103 by using a database loader (database storage program) 102 for the messages continuously output from the switch 101, and the data stored in the database 103 is stored. It is used through the network management module 104.

2 is a flowchart illustrating an exemplary method for automatically generating a switch management database loader according to the present invention.

Receive a message that is data for the exchange operation management (21), automatically generates a lexical rule (lexical rule) for the message and stores it as a file (22).

The lexical analysis rule stored above is inserted into the lexical analysis rule part of the token generator sample source code prepared in advance, and the lexical output routine for each lexical analysis rule is automatically inserted. The token generator sample source code reads a message, analyzes the vocabulary, and records the analyzed vocabulary (token) in the token file. The modified source code is compiled using lex to generate a token generator (23).

Run the token generator to generate a list of tokens by receiving a message and use it to create an initial file of parser.y. Tokens are defined in the syntax rule (parser.y). Select items to input in DB by referring to syntax rules of parser.y. In the parsing of the selected item, an action code for extracting the symbol value of the item is inserted to supplement the syntax rule (parser.y) to generate a token and syntax rule (24).

Insert the generated lexical rule into the lexical rule part of the parser sample source code (parser.l) prepared in advance. The parser sample source code reads the message and invokes the parsing routine (yyparse ()). Only unique tokens are extracted from the generated token list and inserted into the lexical rule. The source code (parser.l) of the parser is generated using the inserted lexical analysis rule and the symbol value extraction code for each token list (25).

After writing and compiling DB input routine to input data extracted by parser to DB, compiling parsing rules and parser source codes generated by using yak and lex, respectively. The created DB input routine is linked together to generate an executable database (DB) loader (26).

Therefore, when developing a message DB loader program according to the method proposed in the present invention, it is possible to reduce the burden of writing a message parsing routine when developing a DB loader by automating most of the process of creating a parser for a message.

3A to 3D are detailed flowcharts of an embodiment of a method for automatically generating an exchange operation management database loader according to the present invention.

3A to 3D will be described in more detail with reference to the flow chart through the flow of FIG.

First, receiving a network operation management message (21), read a vocabulary from the network operation management message (221), generate a lexical analysis rule (222), the lexical analysis generated for the network operation management message Save the rule (223).

Check whether the input for generating the lexical analysis rule of the network operation management message is finished (224), and if the message for network operation management remains, repeating from the step of reading one vocabulary (221), and the message for network operation management If not left, the process ends the lexical rule generation process 22 and proceeds to the token generator generation process 23.

Read the token generator sample source code which reads the message and lexical analysis and writes the analyzed lexical token in the token file (231), reads the lexical analysis rules generated through the lexical rule generation process (22) (232) ), Inserts the lexical analysis rule into the lexical analysis rule section of the token generator sample source code (233) and inserts the token (lexical) output routine for each lexical analysis rule (234) to store the modified token generator sample source code. (235).

The modified and stored token generator sample source code is compiled using lex (236) to generate a token generator (237). After generating the token generator, the token generator generation process 23 is completed, and the token and syntax rule generation process 24 is performed.

The token and syntax rule generation process 24 first drives a token generator and receives a message for network operation management to generate a token (241), and generates and stores a token list according to the generated token (242). A parse rule is generated using the stored token list (243).

The parsing rule of the message for network operation management message is stored (244), the token definition is added to the stored parsing rule (245), and the parsing rule in which the token is defined is stored (246).

In the parsing rule in which the token is defined, the database construction target item is selected by referring to the parsing rule part (247).

A storage routine for storing the symbol value of the target item is inserted into the parsing rule of the selected item (248), and a parsing rule (parser.y) including the symbol value storage routine is stored (249). Thus, the processing of the token and syntax rule generation process 24 is performed.

Token and syntax rule generation process 24 Next, a parser source code generation process 25 is performed.

First, read the parser sample source code (parser.l) with the function of reading the message and calling the parsing routine (yyparse ()) (251), read the lexing rules of the stored message (252), and list the stored tokens. Read (253).

Insert the read lexical rule and token list into the lexical rule of the parser sample source code (254), and insert the lexical rule and the symbol value extraction routine for each token list (255). Create and store (parser.l) (256). At this time, the token list inserted into the lexical analysis rule unit is extracted and inserted into the lexical analysis rule unit only the token of the generated token list.

After the parser source code generation process 25 is performed, the database loader generation process 26 is performed.

First, a database input routine is created for inputting data extracted by the parser to a database (261), and the source code of the generated database input routine is stored (262).

Compile the stored database input routine source code and compile the parsing rule (parser.y) and the parser source code (parser.l) including the symbol value storage routine (263).

The parsing rule (parser.y) containing the compiled symbol value storage routine and the parser source code (parser.l) are linked together with the compiled database input routine source code to create and save an executable database loader ( 264).

The present invention described above is not limited to the above-described embodiments and the accompanying drawings, and various substitutions, modifications, and changes are possible in the art without departing from the technical spirit of the present invention. It will be clear to those of ordinary knowledge.

According to the present invention as described above, the message output from the exchange has a different type according to the items of the network management data, and therefore, the database loader for storing the network management data in the database has a processing routine dependent on the type of the message. This DB loader is developed by developing the algorithm by analyzing the data for each type of data, performing the coding of the program by hand, and it requires a lot of manpower and time because the program has to go through a lot of testing process until the program is completed. Unlike the conventional method, it is possible to reduce the manpower and time by automating the development of the database loader to increase the efficiency and economic efficiency of the work.

In addition, when the present invention is applied to the public telephone network operation management of the telecommunication company can be more quickly respond to the change management according to the change of the exchange data, it is effective to secure a more reliable network service base.

Claims (7)

In the method for automatically creating a switchboard operation management database loader applied to a network management system, A first step of generating a lexical analysis rule for a message for network operation management; A second step of generating a token generator using a token generator sample source code and the lexical analysis rule; Generating a token, a token list, and a parsing rule by using the network operation management message and the token generator; A fourth step of generating a parser source code by inserting the lexical rule and the token list into a parser sample source code; And A fifth step of compiling and linking a database input routine for inputting data extracted by a parser to a database, the parsing rules, and the parser source code to generate a database loader; Exchange manager management database loader automatic generation method comprising a. The method of claim 1, The first step is, Generating a lexical analysis rule by reading a vocabulary from the received network management message; A seventh step of storing a lexical analysis rule generated for the communication network operation management message; An eighth step of checking whether an input for generating a lexical analysis rule of the communication network operation management message is finished; And A ninth step of processing the lexical analysis rule by repeatedly performing the sixth step of reading the vocabulary if the communication network operation management message remains; Exchange manager management database loader automatic generation method comprising a. The method of claim 1, The second step, A sixth step of reading a token generator sample source code which reads the communication network management message and lexical analysis and records the analyzed lexical token in a token file; Inserting the lexical rule into the lexical rule of the token generator sample source code; Inserting a token output routine for each lexical analysis rule into a lexical analysis rule of the token generator sample source code and storing the token generator sample source code; And A ninth step of compiling the token generator sample source code using lex to generate a token generator Exchange manager management database loader automatic generation method comprising a. The method of claim 1, The third step, A sixth step of driving the token generator and generating the token and the token list by receiving the communication network operation management message; A seventh step of generating a parsing rule using the token list; Adding an token definition to the parsing rule to generate a parsing rule in which a token is defined; A ninth step of selecting a database construction target item by referring to a syntax rule unit of a parsing rule in which the token is defined; And A tenth step of generating a parsing rule including a symbol value storing routine by inserting a storage routine for storing a symbol value of a target item in the parsing rule of the selected item; Exchange manager management database loader automatic generation method comprising a. The method of claim 1, The fourth step, A sixth step of reading a parser sample source code having a function of reading a communication operation management message and calling a parsing routine; A seventh step of reading a lexical analysis rule of the communication network operation management message and the token list; And Inserting the lexical rule and the token list into a lexical rule of the parser sample source code and inserting the lexical rule and the symbol value extraction routine for each token list to generate the source code of the parser; step Exchange manager management database loader automatic generation method comprising a. The method according to any one of claims 1 to 5, The fifth step, An eleventh step of creating a database input routine for inputting the data extracted by the parser into the database; A twelfth step of compiling the database input routine source code, the parsing rule, and a parser source code; And A thirteenth step of creating a database loader by linking the compiled parsing rules and the parser source code to the compiled database input routine source code; Exchange manager management database loader automatic generation method comprising a. In a network management system with a large processor, A first function of generating a lexical analysis rule for a message for network operation management; A second function of generating a token generator using a token generator sample source code and the lexical analysis rule; A third function of generating a token, a token list, and a parsing rule by using the network operation management message and the token generator; A fourth function of generating a parser source code by inserting the lexical rule and the token list into a parser sample source code; And A fifth function of compiling and linking a database input routine for inputting data extracted by a parser to a database, the parsing rules, and the parser source code A computer-readable recording medium having recorded thereon a program for realizing this.

Images