JPH04220719A - Data base conversion system - Google Patents

Abstract

PURPOSE:To perform data base conversion by single-time downloading to a low-order software system by eliminating a procedure for uploading a data base to a high-order software system which performs the data base converting process and downloads the converted data base to the low-order software system after the conversion. CONSTITUTION:The high-order software system 10 downloads the data base including an object version and a download data base conversion program by a transmitting means 11 together with the program which is updated to the version-up information and the low-order software system 20 after confirming the adequacy with the object version by a downloading process means 22 updates a current program into the version-updated program and update a current data base by a data base converting process means 23 according to the data base conversion program.

Description

[Detailed description of the invention]

0001

FIELD OF INDUSTRIAL APPLICATION The present invention is applied to a database conversion method for an information processing device. In particular, the present invention relates to a database conversion method in which a higher-level software system converts a database of a plurality of lower-level software systems having distributed databases in accordance with a program version upgrade.

0002

[Background Art] Traditionally, database conversion methods have been used to perform database conversion processing because when upgrading a program that changes the way the database is used, it is necessary to convert the structure and definition values of the database itself. was going on.

0003

[Problems to be Solved by the Invention] However, with such conventional database conversion methods, when upgrading a single software system, it is only necessary to perform database conversion once, but when multiple software systems are If the databases are distributed and have their own databases, in order to convert each distributed database, each database must be uploaded to a higher-level software system that performs database conversion processing, and then downloaded again to a lower-level software system after conversion. There was a problem in that a procedure had to be performed and data had to be transferred many times.

[0004] The present invention solves the above problems.
The purpose of the present invention is to provide a database conversion method that eliminates the need for database upload and download procedures and allows database conversion to be performed in a single download to a lower-level software system.

[0005]

[Means for Solving the Problems] The present invention includes a plurality of distributed lower-level devices and a higher-level device that converts a database possessed by the lower-level devices in accordance with a version upgrade of a program, and each of the above-mentioned lower-level devices In a database conversion method comprising a memory for storing a current program, its version and a database, and a main program execution means for executing the current program,
The higher-level device includes a transmission means for transmitting the version to be upgraded, the upgraded program, its version, and a database conversion program for converting the current database to each of the lower-level devices as version-up information. The apparatus includes a receiving means for receiving the version upgrade information from the transmitting means, and a system that checks whether or not the received output information is applied based on the contents of the memory, and stores the information in the memory based on the result of this confirmation. download processing means for updating the current program stored in the memory to an upgraded program stored in the memory; and database conversion processing means for updating the current database and version stored in the memory based on the database conversion program. The main program execution means includes means for executing the updated program stored in the memory.

Further, in the present invention, the memory includes an area for storing a download processing program and a current database conversion program, and the download processing means performs version confirmation processing and program update processing based on the download processing program, and stores the download processing program in the memory. The database may include means for updating a current database conversion program stored in the database.

Further, in the present invention, the transmitting means may include means for broadcasting the version up information, and the receiving means may include means for receiving the broadcast version up information.

[0008]

[Operation] The higher-level device transmits the version to be upgraded, the upgraded program, its version, and a database conversion program for converting the current database to each lower-level device as version-up information using the transmitting means. Each lower device receives version upgrade information from the transmitting means using the receiving means. The download processing means checks whether the received output information is applied based on the contents of the memory, and updates the current program stored in the memory to the upgraded program based on the check result. The database conversion processing means updates the current database and version stored in the memory based on the database conversion program. The main program execution means executes the updated program stored in the memory.

[0009] The memory also stores a download processing program and a current database conversion program;
It is desirable that the download processing means performs version confirmation processing and program update processing based on this download processing program to update the current database conversion program stored in the memory.

Furthermore, the transmitting means can broadcast the version up information, and the receiving means can receive the broadcasted version up information.

[0011] As a result of the above, database upload and download procedures are unnecessary, database conversion can be performed with one download for lower-level software systems, and by broadcast communication, database conversion can be performed for all lower-level software systems. Database conversion is possible with a single data transfer.

0012

Embodiments Examples of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram of a database conversion system according to an embodiment of the present invention.

In FIG. 1, the database conversion method is as follows:
A software system 20 is provided as a plurality of distributed lower-level devices, and a software system 10 is provided as a higher-level device that converts the database of the software system 20 as the program is updated.
Memory 2 to store its version and database
5, and main program execution means 24 for executing this current program.

The feature of the present invention is that the software system 10 stores the version to be upgraded, the upgraded program, its version, and a database conversion program for converting the current database as upgrade information. Each software system 20 includes a receiving means 21 for receiving version upgrade information from the transmitting means 11 and adapting this received output information based on the contents of the memory 25. Based on this confirmation result, the memory 25
download processing means 22 for updating the current program stored in the above to the upgraded program;
and memory 2 based on the above database conversion program.
The main program execution means 24 includes means for executing the updated program stored in the memory 25.

The memory 25 also includes an area for storing a download processing program and a current database conversion program, and the download processing means 22 performs version confirmation processing and program update processing based on this download processing program and stores the download processing program in the memory 25. Includes means for updating current database conversion programs.

