JP2000066939A - Backup data restration system and storage medium storing backup data restoring method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To smoothly restore data and to quickly and also appropriately operate an application program by producing backup data associating the data with a generation identifier showing the generation of a data structure. SOLUTION: A generation attaching part 102 attaches the generation number of a data structure to a new data structure while accompanying the change of an application program(AP) 100. The generation number is notified to a backup data producing part 104 and the AP 100. The backup data producing part 104 stores a data set associating the generation number with data in an external storage medium. A generation identifying part 106 reads the generation number of a data structure in the external storage medium in response to a restoration command of backup data. And, it compares an obtained generation number with the current generation number. When the both differ from each other, a restoring part 108 executes the conversion of the data structure and data whose structure is subjected to prescribed conversion becomes the data of a database 20.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for storing data that has been backed up before a data structure is changed, even if the data structure is changed such as addition, change, or deletion of an item in a database. The present invention relates to a data restoration system that can be effectively used on a database.

[0002]

2. Description of the Related Art In a computer system operating a business application program using a database, data is periodically backed up to a fixed storage medium such as a tape or an optical disk. This data backup is performed to restart the computer system using the backed up data and restart the business application program substantially in the case where the computer system goes down due to an accident or the like.

[0003] By the way, the backed up data is
It is stored independently of the application program.
Therefore, if the backed up application program is replaced with a new application program of a different generation due to version upgrade, etc., and the system goes down before the backup by the new application program is performed, the data that was backed up And a new application program is inconsistent. This is because a new application program cannot directly use backup data of an old generation. In this case, in the conventional computer system, data that has been backed up is restored using an old generation (before the generation is changed) application program and the like, and then data processing is performed using a new application program. Before executing, the data structure of the restored data had to be updated so that it could be used in a new application.

[0004]

As described above, in the conventional computer system, at the time of data storage (backup) and data restoration, inconsistency with the application program could not be detected. There has been a problem that the data restoring operation and the data updating operation (operation for matching to operate properly in a new application) are complicated.

SUMMARY OF THE INVENTION It is an object of the present invention to provide a data restoration system for smoothly restoring data and enabling an application program to operate quickly and appropriately in a computer system. In particular, when data restoration is required, it is often urgent to recover data from a failure in a computer system. Therefore, it is necessary to provide a data restoration system that can shorten the time required for restoration work and improve operability. Aim.

[0006]

In order to achieve the above object, according to the present invention, an application program using a database is operated to execute a predetermined process, and data in the database is externally stored. What is claimed is: 1. A backup data restoration system for backing up data to a storage medium and reading backed up data as needed, comprising: a generation identifier assigning unit for assigning a generation identifier uniquely indicating a generation of the data structure; A backup unit that creates backup data in which data in a database and a generation identifier are associated with each other and stores the backup data in an external storage medium; and, when restoring data, a generation identifier included in the backup data in the external storage medium. Generation and the application that is trying to restore and run the data. A comparison / matching unit that compares and matches a generation supported by the application program, and a result of the comparison / matching performed by the comparison / matching unit, where the generation indicated by the generation identifier is different from the generation supported by the application program. Is characterized by comprising: data structure conversion means for converting a data structure of data backed up in an external storage medium so as to conform to a data structure supported by the application program.

According to a second aspect of the present invention, in the first aspect of the present invention, the data structure conversion means determines a difference between a generation indicated by the generation identifier and a generation supported by the application program. Thus, a plurality of data structure conversion methods are prepared in advance. The invention according to claim 3 is an application program that uses a database to execute predetermined processing, and at the same time, backs up data in the database to an external storage medium and reads backed up data as necessary. A restoration method, comprising: a generation identifier assigning step of assigning a generation identifier uniquely indicating a generation of the data structure; and, during the backup, creating backup data in which data in a database is associated with a generation identifier. A backup step of storing the data in an external storage medium, a generation indicated by a generation identifier included in the backup data in the external storage medium during data restoration, and an application program for restoring and operating the data. Comparison with the current generation If the generation indicated by the generation identifier is different from the generation supported by the application program, the data structure of the data backed up in the external storage medium And a data structure conversion step of converting the data into a data structure supported by the application program.

