JP2836541B2 - Database update processing method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a processing method for updating a database, and more particularly to a database updating method for converting and updating the format of a subscriber database in an exchange.

[0002]

2. Description of the Related Art Conventionally, in updating a subscriber database in an electronic exchange system, for example, Japanese Patent Laid-Open No. 5-2 has been proposed to improve the efficiency of maintenance operation of the exchange system.
As disclosed in Japanese Patent No. 68330, this is performed by reducing the number of database update commands and inputting a command with addition or change information as a parameter from a maintenance terminal connected to the exchange for each subscriber. .

However, in updating the subscriber database as described above, when the number of contracted subscribers increases, the amount of work for creating an operator database becomes enormous.

Therefore, as disclosed in Japanese Patent Application Laid-Open No. 2-2872898, a subscriber data backup area having the same structure as the current subscriber database is provided in the storage device inside the exchange, and when there is added or changed data. ,
There is a method in which a database is temporarily transferred from a storage device provided outside to a backup area, a database normality check test is performed on this backup area, and then the subscriber database is updated by transferring the database to an active database. In this case, the workload of the operator is small.

[0005] In the above-mentioned conventional example, a method of creating a database of an external storage device (for example, a magnetic tape) is not daringly described. However, each database is provided by an operator using a database machine provided outside the exchange. It is expected to take place.

[0006]

However, the above-described conventional device has the following problems.

(1) Since the contract contents for the exchange are different for each contracted subscriber, when adding or changing the subscriber database of the exchange, the operator must perform a command operation for each contracted subscriber. The burden on the work increases.

Therefore, as the number of subscribers increases, the time and labor required for updating the subscriber database increases.

(2) When a database is created using a database machine provided outside the exchange, the types of computers constituting the exchange system and computers constituting the information processing system are different. The data structure format is different from that of the database in the exchange and cannot be used as it is in the exchange.

Therefore, when creating the subscriber database in the external device, a command is input from the maintenance terminal of the exchange to create the database, or a conversion function for converting the database into a format usable by the exchange is provided in the external device. The database must be created by converting the database by inputting the HMI command. In either case, the work speed is reduced.

SUMMARY OF THE INVENTION The present invention has been made in view of the above-mentioned problems of the prior art, and has been made in consideration of the above-mentioned problems, and has been made in consideration of the above-described problems. The aim is to provide a method.

[0012]

SUMMARY OF THE INVENTION In order to achieve the above object, the present invention provides an electronic exchange having a database definition file which defines a data structure including format information of a database in accordance with an instruction from a terminal connected to the electronic exchange. A database update processing method for updating a subscriber database stored in a backup file in a first and a second work area provided in a memory of the electronic exchange, wherein the subscriber database is updated from the terminal. When an instruction to update the database is input, a database to be newly updated is read into the first work area, and the format of the database to be updated in the first work area is referred to in the database definition file. To a format compatible with the electronic exchange, Tsu transferred from click-up file the subscriber database to the second work area, and update of the subscriber database based on the database to the update in said second working area, the updated the subscriber database It is stored in the backup file.

When the size of the second work area is smaller than the size of the backup file,
The transfer of the subscriber database to the second work area is divided by referring to the database definition file, and the update of the subscriber database is repeated for the divided number.

(Operation) In the present invention configured as described above, when updating the subscriber database stored in the exchange based on the database created by the different model, the database created by the different model Even if the format is different from the format in the exchange, since various data structures are defined in the database definition file, the database definition file is referred only by inputting the update instruction of the subscriber database by the HMI command. In this way, the format is converted and the subscriber database for the exchange is automatically updated.

[0015]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a diagram showing an embodiment of each function of the software constituting the database update processing method of the present invention and the interrelation of each function.

In this embodiment, as shown in FIG. 1, an HMI terminal 1 for inputting a command, a command control unit 2 for interpreting a command input from the HMI terminal 1 and starting a subscriber database update process, accepting an execution request from the control unit 2, for transferring the subscriber database to the work area 6 is a second work area provided from the subscriber database backup files 9 provided in the disk 11 into main memory 10 The database generation request 21 and the database to be updated from the pre-conversion database file 8 provided in the disk 11 are transferred to the work area 5, which is the first work area provided in the main memory 10, and formatted on a contractor basis. Interpret and convert data and output a database update request 22 A control unit 3, and a database management unit 4 for performing generation and updating of the database for the requested output from the high-speed data update control unit 3.

After the conversion of all the databases to be updated in the pre-conversion database file 8 is completed, a backup update request 23 is sent from the data high-speed update control unit 3 to the database management unit 4, and the work area 6 is stored in the database management unit 4. Is transferred to the subscriber database backup file 9.

Here, the data file in the database file 8 before the change is a database of a different model transferred by magnetic tape or file transfer between networks, and the database in the subscriber database backup file 9 is a switchboard. Is a subscriber database managed so far.

The database definition file 7 defines a database to be updated and a data structure of the exchange subscriber database. For example, it defines how the data is structured, what information is arranged at which position, and the like.

Hereinafter, the processing operation of the database updating processing method configured as described above will be described.

FIG. 2 is a diagram showing the processing operation of the database update processing method shown in FIG.

First, in order to perform high-speed data update control, H
A command is input in the MI terminal 1 (step 1-1).