Further, the transmitting means 11 includes means for broadcasting the version upgrade information, and the receiving means 21 includes means for receiving the broadcast version upgrade information.

The operation of the database conversion method having such a configuration will be explained.

FIG. 2 is a flowchart showing the operation of the database conversion method of the present invention. FIG. 3 is a diagram showing the contents of the memory of the lower-level software system of the database conversion method of the present invention. FIG. 4 is a diagram showing the contents of downloaded version upgrade information of the database conversion method of the present invention.

In FIGS. 1 and 2, the transmitting means 11 of the software system 10 transmits version upgrade information (S1). The receiving means 21 of the software system 20 receives the version upgrade information (S2). In order to execute the downloaded new database conversion program 43 in order to convert the database 35 from the current version 31 to the new version 42 within the corresponding software system 20, the current version 31 and the downloaded It is necessary to confirm the suitability of the new version 42. The current version 31 is stored in the memory 25, and the version applicable to the new database conversion program 43 of the downloaded new version 42 is described in the target version 41 of the download data (version update information), and the download process The suitability of these versions is confirmed by the download processing means 22 based on the version confirmation procedure of the program 32 (
S3).

[0020] If it is an ineligible version, the version upgrade is invalid, so a notification is sent that downloading is not possible (S4), and the main program execution means 24 continues operation with the old version and ends the procedure ( S
5).

If it is the target version, the version upgrade is recognized as valid and the download processing program 32 is executed. That is, the download processing means 2
2 is a new database conversion program 43 for downloaded data, which is a database conversion program 3 in the memory 25.
3 and updates the main program 34 with the new main program 44 (S6).

Next, the database conversion processing means 23
The database 35 is updated based on the new database conversion program 43 stored in the memory 25 (S7). Thereafter, the version 31 in the memory 25 is updated with the new version 42 of the downloaded data to indicate that the database 35 is the new version 42 (S8
).

[0023] Now that the download process has been completed, the download completion notification is sent to the software system 1.
0 (S9), executes the new main program 44 updated to the new version 42, starts operation with the new version (S10), and ends the procedure.

[0024] Note that the target version 41 is not the only one, and many versions may be applicable.
It shall be possible to describe multiple versions.

[0025] Also, considering the case where you simply want to download a specific version rather than for the purpose of upgrading, by defining a special version (for example, version 0) in the target version 41, you can ignore the version. It is also possible to incorporate a procedure for forcibly executing the download.

Furthermore, since the version upgrade information to be downloaded is the same data for each distributed software system, data transfer is performed by broadcast communication.
(broadcast method), the version upgrade can be completed with just one data transfer to all distributed software systems.

Furthermore, in this embodiment, an extra memory storage area is required for the new database conversion program 43, but this is temporary and becomes unnecessary after the database conversion process (S7) is executed. Therefore, it can be released for reuse by other programs.

[0028]

As described above, the present invention has the advantageous effect of eliminating the need for database upload and download procedures and allowing database conversion to be performed on a lower-level software system with a single download. Moreover, broadcast communication has the advantage that database conversion can be performed with one data transfer to all lower-level software systems.

[Brief explanation of the drawing]

FIG. 1 is a block diagram of a database conversion method according to an embodiment of the present invention.

FIG. 2 is a flowchart showing the operation of the database conversion method of the present invention.

FIG. 3 is a diagram showing the contents of the memory of the lower-level software system of the database conversion method of the present invention.

FIG. 4 is a diagram showing the contents of downloaded version upgrade information of the database conversion method of the present invention.

[Explanation of symbols]

10, 20 Software system 11 Transmitting means 21 Receiving means 22 Download processing means 23 Database conversion processing means 24 Main program execution means 25 Memory 31 Version 32 Download processing program 33
Database conversion program 34 Main program 35 Database 41 Target version 42 New version 43 New database conversion program 44
New main program

Claims (3)

[Claims] 1. A plurality of lower-level devices distributed in a distributed manner, and a higher-level device that converts the database of the lower-level devices as the version of the program is updated, and each of the lower-level devices converts the current program, its version, and the database. In the database conversion method, the host device stores the version to be upgraded, the upgraded program, its version, and the current database. The database conversion program includes a transmitting means for transmitting the database conversion program to each of the lower-level devices as version-up information, and each of the lower-level devices includes a receiving device for receiving the version-up information from the transmitting means, and a transmitter for transmitting the database conversion program to each of the lower-level devices as version-up information. a download processing means for checking whether the received output information is applied and updating the current program stored in the memory to the upgraded program based on the result of this check; and database conversion processing means for updating the current database and version stored in the memory based on the database, and the main program execution means includes means for executing the updated program stored in the memory. Database conversion method. 2. The memory includes an area for storing a download processing program and a current database conversion program, and the download processing means performs version confirmation processing and program update processing based on the download processing program, and stores the download processing program in the memory. 2. The database conversion method according to claim 1, further comprising means for updating a current database conversion program. 3. The database conversion system according to claim 1, wherein said transmitting means includes means for broadcasting said version up information, and said receiving means includes means for receiving said broadcasted version up information.