The storage medium according to the fourth aspect of the present invention executes a predetermined process by causing a computer to run an application program using a database, and also backs up data in the database to an external storage medium, and A backup data restoration function for reading backed-up data according to the data structure, wherein a generation identifier assignment function for assigning a generation identifier uniquely indicating a generation of the data structure; and A backup function for creating backup data in which the backup data is associated with the external storage medium, and at the time of data restoration, a generation indicated by a generation identifier included in the backup data in the external storage medium, and data restoration. Application program And comparing and collating function of comparing and collating a generation that port, the comparison and collation step results when the generation indicated by the generation identifier, which is different from the generation to which the application program is supported,
A computer program for executing a data structure conversion function of converting a data structure of data backed up in an external storage medium so as to conform to a data structure supported by the application program is recorded. .

[0009]

Embodiments of the present invention will be described below with reference to the accompanying drawings. FIG. 1 is a schematic configuration diagram of a transfer amount automatic determination system according to an embodiment of the present invention. As shown in FIG. 1, the transfer amount automatic determination system 10 controls the entire system, activates various application programs to execute necessary processing, and an input device 14 such as a keyboard and a mouse. A display 16 for displaying processing results and the like, a communication device 18, a database 20, and an external storage medium read / write device 22 for storing data on a tape or a writable optical disk are provided. In the present embodiment, a personal computer can be used as an automatic transfer amount determination system. The communication device 18 can be connected to a host computer (not shown) via, for example, a public communication network (not shown). The CPU 12 executes an application program, and performs a process for backup and a process for data restoration. In the present embodiment, a program executed by CPU 12 is stored in a memory (not shown). The program may be configured to read out a program stored in a portable storage medium such as a CD-ROM.

FIG. 2 is a functional block diagram relating to backup and data restoration according to the present embodiment. The system includes an application program 100, a generation assignment unit 102 that assigns a generation number of a data structure of data used by the application program 100 in accordance with the data structure, a backup data creation unit 104 that creates backup data, Generation identification unit 10 for identifying the generation number of the data structure of the generated data
6 and a data restoration unit 108 for restoring data based on the identification result by the generation identification unit 106.

The data structure that can be handled by the application program 100 may change due to version upgrade or the like. Even in such a case, information on the generation of the data structure that can be handled at the current time is stored. I own it as the generation number of the application program. The "generation number"
Is an example of the "generation identifier" of the present invention, and is not particularly limited to the "number" as long as it can identify each generation. For example, various symbols and bit patterns may be used.

The generation giving unit 102 changes (for example, upgrades) the application program 100.
When the data structure of the data to be used is changed with the above, the generation number of the data structure in which the number is incremented is added to the new data structure. Based on the generation number of this data structure, comparison and collation as described below will be executed.

The backup data creation unit 104 reads data used by the application program from the database 20 and associates the read data with a corresponding generation number and stores the data in the backup external storage medium 110. The generation identification unit 106 recognizes a generation number corresponding to data stored in the external storage medium 110. Then, it is determined whether the generation is of a data structure that can be handled by the current application program, or whether the current application program cannot be handled as it is and the data structure needs to be converted. At the same time, when conversion is necessary, it is determined what conversion method to use to pass the data to the data restoration unit 108.

The data restoring unit 108 performs a data structure conversion based on the result of the comparison and collation. The conversion of the data structure includes, for example, addition, change and deletion of items in the database, addition and deletion of tables, and the like. Further, in the present specification, even when there is no change in the items of the table itself, it is assumed that the data structure has been changed in certain cases. For example, when a result calculated based on a predetermined calculation formula is automatically inserted into a certain item in a table, even if the calculation formula is changed, it is also assumed that the data structure has changed. I do.

Hereinafter, in this specification, (1) a data structure relating to a newest generation application program executed in the automatic transfer amount determination system according to the present embodiment and the processing contents thereof will be described. (2) The data structure and the processing contents of the application program of a generation older than this will be described. Further, according to the configuration shown in FIG.
(3) Data backup and restoration of the backed up data will be described. (1) Latest Generation Application Program (Latest Generation Application Program) The database 20 of the automatic transfer amount determination system according to this embodiment includes a payment source account information table storing various data relating to the payment source account, A payee account information table that stores various data relating to the account of the destination (transfer destination), an exchange settlement fee table that stores data indicating the exchange settlement fee of each financial institution, and various data relating to the counterparty to be transferred. A counterparty fee table is stored. First, each of the tables described above will be described.

