JPH0983639A - Data base update processing method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve processing efficiency by converting the format of a data base into a format corresponding to an electronic exchange and updating a subscriber data base based on the data base to be updated. SOLUTION: When a command is inputted to an HM terminal 1, a command control part 2 decides a command execution processing part. A data update control part 8 secures an area 5 for reading the data base to be updated from a file 8 in a disk 11 so as to execute reference and a work area 6 for referring to the data base in a buffer 9 and updating it. For reading the subscriber data base to the area 6 from the file 9, a pointer and an area size are transmitted from the control part 3 to a management part 4. The management part 4 reads the data base to be updated, constructs a data base file on the work area. The data base to be updated is read and the format is interpreted. The management part 4 transfers updated data base to the file 9 and a backup file is updated.

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 processing method for converting and updating the format of a subscriber database inside a switch.

[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 content for the exchange differs for each contract subscriber, when adding or changing the subscriber database of the exchange, the operator must perform a command operation for each contract subscriber, This will increase the work load.

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 a subscriber database in an external device, a command is input from the maintenance terminal of the exchange 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, and 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, From the backup file to the second work area, the subscriber database is updated based on the database to be updated in the second work area, and the updated subscriber database is updated. It is characterized by storing in a backup file.

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

(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]

BEST MODE FOR CARRYING OUT THE INVENTION 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 to which a command is input, a command control unit 2 that interprets a command input from the HMI terminal 1 and activates a subscriber database update process, and a command. For receiving an execution request from the control unit 2 and reading the subscriber database from the subscriber database backup file 9 provided in the disk 11 to the work area 6 which is the second work area provided in the 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 read to the work area 5, which is the first work area provided in the main memory 10, and the format is interpreted in contractor units. Data height to convert and output database update request 22 An update 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 high-speed data update control unit 3 to the database management unit 4, and the database management unit 4 in the work area B6. The subscriber database therein 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 data definition file 7 defines the data structures of the database and the exchange subscriber database to be updated. 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 pre-conversion database file 8 provided in the disk 11 in the data update control unit 3
The work area 5 required to read out and refer to the database to be updated from and the work area B6 required to refer to and update the database for updating the subscriber database in the subscriber database backup file 9 are secured. (Step 3-1).

Then, the secured work areas A5 and B
6, the database is updated, and the work area B6 has the highest performance when the area is the size of the subscriber database backup file 9.

Next, in order to read the subscriber database from the subscriber database backup file 9 to the work area 6, a data generation request 21 using the pointer of the work area 6 and the area size as a parameter is issued from the data fast update control unit 3 to the database. It is sent to the management unit 4 (step 3-2).

Then, in the database management unit 4,
The subscriber database is read out 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 read aloud to the constructed area.

If the size of the work area 6 is smaller than the size of the subscriber database to be read aloud, the subscriber database is divided and read aloud.

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 read aloud for the area size of the work area 5 (step 3-3).

Then, the data is extracted from the work area 5 in units of one record, the format of the data is interpreted and converted into the format for updating the data (step 3-4), and the format is converted with the data index key. The data update request 22 is sent from the high-speed data 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 read aloud to the work area 6 in the work area 6 with reference to the database definition file 7 is the work area. 5 is read aloud and the format is updated to the converted database (step 4-
4).

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 high-speed data update control unit 3 determines whether or not the conversion of the data update format on the work area 5 is completed (step 3-
6) If it is determined that the conversion is not completed, the processes from step 3-4 to step 3-6 are performed until all the updates of the pre-conversion database on the work area A5 are completed, When it is determined that the data update is completed, the data high-speed update control unit 3 sends a base backup update request 23 to the database management unit 4 (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 constructed 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 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)

[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 Aloud to the second work area, updating the subscriber database based on the database to be updated in the second work area, and storing the updated subscriber database in 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 database definition file is referred to to save the subscriber database. A database update processing method characterized in that reading aloud to the second work area is divided and updating of the subscriber database is repeated for the divided number of times.