When a command is input in the HMI terminal 1, the command control unit 2 analyzes the input command and determines a command execution processing unit (not shown) (step 2-1).

When the command execution processing section is determined, the data high-speed update control section 3 starts (step 2-2).

Then, the work area 5 and the subscriber database backup file 9 necessary for transferring and referencing the database to be updated from the pre-conversion database file 8 provided in the disk 11 in the data high-speed update controller 3 The work area 6 required for updating with reference to the database for updating the subscriber database is secured (step 3-1).

The database is updated on the secured work areas 5 and 6. The work area 6 has the highest performance when the area is the size of the subscriber database backup file 9.

Next, the subscriber database is transferred from the subscriber database backup file 9 to the work area 6.
To transmit the data, a data generation request 21 using the pointer of the work area 6 and the area size as parameters is sent from the data high-speed update control unit 3 to the database management unit 4 (step 3-2).

Then, in the database management unit 4,
The subscriber database is transferred from the subscriber database backup file 9 to the work area 6 (step 4-1).

At this time, the data structure of the subscriber database defined in the database definition file 7 is referred to, a database file is constructed on the work area, and the database is transferred to the constructed area.
You .

Here, when the size of the work area 6 is smaller than the size of the subscriber database to be read out, the subscriber database is divided and transferred .

Next, in the data high-speed update control unit 3,
The database to be updated from the pre-conversion database file 8 to the work area 5 is transferred by the size of the work area 5 (step 3-3).

Then, the data is taken out from the work area 5 on a record-by-record basis, the format of the data is interpreted and converted into a data update format (step 3-4), and the format is converted with the data index key. A data update request 22 is sent from the data high-speed update control unit 3 to the database management unit 4 using the update data as an input parameter (step 3-5).

When the database management unit 4 receives the data update request 22 (step 4-3), the subscriber database transferred to the work area 6 on the work area 6 with reference to the database definition file 7 is stored in the work area 6. 5 is updated to the converted database.
4). In work area 6, the database
The subscriber database defined in the definition file 7
Source data structure is referenced and has a predetermined format.
Area is established, and subscriber data is transferred to the constructed area.
Database has been transferred and the format
The subscriber database is updated in the area having the subscriber.

Here, if a database is not constructed on the work area 6 due to the division of the update request data specified by the parameter, the database is not updated and the data high-speed update control unit 3 performs processing. Return.

Then, the data high-speed update control section 3 determines whether or not the conversion of the data update format on the work area 5 has been completed (step 3-).
6) If it is determined that the conversion has not been completed, the processing from step 3-4 to step 3-6 is performed until all the updates of the database before conversion on the work area 5 are completed. If it is determined that the data update has been completed, the data high-speed update control unit 3
, A base backup update request 23 is sent (step 3-8).

Then, in the database management unit 4,
The database updated on the work area 6 is transferred to the subscriber data backup file 9 provided in the disk 11, and the backup file is updated.

Thereafter, the data high-speed update control unit 3 inquires the database management unit 4 about the presence / absence of file division. If there is no division, all the update processing ends. If there is division, step 3-2. Is performed, and the divided data is updated.

[0039]

Since the present invention is configured as described above, it has the following effects.

(1) Since various data structures are defined in the database definition file, when a subscriber database stored in the exchange is updated based on a database created by a different model, the different model is used. Even if the format of the created database is different from that of the exchange, the format is converted by referring to the database definition file only by inputting the update instruction of the subscriber database by the HMI command, and the exchange is automatically subscribed for the exchange. The update of the user database is performed.

As a result, the workload of the operator in creating a large number of new subscriber databases can be greatly reduced.

(2) Instead of updating the backup database on the disk for each subscriber, update the database having the same structure as the backup database constructed on the work memory, and update the backup database after the update is completed. As a result, the processing efficiency of updating the database can be significantly improved.

[Brief description of the drawings]

FIG. 1 is a diagram showing an embodiment of each function of software constituting a database update processing method of the present invention and an interrelation of each function.

FIG. 2 is a diagram illustrating a processing operation of a database update processing method illustrated in FIG. 1;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 HMI terminal 2 Command control part 3 Data high-speed update control part 4 Database management part 5, 6 Work area 7 Database definition file 8 Database file before conversion 9 Subscriber database backup file 10 Main memory 11 Disk 21 Data generation request 22 Data update request 23 Backup update request

Claims (2)

(57) [Claims] 1. A subscriber database stored in a backup file in an electronic exchange according to an instruction from a terminal connected to the electronic exchange having a database definition file defining a data structure including format information of the database. A database update processing method for updating on the first and second work areas provided in the memory of the above, wherein when an instruction to update the subscriber database is input from the terminal, Loading a database to be updated into the first work area; converting the format of the database to be updated in the first work area to a format corresponding to the electronic exchange by referring to the database definition file; From the subscriber database Characterized in that transferred to the second work area, and update of the subscriber database based on the database to the update in said second work area, and stores the updated the subscriber database to the backup file Database update processing method. 2. The database update processing method according to claim 1, wherein when the size of the second work area is smaller than the size of the backup file, the subscriber database of the subscriber database is referred to by referring to the database definition file. A database update processing method, wherein the transfer to the second work area is divided and the update of the subscriber database is repeated for the divided number.