FIG. 3 is a diagram showing a payment source account information table. As shown in FIG. 3, the payment source account information table 2
00 is financial institution number data 201 indicating the number of the financial institution that is the payment source, branch number data 202, and account type data 20 indicating the account type, which are set up in advance by the user.
3. It has a data set consisting of account number data 204 and account name data 205 indicating the holder of the account.
The payment source account information table 200 stores, for example, the database 20 when the user operates the input device 14.
Is generated.

FIG. 4 shows a payee account information table. This table 300 has data sets 301, 302,... For each payee. Each set of data (for example, reference numeral 301) is composed of financial institution number data 311, branch number data 312,
Deposit item data 313, account number data 314, account name data 315, fee payment category data 316 indicating a fee payment category described later, billing amount data 317 indicating the amount billed by the payee, and a user , Transfer amount data 318 indicating the amount actually transferred to the account of the payee, exchange fee data 319 paid by the paying financial institution required for the transfer, partner charge amount data 320 indicating the amount borne by the payee for the transfer, It has difference data 321 indicating the difference between the billing amount and the total amount of the transfer amount and the exchange fee. Among these data sets, the financial institution number data 311 to the fee payment classification data 316 are set in advance by the user operating the input device 14. In addition, billing amount data 31
7, the user refers to the bill from the payee and the like,
When making the transfer, the input is made by operating the input device 14.

Billing amount data 3 input by the user
17, the CPU 12 executes predetermined processing described later in accordance with the fee payment category, and calculates a transfer amount, an exchange fee, and the like. In this embodiment, the fee payment category includes the exchange fee of a financial institution,
The other party, ie, the first category paid by the payee, the second party paid by the exchange fee, ie, the second paid by the payer
And a third category in which the opponent bears a fixed fee according to the customs of commercial transactions.

In the first category, the transfer fee corresponding to the transfer amount for each financial institution is subtracted from the charge amount to determine the transfer amount. In the second category, the billing amount is directly used as the transfer amount, and the corresponding exchange fee is determined. Further, in the third category, a predetermined amount is subtracted from the billed amount to be a transfer amount, and a corresponding exchange fee is determined. The processing for determining these amounts will be described later in more detail.

FIG. 5 is a diagram showing an exchange settlement fee table storing exchange decision fees for each financial institution. FIG.
As shown in the table, the table 400 includes a data set 401, 4 representing a fee corresponding to the transfer amount for each financial institution.
02,... Are stored. For example, FIG. 5 shows commissions corresponding to three payment amounts of two financial institutions.

The above data set (for example, reference numeral 401)
Includes a financial institution number 411, transfer amount range data 412 indicating the range of the transfer amount, first fee data 413 indicating an exchange fee when transferring to the same branch by telegraph processing, and transfer to another branch by telegraph processing. The second fee data 414 indicates the exchange fee at the time of the transfer, and the third fee data 415 indicates the exchange fee at the time of transfer to another bank by the handling of a telegraph. As shown in FIG. 5, since these exchange commissions differ depending on the financial institution and the amount of the transfer, the exchange commission is set by the user operating the input device 14, or the host computer is provided with data indicating the commission of the predetermined financial institution. Request to send, set or received data,
It is stored in the database 20 in advance. The set of data stored in this table is used when calculating the transfer amount.

In the present embodiment, a table storing data for calculating a transfer amount is provided under the third category. FIG. 6 is a diagram showing a counterparty fee table used for calculating the transfer amount under the third category. In this embodiment, the payee's share amount is stored in this table so that the payee's share is the maximum amount of the exchange fee. More specifically, as shown in FIG. 6, in the counterparty commission table 500, billing amount range data 511 indicating a range of billing amounts (payable amounts to be originally paid) described in a bill of a payee, etc. And data sets 501, 502,... Having a counterpart pay amount data 512 indicating a payee's share amount.
・ Is stored.

The data values of the data constituting the table shown in FIG. 6 can be set as desired by operating the input device 14 by the user. The set of the set data is stored in the database 20. In the present embodiment, the CPU 12 automatically calculates the amount to be transferred with reference to the tables shown in FIGS. 5 and 6 as described above. Hereinafter, the contents of the application program for calculating the transfer amount executed by the CPU 12 will be described in more detail.

