KR20010039110A - Method for inquire for data base in switching system - Google Patents

Abstract

PURPOSE: An inquiry method for the database of a switching system is provided to increase the efficiency of database management by automatically collecting and inquiring the information of separated, associated databases and storing inquired database information in the form of a special text type file so that a user can reprocesses and use it. CONSTITUTION: A user selects a DB inquiry associated menu and a sub menu through a MAP(Maintenance and Administration PC)(S10). The user selects one of the menus and inputs an inquiry range(S20). The MAP judges the associated DBs corresponding to the selected menu and prepares a switching system for the transmission of them(S30). The MAP collects the judged DBs as much as the inputted range(S40). The MAP converts collected information into an appointed information output form, outputs it on the monitor and, at the same time, stores it in the form of a text file(S60).

Description

How to query database of exchange system {METHOD FOR INQUIRE FOR DATA BASE IN SWITCHING SYSTEM}

The present invention relates to a database inquiry method of an exchange system, and more particularly, in identifying database (DB) information of an exchange system. Database inquiry method of exchange system that improves database management efficiency of exchange system by saving database information in a text format file for use in text editor so that users can reprocess the information. It is about.

The system configuration of the exchange system and the maintenance terminal for operating and managing a database of a conventional exchange system (hereinafter, abbreviated as 'DB') is schematically shown in FIG. 1. Referring to FIG. 1, reference numeral 10 denotes an input / output process module (IPM) of an exchange system 1, and 20 denotes a terminal (MAP; Maintenance & Administration PC) for maintenance of the exchange system 1. to be. And, the reference numeral 30 is a message transmission protocol (Protocol) promised to transmit and receive information in the form of a message between the input and output module 10 and the maintenance terminal 20 of the switching system.

DB management of the exchange system 1 is made through the maintenance terminal 20, the maintenance terminal 20 is composed of menus corresponding to each DB, by generating a message promised in each menu exchange It will communicate with the system (1). 2 schematically shows an embodiment of a menu configuration diagram of the maintenance terminal 20. The menus shown in FIG. 2 represent only a part of about 250 menus configured in a top-down manner, and the exchange system 1 is displayed on-line through such menus. Can be maintained.

As described above, a method for managing a DB driven in the switching system 1 may include input and output of data through message transmission / reception between the maintenance terminal 20 and the switching system 1 as shown in FIGS. 1 and 2. It is done through The DB of the exchange system 1 forms a whole DB by gathering many kinds of DBs according to their respective functions. And, the information of the operating exchange system (DB) DB in operation exchanges and receives the promised message with the exchange system (1) through the menu associated with the DB as shown in the menu configuration diagram shown in FIG. Inquiry is made possible through the monitor 22.

However, the DB query method of the conventional exchange system as described above has various inconveniences as described below.

First, when information of several DBs is related to each other;

The maintenance terminal 20 has a cumbersome point of collecting and collecting each associated menu in order. For example, for a phone number, which port is this phone number assigned to, what state of the port is specified, which phone number is a member of which functional group, and what is the characteristic of that functional group? If you want to know it is cumbersome because you have to look up each of the following information through the maintenance terminal (20).

-Port information (designated port information and function group to which it belongs)

Port Status (Normal, Abnormal)

-Characteristics of functional groups

Second, when one DB information is larger than one message unit;

Currently, the maintenance terminal 20 can be inquired through the monitor 22 of the maintenance terminal 20 only in units of one message, and if a certain DB size is larger than this, a plurality of messages should be generated to organize the inquired contents. do. For example, if there are 500 subscriber groups, the maintenance terminal 20 can process only one group of information with one message. Therefore, in order to grasp the status of the entire group, it is necessary to generate 500 inquiry messages and organize them. There was a troublesome problem.

The present invention has been created to solve the above problems, in identifying the database (DB) information of the exchange system, and automatically collects and retrieves the information of each associated database is separated, and the It provides database search method of exchange system which improves the efficiency of database management of exchange system by saving information in a file in a separate text format for use in text editor. The purpose is.

That is, the present invention provides a function of collecting and showing the contents of the DB of the operating exchange system in operation according to the information desired by the administrator and storing them as a text file, particularly at a site operating a private exchange. Provides a way to easily manage subscriber-related information.

