KR20010054642A - Loading Method of SCP Database - Google Patents

Abstract

PURPOSE: An initial loading method of an SCP(Service Control Point) DB(Data Base) is provided to standardize an SCP DB backup file and a SMS(Service Management System) file to common format and operate accurate and stable DB by using a control message and a commercial FTP(File Transfer Protocol) at initial loading. CONSTITUTION: An SCP(100) defines a DB backup file format that is common between the SCP DB(12) and a SMS DB(22). An operator of the SCP(100) sends a message requesting the SMS(200) for a DB initial loading file by services. The SMS(200) receives the message, informs the SCP(100) of message reception and command a corresponding processor to make SMS DB backup file into the DB backup file format defined by the SCP(100). After completion of the SMS DB backup file, the SMS(200) transmits completed backup file to the SCP(100) via commercial FTP and sends an end message to the SCP(100). The SCP(100) informs the operator of end message. The operator confirms the backup file from the SMS(200), loads the file into SCP DB(12), prepares an SCP DB backup file and compares the SCP DB backup file with the backup file from the SMS(200) to confirm whether or not the two backup file equal each other.

Description

Initial loading method of SCP database {Loading Method of SCP Database}

The present invention relates to a method for initial loading of a SCP (Service Control Point) database, and more particularly, to standardize the SCP database backup file and the SMS database backup file into a common format, and to perform control messages and commercial FTP when performing initial loading. It is a method of initial loading of SCP database that can operate an accurate and stable database using File Transfer Protocol.

In general, an intelligent network system refers to equipment that a service provider can create and process a desired service. The network elements in the intelligent network include Service Switching Point (SSP), Service Control Point (SCP), Service Management System (SMS), Intelligent Peripheral (IP) and Services. It consists of Service Creation Environment (SCE) that creates and provides logic.

Service control environment (hereinafter referred to as SCP) manages subscriber database for each service to provide intelligent network service. When an SCP loses its database in order to register early subscribers in the database or by accident, SCP receives and registers subscriber data from the service management device (hereinafter referred to as SMS), which is initially loaded. This is called.

According to the related art, a method of receiving a control message and subscriber information in a stream form and directly loading the data into a database through socket communication without processing data at the time of initial loading is used.

However, this problem of the prior art has a long loading time, there is a possibility of data loss that may occur during the socket communication in the middle, and the problem of the load on the system occurs. In addition, since there is no standardized backup file between SCP and SMS, it is difficult to compare the database expansion that can occur when using different databases between systems or the correspondence between the contents of the SCP database and the SMS database.

Accordingly, the present invention has been made to solve the above-mentioned conventional problems, and its purpose is to standardize the SCP database backup file and the SMS database backup file into a common format, and to control messages and commercial FTP when performing initial loading. It provides the initial loading method of SCP database so that it can be used to operate accurate and stable database.

1 is a flow diagram of SCP initial loading message according to the present invention,

2 is a process flow diagram illustrating a method for initial loading of an SCP database in accordance with the present invention.

<Explanation of symbols for the main parts of the drawings>

10, 20: communication process 11, 21: DBMS

12, 22: database 13, 23: loading file

100: SCP 200: SMS

A feature of the initial loading method of the SCP database according to the present invention for achieving the above object is to define a common backup file format of the database between the SCP and the SMS, so that the SCP and SMS are commonly loaded even if they use different database systems. To be possible. This file format is identical to the SCP database's own backup file, which is very effective for identifying database correspondence between SCP and SMS.

In addition, the present invention defines the initial loading procedure to be processed by separating the control message and the data file. Since this procedure only handles J messages for SCP-SMS socket communication and uses commercial FTP, the data file transfer can be secured with minimal load on socket communication between both systems.

Hereinafter, preferred embodiments of the SCP database initial loading method according to the present invention will be described in detail with reference to the accompanying drawings.

1 is a flowchart of an SCP initial loading message according to the present invention, and FIG. 2 is a flowchart illustrating a method of initial loading of an SCP database according to the present invention.

First, SCP 100 defines a data file as shown in Table 1 below.

TableNAMEyyymmddHHMMSS record_numORDER: data1 / data2 /...../ datanR data1 data2 ...... datanR data1 data2 ...... datan: R data1 data2 ...... datanR data1 data2 ..... .datanENDOFFILE

Table 1 above defines the common database backup file formats of SCP 100 and SMS 200, where TABLENAME is the table name in the database, yyymmddHHMMSS is the creation year / month / day / hour / minute / second, record_num is the total number of records the table has (the total number of data records the file has), ORDER is the attribute order definition in the record, R is the data record, and ENDOFFILE is the end of the file.

Thereafter, the SCP 100 performs initial loading of the database as a procedure as shown in FIGS. 1 and 3 with the data file defined in Table 1 above.

In step 1, the operator of SCP 100 sends a message requesting SMS 200 to the database initial loading file for each service (S10).

Upon receiving this message, the SMS 200 notifies the SCP 100 of receiving the message and instructs the corresponding process to make the SMS database backup file in the format defined in Table 1 above (S11 to S12).

In step 3, the SMS 200 completes the backup file and then transfers the file to the SCP 100 through commercial FTP, and sends an end message to the SCP 100 (S14).

SCP (100) receives the termination message in step 4 informs the operator of the progress (S15 ~ S16).

In step 5, the operator loads the data file into the SCP database after checking the file received from the SMS 200 (S17 ~ S18).

After loading to the SCP (100) in step 6, the operator creates a SCP database backup file and checks whether it matches the file sent by the SMS (S19 ~ S20).

Therefore, as described above, by matching the format of the backup file of the SCP database and the SMS database backup file, the SCP 100 and the SMS 200 are standardized so that the subscriber database can be restored to a common file. Even with a database system, the initial database loading and recovery is easy.

As described above, according to the initial loading method of the SCP database according to the present invention, the format of the backup file of the SCP database and the SMS database backup file are matched so that both the SCP and the SMS can restore the subscriber database to a common file. By standardizing, it is easy to initial load and restore the database even if you have other database systems, and each system (SCP and SMS) gives only control messages in the process of delivering data files, and commercial FTP is used for the delivery of received files. This prevents data loss and reduces the load on the system, enabling stable service and database recovery.

Claims (3)

A method for initial loading of an SCP database, by defining a common backup file format of the database between the SCP and the SMS so that the SCP and the SMS can be loaded in common even if they use different database systems. The method of claim 1, wherein the initial loading procedure is defined to be processed into a control message and a data file, and the socket communication between the SCP and the SMS processes only the control message and the data file uses commercial FTP. Initial loading of the SCP database. The method of claim 1, further comprising: step 1, by the SCP operator, sending a message requesting SMS to the database initial loading file for each service; Upon receiving this message, the SMS notifies SCP whether to receive the message and instructs the process to format the SMS database backup file in the format defined in Table 1; Step 3, after SMS has made the backup file, delivers the file to SCP via commercial FTP and sends a termination message to SCP; The SCP receiving the termination message has four steps informing the operator of the progress; The operator checks the file received from the SMS and then loads the data file into the SCP database; And after the loading of the SCP is completed, the operator consists of six steps of creating an SCP database backup file to confirm that it matches the file sent by the SMS.