First, the user operates the input device 14 to start the program of the CPU 12. CP
In response, U12 responds by sending a payee account information table 3
00 is read and the corresponding image is displayed on the screen of the display 16. The user refers to the image displayed on the screen of the display 16 and inputs the billing amount described in the bill or the like into the billing amount column of the required payee, using the input device 1.
Operate 4 and input. The input amount corresponds to the charged amount data 317 in FIG.

When the input of the billing amount is completed, the CPU 12 starts a process for calculating the transfer amount. FIG. 7 is a flowchart showing an outline of the processing for calculating the transfer amount according to the present embodiment. As shown in FIG. 7, when the processing is started, the CPU 12 refers to the payee account information table shown in FIG. 4, inputs a billed amount this time, and based on the billing amount, determines a transfer amount and the like. Identify a data set that includes billing amount data. Next, the CPU 12 refers to the fee payment category data 316 included in the specified data set, and determines which of the first category to the third category corresponds (steps 701 and 702). .

For example, when the transfer amount and the like should be calculated under the third category (Yes in step 701)
Proceeds to step 703. When it is determined NO in step 701, the process proceeds to step 702,
Here, when calculation is to be performed under the first category (step 70)
If yes in 2), the process proceeds to step 704. Alternatively, in the case of No at step 702, ie, the second
If the calculation is to be performed under the category of, the process proceeds to step 705. FIGS. 8, 9 and 10 show steps 703 and 703, respectively.
6 is a flowchart illustrating the processing of Steps 705 to 705 in more detail.

As shown in FIG. 8, in the processing under the third category, a transfer amount is calculated from the billing fee range data to which the charged amount belongs from the counterparty commission table 500 (step 801). This can be obtained by subtracting the partner charge amount data 512 from the charge amount data 317. Further, it is determined whether the transfer amount is 0 (zero) or minus (step 802).
If the result of this step 802 is affirmative (Yes), the fact that the transfer amount has become zero or negative is displayed on the screen of the display 16. In response, the user inputs a desired transfer amount using the input device 14 (step 803). Thereby, the transfer amount is determined.

Next, the CPU 12 refers to the exchange settlement fee table 400 to determine an exchange fee corresponding to the transfer amount range of the obtained transfer amount (step 80).
4). The data on the transfer amount and the exchange fee thus obtained are respectively transferred amount data 318
And exchange fee data 319 is stored in a corresponding column of the payee account information table. Further, data relating to the counterparty charge and the difference (= invoice amount− (transfer amount + exchange fee)) are also stored in the corresponding columns of the payee account information table as counterparty charge data 320 and difference data 321, respectively. (Step 80
5).

In this manner, the transfer amount, the exchange fee, the partner's share, and the difference under the third category are calculated. Next, a process of calculating a transfer amount and the like under the first category will be described. As shown in FIG. 9, when the transfer amount or the like should be calculated under the first category, first, in the payee account information table 300, the charge amount data 30
In the data set including 1,302,..., The corresponding data set is searched for in the exchange settlement fee table 400 with reference to the financial institution number data 311 and the billing amount data 317. . Next, fee data 413, 414 or 415 corresponding to the transfer amount range 412 is specified from the charge amount data 317 according to the type of the financial institution number data 311, the branch data 312, etc. of the payee. More specifically, whether or not the financial institution number data 311 of the payee account information table 300 is the same as the financial institution number data 201 of the payer account information table 200 is determined by checking the branch number data 312 of the payee account information table 300. Is determined to be equal to the branch number data 202 in the payment source account information table 200, and thereby, any of the fee data 413, 414, or 415 in the foreign exchange settlement fee table 400 is specified. In this way, when the exchange fee is specified, the CP
U12 calculates the transfer amount data 318 by subtracting the exchange fee from the charged amount (step 901). Under the first category, the above-described subtraction is performed because the partner (payee) bears the exchange fee.