1 is a block diagram for database inquiry of a conventional exchange system,

2 is an output screen configuration diagram of a database inquiry method of a conventional exchange system;

3 and 4 are operational flowcharts of a database inquiry method of the exchange system according to the present invention.

<Description of the code used in the main part of the drawing>

1: exchange system 10: exchange system input / output module

20: maintenance terminal 30: message transmission protocol

In order to achieve the above object, a database inquiry method of a switching system according to the present invention is a method of querying a database of a switching system by a maintenance terminal that receives a message of the switching system through a predetermined message transmission protocol. A first step of selecting, at the maintenance terminal, a database-related menu and sub-menus thereof and receiving a range to be inquired; A second step of determining an associated database list corresponding to the menu selected in the first step and requesting transmission of the database list to the switching system; A third step of collecting the database determined in the second step corresponding to the range received in the first step; And a fourth step of converting the information collected in the third step into a predetermined information output form, outputting it to a monitor of the terminal, and storing the information in a text format.

Hereinafter, with reference to the accompanying drawings will be described in detail a preferred embodiment of the database query method of the exchange system according to the present invention.

First, the database inquiry method of the exchange system according to the present invention can be implemented through the system configuration of the exchange system and the maintenance terminal shown in FIG. Therefore, in the present invention, the maintenance menu 20 selects the relevant menu. That is, the maintenance terminal 20 selects the DB inquiry-related menu and submenu (S10). For example, the related menu is referred to as a 'report function' as below, and a sub menu is configured as follows.

Report function Phone number information Subscriber group information CO line group information

The sub-menu, 'phone number information', 'subscriber group information', and 'route group information' are used to improve the inconvenience of the aforementioned conventional method for grasping the entire DB information, which can be used very efficiently. This is explained step by step as follows.

First, one of the menus is selected and a range to be inquired is input (S20). The contents received from each menu are as follows.

-Phone number information: Port range to search

-Subscriber Group Information: Group Range to Inquire

-CO Line Group Information: Group Range to Inquire

Next, determine the associated DB list corresponding to the selected menu, and prepare to request it to the switching system 1 (S30). For example, the related DB list corresponding to each menu is as follows.

-Phone number information: port information, port status information, group property information to which the port belongs

-Subscriber group information: subscriber group characteristic information and group member information

-CO line group information: CO line group information and group member information

In the state as described above collects the DB determined in step S30 corresponding to the range received in step S20 (S40). For example, if the menu selected in step S10 is the telephone number information (DB) and the range is input from port 0 to port 100, for example, the maintenance terminal 20 is the same as in step S42 to S48 of FIG. Collect relevant information.

3 and 4, the flow is collected and automatically proceeded under the judgment of the maintenance terminal 20 after the step S20, compared to the DB information collected by the administrator manually by a conventional manual (Manual) method It is useful because it becomes.

In step S50, the information collected in step S40 is converted into a promised information output form and output to the maintenance terminal monitor 22, and at the same time, the information is stored in a file in a text file format (S60). The reason for doing this is to allow the user to process and use the output information in a format other than the promised format. The text file provided here can be edited with Microsoft Excel documents, for example, so that data processing can be done easily.

As described above, the database inquiry method of the exchange system according to the present invention automatically collects and retrieves the information of the associated database, which are separated from each other, in grasping database (DB) information of the exchange system. The information of the database can be stored in a file in a separate text format for use in a text editor, allowing the user to reprocess and use the information, thereby improving the efficiency of database management of the exchange system.

That is, the present invention provides a function of collecting and showing the contents of the DB of the operating exchange system in operation according to the information desired by the administrator and storing them as a text file, particularly at a site operating a private exchange. Subscriber-related information can be easily managed.

Claims (1)

A method of querying a database of a switching system by a maintenance terminal that receives a message of the switching system via a predetermined message transmission protocol, the method comprising: A first step of selecting, at the maintenance terminal, a database related menu and a sub-menu thereof, and receiving a range to be inquired; A second step of determining an associated database list corresponding to the menu selected in the first step and requesting transmission of the database list to the switching system; A third step of collecting the database determined in the second step corresponding to a range received in the first step; And And a fourth step of converting the information collected in the third step into a predetermined information output form, outputting the information to a monitor of the terminal, and storing the information in a text format. .