KR19980035956A - Statistical history calculation method of intelligent network service control / management system - Google Patents

Abstract

The present invention relates to a method for calculating the statistical history of an intelligent network service control / management system (NICS), in particular for the purpose of management and maintenance of the NICS provided by the NICS system and NICS stored in the message storage table of the statistical database Statistical history is calculated from the status, measurement, and fault messages related to wide area incoming and outgoing billing service, credit call service, and information service agency, and the result is stored in the statistical history storage table. In this case, the result is outputted to the work seat and the printer. The message stored in the message storage table of the statistical database to which the present invention is applied is a short period of time (several hours if short) due to lack of storage space. When it elapses, it is deleted from the database periodically or by operator's operation. The present invention has been made to solve the problems of the prior art because it was impossible to obtain the essential analysis information for daily, monthly, quarterly, yearly statistical reporting and system operation management / maintenance without the statistical history calculation function for the seji, Adds a function that calculates the statistical history periodically (daily, monthly) or before deleting the message stored in the database and saves the result in the history storage table so that in the event of subsequent statistical reporting and system operation management / maintenance and system failure Provides statistical history calculation method of intelligent network service control / management system that provides essential information to be used as analysis information.

Description

Statistical history calculation method of intelligent network service control / management system

The present invention relates to a method for calculating the statistical history of an intelligent network service control / management system (NICS), wherein the intelligent network service control / management system (NICS) is a core device of the intelligent network configurator and transfers the intelligence required for providing a special service from the exchange to the exchange. By separating and implementing on a general-purpose computer, it is a system that makes it easier to implement and provide communication network services and to manage services.

Messages stored in the message storage table of the statistical database to which the present invention is applied are deleted from the database periodically or by an operator's operation after a certain period of time, or a few hours in the short time due to lack of space in the storage device.

Conventionally, since there is no function of calculating the statistical history of deleted messages, it is impossible to obtain analysis information necessary for daily and monthly, quarterly, and yearly statistical reporting and system operation management / maintenance.

In order to achieve the above object, the present invention, the daily, monthly, and quarterly, which could not be provided in the conventional intelligent network service control / management system (NICS) of the analysis information essential for the annual statistical reporting and system operation management / maintenance Before deleting messages for provision, you must extract the required information from these messages and keep the results.

Accordingly, the present invention provides a method for calculating the statistical history of an intelligent network service control / management system that periodically calculates the statistical history (daily, monthly) or before deleting a message stored in a database, and stores the result in a history storage table. .

1 is a configuration diagram of an intelligent network service control / management system to which the present invention is applied;

2 is a block diagram of a statistical history calculation block to which the present invention is applied;

3 is a structural diagram of a message storage table according to an embodiment of the present invention;

4 is a structural diagram of a statistical history storage table according to an embodiment of the present invention;

5A through 5B are flowcharts of a statistical history calculation process according to an embodiment of the present invention.

Explanation of symbols on the main parts of the drawings

1: CMP (CCS7 MTP (Message Transfer Part) Processor)

2, 3: CCS Processor (CCP)

4: MAP (Maintenance Processor)

5, 6: Service Logic Processor (SLP)

5a, 6a: service processing memory database

7: OAP (Operation And Administration Processor)

8: Service Management Processor (SMP)

9, 10: LAN device

11, 12: service subscriber database

13: System Node Database

14: Service subscriber master database

The present invention provides a method for calculating the statistical history of an intelligent network service control / management system applied to an intelligent network service control / management system. A first step of checking whether a message occurred on a history calculation request date exists; A second step of outputting, on the work seat screen, that there is no history calculation message of the corresponding day if there is no message generated on the history calculation request date in the first step; A third step of reading a message of a message storage table one by one, calculating a daily history, and storing the result in a statistical history storage table when a message generated on the history calculation request date exists in the first step; A fourth step of constructing a daily history calculation result in a report form and outputting it to a printer for the purpose of archiving the system operation history if the history calculation request date is yesterday, that is, one day or more in the third step; A fifth step of outputting that the daily history calculation is completed on the work seat screen when the history calculation request date is not yesterday in the third step; A sixth step of checking whether the history calculation request date is the last day in the month after completing the daily history calculation processing for the history calculation request date; In the case of the last day in the sixth step, the monthly history for the month is calculated, the result is stored in the statistical history storage table, and the monthly history calculation result is configured in a report form for the purpose of archiving the system operation history and output to the printer. Step 7; And an eighth step of closing the statistical database and terminating all history calculations.

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

1 is a block diagram of an intelligent network service control / management system to which the present invention is applied.

From the point of view of the network providing the intelligent network service, the system combines a service control point (SCP), which is a service control node, and a service management system (Service Management System, SMS), which is a service management system. It accommodates the complex.

The system is a system that controls various communication network services by providing an appropriate response when a query is input from a service exchanger, and a transaction is input through a CMP (CCS7 MTP Processor) 1 connected to a signal network.