Next, it is determined whether the transfer amount is 0 (zero) or negative (step 902). Steps 902 and 903 correspond to steps 802 and 803 in FIG. 8, respectively.
Next, the CPU 12 sets the exchange settlement fee table 400
, The exchange fee data 319 based on the obtained transfer amount is calculated (step 904). Here, it is determined whether or not the exchange fee based on the billed amount obtained in step 901 matches the exchange fee based on the transfer amount obtained in step 904 (step 905). This is because, when the exchange fee is paid by the other party (payee), for a certain range of amount, the transfer amount after deducting the exchange fee first, This is because it may be different. For example, if the exchange fee of a certain financial institution is less than $ 30,000, the cost is $ 420, and if it is more than $ 30,000, it is $ 630. Here, the billed amount described in the bill is $ 3
In the case of 0,600, assuming that the transfer amount is obtained by subtracting the foreign exchange commission from the billed amount, the following is obtained: ¥ 30,600- $ 630 = $ 29,970. On the other hand, the exchange fee for this transfer amount of $ 29,970 is $ 420, and a difference occurs in the exchange fee. In the example described above, the range (gray zone) where the difference in the exchange fee occurs is from $ 30,420 to $ 30,62.
The range is up to 9.

As described above, in the case of the gray zone, since the total amount of the amount to be paid by the user cannot be uniquely determined, the CPU 12 displays the fact on the screen of the display 16 and inputs the transfer amount to the user. (Step 906). After the determination in step 905 is Yes, or after a predetermined amount is input by the user in step 906, the transfer amount data and the exchange fee data are stored in the transfer amount data 318 and the exchange fee data, respectively. 319 is stored in the corresponding column of the payee account information table. Further, data relating to the counterparty charge and the difference (= invoice amount− (transfer amount + exchange fee)) are also stored in the corresponding columns of the payee account information table as counterparty charge data 320 and difference data 321, respectively. (Step 90
7). In this way, the transfer amount under the first category,
The exchange fee, the partner's share and the difference are calculated.

Under the first category, the billing amount is the same as the transfer amount + exchange fee except in the case where the billing amount is included in the gray zone. Next, a process of calculating a transfer amount and the like under the second category will be described. As shown in FIG. 10, when the transfer amount or the like should be calculated under the second category, first, the fee data is specified by the same method as the processing under the first category shown in FIG. Yes (Step 100
1). Further, under the second category, the exchange fee is borne by the payer, so the billed amount becomes the transfer amount as it is.

The data relating to the transfer amount and the exchange fee obtained in step 1001 are stored in the corresponding columns of the payee account information table as the transfer amount data 317 and the exchange fee data 318, respectively. In addition, data on the counterparty charge (0 yen) and the difference (= billing amount-(transfer amount + exchange fee)) are also stored in the corresponding columns of the payee account information table as the counterparty charge data and the difference data, respectively. It is stored (step 1002). In this manner, the transfer amount, the exchange fee, the partner's share, and the difference under the second category are calculated. (2) Old generation application program (old generation application program) For example, in an application program of one generation older than the application program described in (1) above, calculation of the transfer fee by the third category (that is, exchange fee) It is considered that the transfer fee could be calculated only under the first and second categories. For this reason, in the generation system using this application program, there is no data item of the counterparty payment in the fee payment classification data (see reference numeral 316 in FIG. 4) of the payment account information table, and FIG. There is no counterparty fee table shown. Also, this application program includes steps 701 and 70 in FIG.
Step 3 is not provided. (3) Data Backup and Restoration of Backed-Up Data The database 20 is backed up under the above-mentioned old-generation application program, and the backed-up data is restored under the latest-generation application program. This will be described with reference to FIG. FIG. 11 is a diagram for explaining an outline of backup and data restoration processing according to the present embodiment.

As described above, when the data structure of the data to be used is changed in accordance with the change (for example, version upgrade) of the application program, the generation assigning unit 102 increments the number of the data structure. Is assigned to a new data structure. For example, if the generation number is increment management, if the generation number of the data structure of the data used in the old generation application program is “n”,
When the latest generation application program is created, the generation number of the data structure of the data is “n + 1”.

When the backup data is created, the generation number is notified from the generation assigning section 102 to the backup data creating section and also to the application program. Therefore, the application program knows the generation number of the data structure of the data used by itself. By the operation of the backup data creation unit 104, the generation number 122 of the data structure and the data 12
4 is stored in the external storage medium 110.
Is stored. For example, when backing up data used by the above-mentioned old-generation application program,
The generation number “n” corresponding to this data is stored in the external storage medium 110 together with the data.

For example, the backup is executed according to the processing shown in FIG. First, when the user operates the input device 14 to instruct execution of backup (step 1201), the backup data creation unit 104
Stores the data set in which the generation number is associated with the data in the external storage medium 110 as described above (step 1202). In this case, the generation number and the data may be stored in different storage media.

It is assumed that after the backup is completed in this way, the application program is changed, and for some reason, the data stored in the external storage medium 110 must be read and restored. For example, this corresponds to a case where data used in the latest generation application program is destroyed and data used in the old generation application program should be used.

The processing in such a case will be described with reference to the flowchart of FIG. Generation identification unit 106
Is a command for restoring backup data given by the user operating the input device 14 (step 130).
In response to 1), the generation number 132 of the data structure in the data set (see reference numeral 130 in FIG. 11) in the external storage medium 110 is read out via the external storage medium read / write device 22, and the memory (shown in FIG. (Step 1302).

Next, a generation number (see reference numeral 152 in FIG. 11) to be used in the application program to be restored and restarted is obtained (step 130).
3). As described above, since the generation number of the data structure used by the application program is known by the application program, the generation identification unit 106 may receive the current generation number from the application program.

Further, the generation identifying unit 106 determines in step 1
The generation number obtained in 302 is compared with the generation number obtained in step 1303 (step 1304).
For example, even if the generation of the application program differs, the data structure itself of the data to be used may not be changed. If both generation numbers match (Yes in Step 1304), the data stored in the external storage medium 110 is restored as it is, that is, becomes the data of the database 20 as it is (Step 1305). ).

On the other hand, if the two are different, the data restoration unit 108 is activated. In the data restoration unit 108, a data conversion program for each of the generation numbers is provided. Therefore, the data restoration unit 108
Refers to the generation number at the time of backup and the generation number of the data used in the application program to be restored and restarted from the generation identifying unit 106, and activates the necessary data structure conversion program, A structure conversion is performed (step 1306). The conversion of the data structure includes addition, change, and deletion of items in the database, addition of tables, addition of items to be deleted, and the like.

For example, the generation number of the data structure of the data at the time of backup used in the old generation application program is "n", and the generation number of the data structure of the data to be used in the latest application program is "n + 1". , The generation number “n” at the time of backup and the generation number “n” of the data to be used in the application program to be restored and restarted.
The necessary conversion (in this example, creation of the destination table and setting of default values in the table, etc.) is executed using a data structure conversion program between "+1" and "1". Are converted into data of the database 20 (step 1305).

According to the present embodiment, the generation number of the data structure is associated with the backup data, and the generation number of the data structure of the backup data and the application program to be restored and restarted when the data is restored Is compared with the generation number of the data structure of the data used in the above, and the data structure of the backup data is converted in accordance with the result of the comparison, so that the data can be smoothly restored without complicated procedures. .

Further, according to the present embodiment, the generation number of the data structure is stored and compared with the generation number. Therefore, when the data structure of the data to be used is not changed due to the change of the application, there is no need to execute the data structure conversion processing, and thus it is not necessary to execute useless processing. Further, according to the present embodiment, in the data restoration unit,
Since the data structure conversion is executed, regardless of the generation of the data structure of the backed up data and the generation of the data structure of the data to be used in the application program that should restore and restart the data, Conversion can be performed.

The present invention is not limited to the embodiments described above, and various modifications can be made within the scope of the invention described in the claims, which are also included in the scope of the present invention. Needless to say, this is done. For example, in the above embodiment, the backup data restoration system is applied to the automatic transfer amount determination system. However, the present invention is not limited to this, and any system using a database can be used. Even so,
The present invention can be applied.

Also, in the above embodiment, the generation number of the backed-up application program (old generation application program) is “n”,
Although the generation number of the application program (the latest generation application program) to be restored and restarted is “n + 1”, these generation numbers may be any. This is because the data restoration unit 108 stores a data format conversion program for each generation number.

Further, in the above embodiment, the generation of the data format is stored in the external storage medium in association with the data at the time of backup. In addition to this, the generation of the application program is stored. May be. Further, in this specification, means does not necessarily mean physical means, but also includes a case where the function of each means is realized by software. Further, the function of one means may be realized by two or more elements, or the function of two or more means may be realized by one element.

[0048]