The input transaction is in the form of a signal protocol message, and the CCP (2) (3), which is a front end processor, performs signal connection control and transaction handler processing in protocol layer processing, and the result is again a local area network (LAN). The SLP (Service Logic Processor) 5, 6, which is a subsequent processor, passes through the devices 9 and 10, and processes the dialogue handler on the protocol, and the service processing memory of the SLP 5 and 6 in order to respond to each service. The response is generated by the service-specific logic data in the databases 5a and 6a, and the results are transmitted in the reverse order.

Here, the redundancy of each processing device is configured for the purpose of pursuing high performance and high reliability of this system.

Under normal circumstances, the transaction processing is balanced between the front and rear processors (2, 3, 5, 6), and if one factor is abnormal, all the load sharing is performed by the normal processor.

In addition, the OAP (Operation and Administration Processor) (7) is the processor that manages the operation and maintenance of the system. When the system is first started or initialized, the system configuration and operation data management, processor monitoring and switching, restart, etc. Perform the functions necessary for the overall operation of the system.

A system node database 13 is placed in the OAP 7 to perform the function.

There is a MAP (Maintenance Processor) 4 processor that replaces the function of the OAP 7 so that system operation can be performed without interruption.

In the SLPs 5 and 6, service logic data exist in the form of service processing memory databases 5a and 6a and service subscriber databases 11 and 12 for service processing.

The redundant management as described above has a characteristic that the service call processing requires a response in real time, so that the service processing memory databases 5a and 6a are configured as memory resident databases to satisfy the service call processing. Service subscriber databases 11 and 12 are set up for backup and recovery.

In this system, service subscriber data are distributed and stored in SMP (8), SLP1 (5), and SLP2 (6) to provide wide area incoming billing service, credit call service, and information charge collection service. Service subscriber master database 14, service processing memory databases 5a and 6a, and service subscriber databases 13 and 14;

The service processing memory databases 5a and 6a and the service subscriber databases 11 and 12 have substantially the same format and contents.

In addition, the SMP 8 is a processor for managing subscriber data management and service operation status of an intelligent network service, and has a service subscriber master database 14 in the SMP 8 to minimize the influence on real-time service call processing.

The database of the intelligent network service control / management system (NICS) is composed of various forms depending on the type of data and the characteristics of the database.

Databases directly related to the present invention among the various types of databases are the system node database 13 and the service subscriber master database 14.

The system node database 13 and the service subscriber master database 14 are constructed in the OAP 7 and the SMP 8, respectively, and the hardware name is Hewlett Packard's HP9000 Series 835 system. DBMS) software is called HP ALLBASE / SQL, which is a relational database.

2 is a block diagram of a statistical history calculation block to which the present invention is applied.

The messages are largely divided into system messages and service messages.

The system message includes the system failure data 26 report message generated in the system failure management block 21, the SCCP generated by the protocol management block 22, the TCAP, the traffic measurement for each layer of the ASE protocol, the performance measurement, And the status measurement data 27 report message and the overload status data 28 report message generated by the overload management block 23 for monitoring and breaking the system overload condition.

The service message is a service processing block for each service, which is generated during the service call processing for the broadband call service provided by the intelligent network service control / management system (NICS), the credit call service, and the information payment storage service. The service failure generated at 24 and the status data 29 report message and the service sampling data and traffic data 30 report message generated at the service operation block 25 are classified.

When the messages are generated and transmitted to the message collection block 31, the message collection block is processed into a message format 32, 33, 34, 35, 36 that can be stored in the message storage table of the statistics database 39, and the message is stored. Transfer to block 37. The message storage block 37 stores the received message in a message storage table of the statistics database 39.

In the statistical history calculation block 38 related to the present invention, the history calculation command inputted through the work seat of the user interface block 41 is executed, and the result is stored in the statistical history storage table of the statistical database 39. According to the input data, daily or monthly history calculation result is composed in report form and output to the job screen or printer.

The contents stored in the message storage table and the statistical history storage table are used for the purpose of system operation management and maintenance through the statistical report block 40.

3 is a structural diagram of a message storage table according to an embodiment of the present invention.

Time_Stamp (51) is the time that the message collection block 31 receives the message and is the primary key used to distinguish it from other messages when accessing the database. The resolution is up to 18 microseconds. Seat. Msg_GTime 52 is a message occurrence time expressed in YY-MM-DD HH: MM: DD format.

Msg_ID 53 is a message unique identifier (ID) used to identify a message type and a service type.

Src_Pro 54 also indicates the source / processor name from which the message originated.

The next Item1 (55) is a field indicating the measurement value of the first data item. The number of fields 56 may be different for each message. Up to 20 for a system message can be accommodated and up to 65 for a service message. It is made to be acceptable.

4 is a structural diagram of the statistical history storage table according to an embodiment of the present invention.

Data_ID 61 indicates a history calculation date / month, and in the case of day, denotes YYMMDD, and in the case of month, the DD portion is denoted by 00, that is, YYMM00.

The following Hist_ID 62 is denoted as D in the case of the day used for distinguishing whether the history is daily or monthly, and M in the case of the month.

The Hist_Src 63 is an identifier (ID) used to identify the source of the history calculation content. The Hist_Src 63 is used to distinguish a service type, a service number, and a processor name according to the history content.

The following Result_1 (64) indicates the first history item, the number of history items may be different for each of the Hist_Src (63).

Result_N 65 indicates an Nth history item.

5A through 5B are flowcharts of a statistical history calculation process according to an embodiment of the present invention.

First, when the history calculation is started, the input buffer and the variable to be used are initialized (71), and the history calculation request date is received as an input (72), and the input data is checked to check whether an error exists (73).

If there is a problem, it is requested to input again (72). If there is no problem, the statistics database is opened (74) and the message storage table is read (75).

Investigate whether there is a message generated on the history calculation request date (76), if a message exists, read the messages one by one (77) until the last message (79) perform daily history calculation (78), and then calculate the result of the history storage table Store in (80).

If the message does not exist, the message No Message is displayed on the work screen (81).

If the requested history calculation date is one day ago (yesterday) (82), the daily history calculation result is configured in the form of a report (83) for the purpose of archiving the system operation history (83) and output to the printer (84). The daily history calculation end message is output to the seat screen (85).

After the daily history calculation is finished, if the history calculation request date is the end of the month (86), the monthly history calculation is performed. (87) The monthly history calculation is performed by reading the history storage table in which the daily history calculation results are stored (88). In step 89, the result is stored in the history storage table.

Then, for the purpose of archiving the system operation history, the monthly history calculation results are configured in the form of a report (90) and output to the printer (91), then the statistics database opened for history calculation is closed (92) and all history calculations are completed. (93).

The present invention configured and operated as described above prevents the loss of data for service operation management and system maintenance due to deletion of messages that have passed a certain period of time, and is applied to service and system operation data contained in tens or hundreds of messages. After extracting only the essential information about the daily and monthly summary information, it is possible to delete and store all the messages output during the relevant period.

In addition, by using the stored history information, it is possible to report statistically on daily, monthly, quarterly, yearly, traffic of the intelligent network service and service usage status by service subscriber.

Messages stored in the message storage table of the statistical database applied to the present invention are deleted from the database periodically or by an operator's operation after a certain period of time, i.e., a few hours in a short time due to insufficient storage space.

In this case, if there is no statistical history calculation function for the deleted message, it is impossible to obtain analysis information essential for daily, monthly, quarterly and yearly statistical reporting and system operation management / maintenance.

In order to solve the above problems, statistical statistics and system operation are added by adding a function that calculates the statistical history on a daily or monthly basis or before deleting a message stored in the database, and stores the result in a history storage table. The purpose is to provide a statistical history calculation method of the intelligent network service control / management system that provides essential information to be used as analysis information in case of management / maintenance and system failure.

Claims (3)

In the statistical history calculation method of the intelligent network service control / management system applied to the intelligent network service control / management system, A first step (71 to 76) of receiving a history calculation request date as an input and checking the presence of a message generated on the history calculation request date by opening a statistics database and reading a message storage table if there is no error in the input data; A second process (76, 81) for outputting a history calculation message of the corresponding day when there is no message generated on the history calculation request date in the first processes (71 to 76); In the first process (71 to 76), if there is a message generated on the history calculation request date, the third process (77 to read the message in the message storage table one by one to calculate the daily history and store the result in the statistical history storage table) Statistical history calculation method of the intelligent network service control / management system comprising a). According to claim 1, wherein the first process is A first step of initializing 71 an input buffer and a variable to be used when the history calculation is time; And a second step of receiving a history calculation request date as an input after initializing (72) and checking the input data (73) to determine whether there is an error (73). The method of claim 1, wherein the third process is It is determined whether there is a message generated on the history calculation request date (76), if the message exists, the messages are read one by one (77) until the last message (79) by performing the daily history calculation (78), and then the calculation result is stored in the history table Storing in the first step (80); A second step of outputting a message "no message" on the work seat screen if the message does not exist after the determination; If the requested history calculation date is one day ago (yesterday) (82), the daily history calculation result is configured in the form of a report for the purpose of archiving the system operation history (83) and output to the printer (84) and the history calculation request date is 1 A third step of outputting a daily history calculation end message on the work seat screen if not before; After finishing the daily history calculation, if the history calculation request date is the end of the month (86), the monthly history calculation is performed and the history storage table in which the daily history calculation results are stored is read (87). A fourth step of storing the result in a history storage table (89); In order to save the system operation history after the storage, the monthly history calculation result is configured in the form of a report (90) and output to the printer (91), and then closes the statistical database opened for history calculation (92) and ends all history calculations. (93) a statistical history calculation method of the intelligent network service control / management system, characterized in that it comprises a fifth step.