According to the present invention, it is possible to provide a data restoration system that smoothly restores data and enables an application program to operate quickly and appropriately in a computer system.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram showing a firm banking system using an automatic transfer amount determination system according to an embodiment of the present invention.

FIG. 2 is a block diagram related to backup and data recovery in the CPU according to the embodiment;

FIG. 3 is a diagram showing a payment source account information table according to the embodiment;

FIG. 4 is a diagram showing a payee account information table according to the embodiment;

FIG. 5 is a diagram showing an exchange settlement fee table storing exchange determination fees for each financial institution according to the present embodiment.

FIG. 6 is a diagram showing a counterparty fee table used for calculating a transfer amount under a third category according to the present embodiment.

FIG. 7 is a flowchart illustrating an outline of a calculation process of a transfer amount and the like according to the embodiment;

FIG. 8 is a flowchart illustrating a calculation process of a transfer amount and the like according to the present embodiment in more detail.

FIG. 9 is a flowchart illustrating the calculation processing of the transfer amount and the like according to the present embodiment in more detail.

FIG. 10 is a flowchart illustrating a calculation process of a transfer amount and the like according to the present embodiment in more detail.

FIG. 11 is a diagram showing an outline of backup and data restoration processing according to the embodiment;

FIG. 12 is a flowchart illustrating a backup process according to the embodiment;

FIG. 13 is a flowchart illustrating data restoration processing according to the present embodiment.

[Explanation of symbols]

 REFERENCE SIGNS LIST 10 transfer amount automatic determination system 12 CPU 14 input device 16 display 18 communication device 20 database 22 external storage medium read / write device 100 application program (AP) 102 generation assigning unit 104 backup data creation unit 106 generation recognition unit 108 data restoration unit 110 external storage Medium

Claims (4)

[Claims] 1. A backup data restoring system for executing predetermined processing by operating an application program using a database, backing up data in the database to an external storage medium, and reading backed up data as necessary. A generation identifier assigning means for assigning a generation identifier uniquely indicating a generation of the data structure, and, at the time of the backup, creating backup data in which data in a database and a generation identifier are associated with each other;
Backup means for storing the data in an external storage medium, a generation indicated by a generation identifier included in the backup data in the external storage medium at the time of data restoration, and an application program for restoring and operating the data are supported. A comparison / matching unit that compares and collates the generation with the generation program. If the generation indicated by the generation identifier is different from the generation supported by the application program, The data structure of the data backed up in the medium is
A backup data restoration system, comprising: data structure conversion means for performing conversion so as to conform to a data structure supported by the application program. 2. The data structure conversion means prepares a plurality of data structure conversion methods in advance according to the manner of difference between the generation indicated by the generation identifier and the generation supported by the application program. The backup data restoration system according to claim 1, wherein 3. A backup data restoring method for executing a predetermined process by operating an application program using a database, backing up data in the database to an external storage medium, and reading out the backed up data as needed. A generation identifier assigning step of assigning a generation identifier uniquely indicating a generation of the data structure, and, at the time of the backup, creating backup data in which data in the database and a generation identifier are associated with each other;
A backup step of storing the data in an external storage medium, a generation indicated by a generation identifier included in the backup data in the external storage medium at the time of data restoration, and an application program for restoring and operating the data are supported. A comparison and collation step for comparing and collating with the generation that is being executed.If the generation indicated by the generation identifier is different from the generation supported by the application program, A data structure conversion step of converting a data structure of backed-up data so as to conform to a data structure supported by the application program. 4. A backup data which reads out the backed-up data by backing up the data in the database to an external storage medium while executing predetermined processing by operating an application program using the database in a computer. A restoration function, a generation identifier assigning function for assigning a generation identifier uniquely indicating a generation of the data structure; and, during the backup, creating backup data in which data in a database is associated with a generation identifier. ,
A backup function for storing in an external storage medium, a generation indicated by a generation identifier included in the backup data in the external storage medium at the time of data restoration, and an application program for restoring and operating data are supported. A comparison and collation function for comparing and collating with the generation that is present.If the generation indicated by the generation identifier is different from the generation supported by the application program, A data structure conversion function for converting the data structure of the backed-up data so as to conform to the data structure supported by the application program; and a computer-readable storage for recording a computer program for executing Medium.