JP2004171529A - Data backup system and data backup method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To regularly lay a database in the latest state in conformation to the occurrence of a transaction of the database and to rapidly perform restoration in the occurrence of a disaster. <P>SOLUTION: The data stored in the business database 5 of a server 1 are backed up in the storage database 11 of a storage center 2 in a remote place as a total backup. The transaction data 6 of the server 1 are transferred to the storage center 2. In the storage center 2, the total backup of the storage database 11 is read, subjected to transaction adaptation processing, and restored in the storage database 11. According to this, the data of the server 1 can be regularly backed up to the latest state in the storage center 2, and when the server 1 requires restoration due to disaster or the like, this restoration work can be rapidly performed. <P>COPYRIGHT: (C)2004,JPO

Description

  The present invention relates to a data backup system for backing up data, and more particularly, to a data backup system and a data backup method capable of updating a database in transaction units and enabling quick recovery in the event of a disaster or the like.

  FIG. 7 is a schematic diagram showing the configuration of a conventional data backup system. In the illustrated backup system, a backup center 71 is installed at a remote location at a predetermined distance from a location where a backup target (server) 70 operated by a user is located. The database 72 provided in the backup center 71 stores the entire data (entire backup) 80 of the backup target 70. Then, the transaction (difference) data 81 generated by the occurrence of the job is stored in the storage medium such as a tape or the database 72 via the network 73 as needed.

  As a result, the entire backup 80 and the transaction data 81 of the backup target 70 can be saved (backed up) at the backup center 71 at a remote location, and the installation location of the backup target (server) 70 is damaged by a disaster or the like. In this case, a backup set 82 (composed of the entire backup 80 and the transaction data 81) can be obtained from the backup center 71 to restore the data contents.

  As described above, in order to prepare for a disaster occurring in a specific wide area, a technique of installing a database storage means at a distant point and storing the data as backup data in a distant database is disclosed in, for example, Japanese Patent Application Laid-Open No. H11-163,037. Is disclosed.

JP-A-9-146812

  However, in the above-described conventional technology, the transaction data 81 is accumulated in the backup center 71 every time a transaction occurs. Therefore, the amount of data in the backup center 71 becomes enormous, and a storage space for data such as tape is required. At the same time, management took time.

  Further, when the backup target 70 needs to be restored, there is a problem that the restoration takes time. That is, the backup center 71 stores all the transaction data 81 in units such as until the occurrence of a disaster or every year, so that a backup set 82 necessary for recovery after the occurrence of a disaster is created (ie, The process of generating the updated data in which the difference processing of the transaction data 81 is applied to the whole backup 80) itself is extremely troublesome and time-consuming.

  At this time, when applying the differential processing of the accumulated long-term transaction data 81, the validity of the application must be verified for each transaction data 81, and the validity is verified according to the number of transaction data 81. It took a considerable amount of time.

  SUMMARY OF THE INVENTION The present invention solves the above-mentioned problems of the prior art, and provides a data backup system and a data backup system that can always update the contents of a database in response to the occurrence of a database transaction and can quickly recover in the event of a disaster or the like. The aim is to provide a method.

  In order to solve the above-mentioned problems and achieve the object, a data backup system according to the first aspect of the present invention includes a server having a database, and a remote storage center for backing up data contents of the database of the server. Wherein the server includes a transfer unit for transferring the transaction data to the storage center every time transaction data is generated, and the storage center stores the entire backup data obtained by backing up the database of the server. A storage unit, and performing a transaction application process using the transaction data on the entire backup corresponding to the server each time the transaction data is received from the server; Characterized in that said data processing means also re-store the entire backup data after Deployment application process.

  According to the first aspect of the present invention, each time transaction data is generated in a remote server, the storage center executes a transaction application process using the transaction data on the entire backup, and stores the transaction data in the storage unit. Since the entire backup data after the application processing is re-stored, transaction data storage is not required, the entire backup data can be kept up to date at all times, and the server installation location is damaged by a disaster etc. in the database In this case, quick recovery can be achieved using the entire backup data of the storage center.

  A data backup system according to a second aspect of the present invention is a data backup system comprising: n servers each having a database; and a remote storage center for backing up data contents of the database for each of the n servers. In the backup system, the n servers include a transfer unit that transfers the transaction data to the storage center each time transaction data occurs, and the storage center backs up a database provided for each of the n servers. Storage means for storing the whole backup data in a corresponding area from among the n areas respectively allocated to the n servers; and each time the transaction data is received from the n servers, the n servers Said each assigned to each And performing transaction application processing using the transaction data on the whole backups stored in the n areas, and transferring the n backups after the transaction application processing to the n servers assigned to the n servers, respectively. Data processing means for restoring the data in the area.

  According to the second aspect of the present invention, the storage center executes the transaction application processing using the transaction data for the corresponding whole backup every time the transaction data is generated in the n servers installed in the remote locations. However, since the entire backup data after the transaction application processing is re-stored in the storage means, the storage of the transaction data becomes unnecessary, and the entire backup data can be kept up-to-date at all times. In the case where the database is damaged in the above, quick recovery can be achieved by using the whole backup data of the storage center. Also, a transaction application process is performed each time transaction data is transmitted from n servers, and the entire backup data can be re-stored in the storage means corresponding to each server. Therefore, one backup system is prepared for each server. This eliminates the need to perform the backup and makes the efficiency of the backup facility more efficient.

  Further, in the data backup system according to the third aspect of the present invention, in the invention according to the second aspect, each time the transfer means receives transaction data transferred from each of the n servers, the transaction data is transferred to the n number of servers. Storage means for temporarily storing data in a corresponding storage area from among the n storage areas allocated to each of the servers, and wherein the data processing means comprises a storage unit which is allocated to each of the n servers. Means for acquiring the transaction data stored in the storage area, and executing the transaction application process using the transaction data for each of the entire backups stored in the area allocated to each of the n servers. And execute the entire backup after the transaction application processing. Characterized by restoring the update in the appropriate region from among the n regions of the storage means assigned respectively to each of the n servers.

  According to the third aspect of the present invention, when transaction data is received from n servers and another transaction data application process is being executed, the received transaction data can be temporarily stored. In addition, the processing when the transaction data is continuously received can be multiplexed to increase the efficiency.

  According to a fourth aspect of the present invention, in the data backup system according to any one of the first to third aspects, the data processing unit verifies that the execution of the transaction application processing is appropriate. Means for not executing the transaction application processing when it is not appropriate.

  According to the fourth aspect of the present invention, it is possible to appropriately determine whether or not the transaction application processing has been executed, and it is possible to always maintain the entire backup data in a normal state.

  The data backup system according to a fifth aspect of the present invention is the data backup system according to the fourth aspect, wherein, when the execution of the transaction application processing is not appropriate, the corresponding error is reported. I do.

  According to the fifth aspect of the present invention, it is possible to detect an abnormality in the transaction data and take an appropriate countermeasure.

  According to a sixth aspect of the present invention, in the data backup system according to any one of the first to fifth aspects, the data processing unit reads the transaction application process from the storage unit and performs an overall backup. The method is characterized in that data is developed into a database image file and executed on a copy of the database image file.

  According to the invention of claim 6, the transaction application processing can be performed while protecting the entire backup data, and the reliability of the system can be improved.

  A data backup system according to a seventh aspect of the present invention is the data backup system according to any one of the first to sixth aspects, wherein the entire backup data after the transaction application processing is compressed and stored in the storage unit. A writing means is provided.

  According to the seventh aspect of the present invention, the whole backup data is compressed and stored in the storage means, so that the capacity of the storage means can be effectively used and a large amount of the whole backup data can be stored.

  In the data backup system according to an eighth aspect of the present invention, in the invention according to the seventh aspect, when reading out the entire backup data in the data compression state stored in the storage means during the transaction application processing, the data is expanded and read out. A reading means is provided.

  According to the eighth aspect of the present invention, the transaction application processing can be executed smoothly, and the data compression for the storage means can be effectively executed.

  A data backup system according to a ninth aspect of the present invention is the data backup system according to any one of the first to eighth aspects, further comprising a network for transferring data between the server and the storage center. Features.

  According to the ninth aspect of the present invention, the whole backup data and the transaction data can be transferred via the network, and the data transfer can be easily performed.

  A data backup system according to a tenth aspect of the present invention is the data backup system according to any one of the first to ninth aspects, wherein the data is written and read in order to transfer data between the server and the storage center. It is characterized by using a possible storage medium.

  According to the tenth aspect of the present invention, when the network cannot be used due to a disaster or the like, when the network load increases and the efficiency is low, or when large-capacity data transfer such as whole backup data is required, the transfer reliability is improved. For example, when data is to be improved, data can be transferred safely and confidentially using a storage medium.

  The data backup method according to the invention of claim 11 is a data backup method for transferring data contents of a database to a remote location and backing up the data contents, wherein each time transaction data is received from the database, the data is backed up in advance. It is characterized by including a transaction reflection processing step of executing a transaction application processing using the transaction data for the entire backup data of the database.

  According to the eleventh aspect of the present invention, every time transaction data is generated in a remote place, a transaction application process using the transaction data is executed for the whole backup, and the whole backup data after the transaction application process is obtained. Since it is possible to save transaction data, it is possible to keep the whole backup data up to date at all times, and if the database is damaged due to a disaster etc., use the full backup data for quick recovery Can be.

  A data backup method according to a twelfth aspect of the present invention is the data backup method according to the eleventh aspect, further comprising a verification step of verifying whether or not the transaction reflection processing step is performed properly. The application processing is not executed.

  According to the twelfth aspect of the invention, it is possible to appropriately determine whether or not the transaction application processing is performed, and to maintain the entire backup data in a normal state at all times.

  In a data backup method according to a thirteenth aspect of the present invention, in the invention according to the eleventh or twelfth aspect, when the number of the databases is n, one of the transaction reflection processing steps may be the one received from the n databases. The transaction application process is performed on one corresponding whole backup data of the n databases in which transaction data has been backed up in advance.

  According to the thirteenth aspect of the present invention, each time transaction data is transmitted from the n databases, the transaction application processing can be performed on the entire backup data corresponding to each database and backed up in advance. Therefore, there is no need to prepare one backup system for each server, and the efficiency of backup facilities can be increased.

  In a data backup method according to a fourteenth aspect of the present invention, in the invention according to the thirteenth aspect, the transaction reflection processing step includes the step of: receiving transaction data from one of the n databases. Data is temporarily stored, and the transaction application process is performed on one corresponding whole backup data among the n databases in which the stored transaction data is backed up in advance. .

  According to the fourteenth aspect of the invention, when transaction data is received from one of the n databases and another transaction data is being applied, the received transaction data is temporarily stored. Therefore, when transaction data is continuously received, processing can be multiplexed and efficiency can be increased.

  As described above, according to the first aspect of the present invention, in a data backup system including a server having a database and a remote storage center for backing up data content of the database of the server, The server includes a transfer unit that transfers the transaction data to the storage center every time the transaction data is generated. The storage center stores storage data for backing up the database of the server, and a transaction from the server. Each time data is received, a transaction application process using the transaction data is performed on the entire backup corresponding to the server, and the storage unit stores the entire backup data after the transaction application process. Since the storage center is provided with a data processing unit for storing, every time transaction data is generated in a remote server, the storage center executes a transaction application process using the transaction data for the entire backup, and stores the transaction data in the storage unit. Since the entire backup data after the transaction application processing is re-stored, the storage of transaction data is not required, the entire backup data can be kept up-to-date at all times, and the server installation location was damaged by a disaster etc. in the database In this case, there is an effect that quick recovery can be achieved using the entire backup data of the storage center.

  According to the second aspect of the present invention, there is provided a data backup system comprising n servers each having a database and a remote storage center for backing up data contents of the database for each of the n servers. In the system, the n servers include a transfer unit that transfers the transaction data to the storage center each time transaction data is generated, and the storage center is configured to back up a database provided for each of the n servers. Storage means for storing the backup data in a corresponding area from among the n areas allocated to each of the n servers, each time receiving transaction data from the n servers, Stored in the n areas respectively assigned to Data processing for executing a transaction application process using the transaction data on a local backup, and restoring the whole backup data after the transaction application process in the n areas allocated to each of the n servers Means, the storage center executes a transaction application process using the transaction data for the corresponding whole backup every time transaction data is generated in n servers installed in remote locations, Since the whole backup data after the transaction application processing is re-stored in the storage means, it becomes unnecessary to store the transaction data, the whole backup data can be always kept up-to-date, and the installation location of the server can be stored in the database due to a disaster or the like. Damage If digits can be achieved quick recovery using a full backup data storage center. Also, a transaction application process is performed each time transaction data is transmitted from n servers, and the entire backup data can be re-stored in the storage means corresponding to each server. Therefore, one backup system is prepared for each server. Therefore, there is an effect that the efficiency of backup equipment can be increased.

  According to the invention described in claim 3, in the invention described in claim 2, each time the transfer means receives the transaction data transferred from the n servers, the transaction data is transferred to the n number of servers. Storage means for temporarily storing in the corresponding storage area from among the n storage areas respectively allocated to the servers, wherein the data processing means comprises the storage means allocated to each of the n servers Acquiring the transaction data stored in the storage area, and executing the transaction application process using the transaction data for each of the entire backups stored in the area allocated to each of the n servers. Then, the entire backup data after the transaction application processing is Is re-stored in the corresponding area from the n areas of the storage means allocated to each of the servers, so that when the transaction data is received from the n servers, the application processing of the other transaction data is executed. In this case, the received transaction data can be temporarily stored, so that there is an effect that the processing when the transaction data is continuously received can be multiplexed and the efficiency can be increased.

  According to the invention described in claim 4, in the invention described in any one of claims 1 to 3, the data processing unit verifies whether execution of the transaction application process is appropriate. When the transaction is not appropriate, the transaction application processing is not executed. Therefore, it is possible to appropriately determine whether the transaction application processing is executed, and it is possible to always maintain the entire backup data in a normal state. .

  According to a fifth aspect of the present invention, in the fourth aspect of the present invention, when the execution of the transaction application processing is not appropriate, the verification unit notifies the corresponding error content. This has the effect of detecting abnormalities and taking appropriate measures.

  According to the invention described in claim 6, in the invention described in any one of claims 1 to 5, the data processing means performs the transaction application processing by reading the entire backup data read from the storage means. Is developed into a database image file and executed for a copy of the database image file, so that transaction application processing can be performed while protecting the entire backup data, and the effect of improving the reliability of the system is achieved. .

  According to the invention described in claim 7, in the invention described in any one of claims 1 to 6, the whole backup data after the transaction application processing is compressed and stored in the storage unit. Since the whole backup data is compressed and stored in the storage means, the capacity of the storage means can be effectively used and a large amount of the whole backup data can be stored.

  According to an eighth aspect of the present invention, in the invention of the seventh aspect, when reading out the entire backup data in the data compression state stored in the storage means at the time of the transaction application processing, the data is expanded and read out. Since the means is provided, it is possible to smoothly execute the transaction application processing, and to effectively perform data compression on the storage means.

  Further, according to the ninth aspect of the present invention, in the invention according to any one of the first to eighth aspects, a network for transferring data between the server and the storage center is provided. , The entire backup data and transaction data can be transferred, and the data transfer can be easily performed.

  According to a tenth aspect of the present invention, in the invention of any one of the first to ninth aspects, in order to transfer data between the server and the storage center, writing and reading are possible. When a network cannot be used due to a disaster, etc., when the network load increases and it is inefficient, when large-capacity data transfer such as whole backup data is required, or when the reliability of transfer is improved For example, data can be transferred safely and confidentially using a storage medium.

  Further, according to the invention as set forth in claim 11, in the data backup method for transferring the data content of the database to a remote location and backing up the database, every time transaction data is received from the database, A transaction reflection processing step of executing the transaction reflection processing using the transaction data for the entire backup data, so that every time transaction data is generated in a remote place, the transaction application using the transaction data for the whole backup is performed. Execute the processing and obtain the whole backup data after the transaction application processing.There is no need to store the transaction data, and the whole backup data is always kept up to date. Can be, if the damaged database disaster or the like, an effect that it is possible to quickly recover by using the full backup data.

  According to a twelfth aspect of the present invention, in the invention according to the eleventh aspect, the method further includes a verification step of verifying whether or not the execution of the transaction reflection processing step is appropriate. Since the process is not executed, the presence or absence of the execution of the transaction application process can be appropriately determined, and the whole backup data can be always maintained in a normal state.

  According to a thirteenth aspect of the present invention, in the invention according to the eleventh or twelfth aspect, when the number of the databases is n, one transaction received from the n databases Since the transaction application process is performed on one corresponding whole backup data of the n databases that have previously backed up data, every time transaction data is transmitted from the n databases, Since transaction application processing can be performed on the entire backup data corresponding to each database and backed up in advance, there is no need to prepare one backup system for each server, and the efficiency of backup facilities is improved. Can be There is an effect that that.

  According to a fourteenth aspect of the present invention, in the invention of the thirteenth aspect, the transaction reflection processing step includes, when transaction data is received from one of the n databases, the transaction data Is temporarily stored, and the transaction application process is executed on one corresponding whole backup data among the n databases in which the stored transaction data is backed up in advance. When transaction data is received from one of the databases and another transaction data is being applied, the received transaction data can be temporarily stored, so the transaction data can be received continuously. And multiplex processing to improve efficiency There is an effect that it is Rukoto.

  Preferred embodiments of a data backup system and a data backup method according to the present invention will be described below in detail with reference to the accompanying drawings.

(Embodiment 1)
FIG. 1 is a schematic diagram showing a configuration of a data backup system according to the present invention. The user installs the backup target (server) 1 at a predetermined location. A storage center 2 is provided at a remote location at a predetermined distance from the installation location of the server 1.

  The server 1 has a business database 5 for daily business, which is referred to at the time of business progress, and generates transaction (TR) data (difference data) 6 as the business progresses. The business content includes, for example, ledger browsing and update work in an administrative organization. The operation database 5 stores an entire backup of contents in a storage medium 10 such as a DAT at the start of operation. Further, the transaction data 6 generated each time the work progresses is transferred to the storage center 2 via the network 7. During this transfer, the server 1 compresses the data, and the storage center 2 decompresses the compressed data. The transaction data 6 may be stored in a storage medium and transferred to the storage center 2 each time the transaction data 6 is generated.

  The storage center 2 has a storage database 11 corresponding to each of the database engines of a plurality of servers 1 provided at remote locations. Examples of the storage database 11 include SQL Server 2000, SQL Server 7.0, Oracle8i, Oracle9i, and the like. The storage database 11 reads the whole backup stored in the storage medium 10 and performs the whole backup (write) in the database.

  Further, the storage database 11 holds the entire backup data (data content stored on the disk) in a written-out database image file 23 so as to be developed. Each time the transaction data 6 is transferred via the network 7, the corresponding transaction (difference) processing is performed on the copy data 23a of the database image file 23, and then the validity is verified. The data after the transaction application processing determined to be is re-stored in the corresponding storage database 11.

  FIG. 2 is a block diagram for explaining a storage function of the storage database 11. The storage database 11 includes storage means 20 for storing storage data, and data processing means 21 for executing the above-described transaction application processing.

  The storage unit 20 stores and retains the data of the entire backup, and is read out by the reading unit 22 every time a transaction occurs to generate a database image file 23. The transaction reflection unit 24 executes a transaction application process using the transaction data 6 input to the database image file 23.

  The transaction application process is, for example, a process of updating (writing) a record in the database image file 23. For this reason, if the transaction data 6 itself is retained without performing the transaction application processing, the data amount increases with time. On the other hand, since there are many update processes for the records of the whole backup (database image file 23) every time the transaction application process is performed, the data capacity of the database image file 23 hardly changes, and the transaction data 6 is stored. You don't have to.

  The verification unit 25 verifies whether the transaction application processing has been performed normally, and permits execution of the transaction application processing only when the transaction application processing is normal. For example, if the transaction data 6 is a process that does not correspond to the corresponding full backup (database image file 23) (cannot be erroneously applied), execution of the transaction application process is not permitted, and the corresponding alarm (warning) is made into a data list. Notify by doing.

  When it is determined that the verification result by the verification unit 25 is normal, the writing unit 26 converts the whole backup data (database image file 23) subjected to the transaction application processing into a format that can be stored in the storage unit 20 and re-stores the data. I do.

  Further, the backup unit 27 backs up the entire backup data before the transaction application processing and the input transaction data 6 to the backup storage unit 28, respectively.

  The data (entire backup data) stored in the storage means 20 can be compressed. In this case, the reading unit 22 expands the read compressed data, and the writing unit 26 compresses the data to be written. Further, a configuration in which data compression is applied to the backup data with respect to the backup storage unit 28 is also possible.

  Next, a processing procedure of the entire system will be described. Before executing the transaction application processing, the whole backup data is transported to the storage center 2 as preprocessing. As shown in FIG. 1, first, (1) the entire backup of the server 1 is stored in the storage medium 10, and (2) it is transported to the storage center 2. Thereafter, (3) the contents of the storage medium 10 are read in the storage center 2 and stored in the database of the storage database 11 corresponding to the server 1 (whole restoration). Incidentally, there is a case where a certain part is backed up as a single unit in (1) and a single unit is restored in (3).

  After this, the system is ready for transaction application processing. FIG. 3 is a flowchart illustrating a transaction application processing procedure. Hereinafter, an example will be described in which one transaction data 6, which is the minimum unit, is generated and is subjected to transaction application processing. Hereinafter, the processing corresponding to the number in parentheses is described in FIG.

  When the transaction data 6 occurs in the server 1 of the user (step S1), the server 1 transfers (4) the transaction data 6 to the storage center 2 (step S2). The storage center 2 reads (5) the entire backup data stored in the storage database 11 corresponding to the server 1 and develops (generates) it into the database image file 23 (step S3).

  Then, (6) a transaction reflection process (step S4) is performed on the copy data 23a of the database image file 23. The transaction reflection unit 24 illustrated in FIG. 2 performs, for example, a process of determining whether the update process of the number of database image files 23 that is the latest whole backup and the number of updates indicated by the transaction data 6 can be applied as the transaction application process. I do.

  Thereafter, the verification unit 25 performs data verification on whether the transaction application processing was performed normally (step S5). If the verification result indicates that the processing is normal (step S6: Yes), the database image file 23 (copy) after the transaction application processing is performed. The data 23a) is converted into a format that can be stored in the corresponding storage database 11 (the storage unit 20 shown in FIG. 2) and stored again (step S7). Thereafter, the process returns to step S1 and waits for input of new transaction data 6.

  On the other hand, if the verification result indicates that the processing is not normal (step S6: No), the application of the transaction application processing of step S4 is not performed (step S8), an alarm is output (step S9), and the process returns to step S1.

  Next, FIG. 4 is a flowchart showing the procedure of the restore processing of the whole backup. If the user's server 1 is damaged due to a disaster or the like and needs to be restored, the storage center 2 reads the entire backup from the storage means 20 of the storage database 11 corresponding to the server 1 and (7) the storage medium 10 (Step S11). At this time, the entire backup data can be easily retrieved simply by using the restore command for the storage database 11.

  Thereafter, (8) the storage medium 10 is transported from the storage center 2 to the server 1 of the user (step S12). Then, (9) the entire backup data stored in the storage medium 10 is restored to the server 1 (Step S13). The whole backup data stored in the storage medium 10 is in a state where the transaction application processing up to immediately before has been executed. As a result, the business database 5 of the server 1 can be quickly restored, and the business can be resumed in a short time. It is needless to say that the transfer steps (2) and (8) using the storage medium 10 described above are not limited to transfer, and may be configured to transfer using a network such as a high-speed line.

  As described above, according to the data backup system according to the first embodiment, since the storage center 2 is configured to execute the transaction application processing on the entire backup data every time a transaction occurs, the storage center 2 The content of the database 11 can always be kept up to date. Further, it is not necessary to store the transaction data 6, and the amount of data to be stored without the transaction data 6 being accumulated can be minimized. As a result, the user's server 1 can be promptly restored when the server 1 is damaged due to a disaster or the data contents are damaged. The recovery operation itself can be performed simply and quickly by simply reading out the contents of the storage database 11 of the storage center 2 and transporting it using the storage medium 10, and restoring the data on the server 1 side.

  By the way, in the above-described first embodiment, a configuration example in which the server 1 and the storage center 2 are arranged one by one has been described for convenience of description. Actually, one storage center 2 has various storage databases 11 corresponding to the plurality of servers 1, and can execute the transaction application processing in response to accesses from the plurality of servers 1 at the same time.

(Embodiment 2)
In the first embodiment, an example of a configuration in which the server 1 and the storage center 2 are arranged one by one has been described. An example will be described as a second embodiment. FIG. 5 is a schematic diagram showing an example of a configuration of a data backup system corresponding to a plurality of servers according to the present invention. In FIG. 5, a plurality of servers 1a to 1c to be backed up are installed. A storage center 2 is provided at a remote location at a predetermined distance from the installation location of these servers 1a to 1c. The server includes a server 51 and storage areas 52a to 52c.

  As in FIG. 1, each of the servers 1a to 1c has a daily business database 5, which is referred to at the time of business progress and generates transaction data 6 as the business progresses. The transaction data 6 generated each time the work progresses is transferred to the storage center 2 via the network 7.

  For example, transaction data 6 generated in the database 5 of the server 1a is stored in the buffer 50a in the storage center 2 via the network 7. Since the stored transaction data 6 is used for the transaction application processing, the stored transaction data 6 is sent to the TR application server 51 in order from the previously stored transaction data 6.

  The TR application server 51 that has received the transaction data 6 reads the copy data 23a of the database image file 23 from the storage area 52a corresponding to the server 1a and performs the transaction application processing. When all the transaction application processing of the transaction data 6 stored in the buffer 50a is completed, the copy data 23a is stored again in the storage area 52a by the TR application server 51.

  Similarly, the transaction data 6 transferred from the server 1b is stored in the buffer 50b and is applied to the database image file 23 generated from the storage area 52b. Further, the transaction data 6 transferred from the server 1c is stored in the buffer 50c and is applied to the database image file 23 generated from the storage area 52c.

  The processing for each of the servers 1a to 1c performed when a transaction is applied is as described above. However, in many cases, a plurality of transaction data 6 transferred from the servers 1a to 1c are stored in the buffers 50a to 50c at the same time as shown in FIG. In this case, the transaction application processing may be performed by the TR application server 51 from the previously stored transaction data 6 irrespective of which server is used, or the processing order or priority of the servers 1a to 1c may be determined. The transaction application processing may be arbitrarily determined.

  Furthermore, the above-described transaction application processing may be performed when at least one transaction data 6 is stored in any of the buffers 50a to 50c, or the transaction data 6 may be arbitrarily determined in the buffers 50a to 50c. Alternatively, the processing may be performed when only the information is stored.

  For example, when one server 1a is normally backed up, one backup server having the functions of the TR application server 51 and the storage area 52a is required. For this reason, if a plurality of servers are to be backed up, the number of backup servers is required, and costs such as licensing costs are required. However, in the example shown in FIG. 5 described above, when backing up a plurality of servers, only one backup server is required, so that license costs can be reduced and equipment can be made more efficient.

  When the transaction data 6 is transferred to the storage center 2 via the network 7, the servers 1a to 1c compress the data, and the storage center 2 expands the compressed and transferred data as shown in FIG. The same shall apply.

  FIG. 6 is a flowchart showing a transaction application processing procedure of the data backup system corresponding to a plurality of servers according to the present invention. In FIG. 6, the operation of the data backup system corresponding to a plurality of servers shown in FIG. 5 will be described using a flowchart.

  First, as preparation for performing a backup process, an overall backup is performed from the server 1a to the storage area 52a provided in the storage center 2 via the network 7 (step S21). Similarly, a full backup is performed from the server 1b to the storage area 52b (step S22), and a full backup is performed from the server 1c to the storage area 52c (step S23).

  Then, the transaction data 6 is transferred from the server 1a to the buffer 50a provided in the storage center 2 (Step S24). When the transaction data 6 is transferred, the database image file 23 is generated from the storage area 52a (Step S25) and sent to the TR application server 51. Thereafter, the buffer 50a sends the transaction data 6 to the TR application server 51 (Step S26). The TR application server 51 performs a transaction application process on the sent transaction data 6 on the copy data 23a of the database image file 23, and stores the transaction data 6 in the storage area 52a again (step S27).

  Next, the transaction data 6 is transferred from the server 1b to the buffer 50b provided in the storage center 2 (Step S28). When the transaction data 6 is transferred, the database image file 23 is generated from the storage area 52b (Step S29) and sent to the TR application server 51. Thereafter, the buffer 50b sends the transaction data 6 to the TR application server 51 (Step S30). The TR application server 51 performs a transaction application process on the transmitted transaction data 6 on the copy data 23a of the database image file 23, and stores the transaction data 6 again in the storage area 52b (step S31).

  Further, the transaction data 6 is transferred from the server 1c to the buffer 50c provided in the storage center 2 (Step S32). When the transaction data 6 is transferred, the database image file 23 is generated from the storage area 52c (Step S33) and sent to the TR application server 51. Thereafter, the buffer 50c sends the transaction data 6 to the TR application server 51 (Step S34). The TR application server 51 performs a transaction application process on the sent transaction data 6 to the copy data 23a of the database image file 23, and stores the transaction data 6 again in the storage area 52c (step S35).

  On the other hand, a failure may occur in the servers 1a to 1c while performing the transaction application processing as described above. For example, when a failure occurs in the server 1a (step S36), the entire backup is recovered from the storage area 52a via the network 7 to the server 1a (step S37). Since the whole backup for performing this recovery is the backup data after applying the transaction up to immediately before, the latest whole backup data can be restored.

  As described above, according to the data backup system according to the second embodiment, the servers 1a to 1c can back up the storage areas 52a to 52c provided in the storage center 2 and assigned to the respective servers. Become like All of these transaction processes can be executed by one TR application server 51. As a result, there is no need to prepare a backup server for each database, and the efficiency of backup facilities can be increased, and licensing costs can be reduced.

  Further, since transaction data generated in the servers 1a to 1c is stored in the buffers 50a to 50c and the transaction application processing is sequentially performed in the TR application server 51, the transaction application processing of a plurality of servers can be multiplexed. Become like Further, since the transaction is always applied, even in the event of a failure, recovery can be performed using the entire backup to which the transaction up to immediately before has been applied. This makes it possible to restore to the latest data when recovery is performed.

  In FIG. 5 and FIG. 6, the number of backup servers is three, that is, the servers 1 a to 1 c, but the number is not particularly limited. There is no upper limit on the number unless there are restrictions on the functions of the devices that make up the system, hardware standards, operating systems, and the like. In this case, it is assumed that storage areas corresponding to the respective servers are prepared in the storage center 2.

  The data backup method described in the present embodiment is realized by executing a prepared program on a computer such as a personal computer or a workstation constituting the storage database 11 of the server 1 or the storage center 2. be able to. This program is recorded on a computer-readable recording medium such as a hard disk, a flexible disk, a CD-ROM, an MO, and a DVD, and is executed by being read from the recording medium by the computer. The program may be a transmission medium that can be distributed via a network such as the Internet.

  As described above, the data backup system and data backup method according to the present invention are useful for performing database backup and transaction processing, and are particularly suitable for database recovery in the event of a disaster or the like.

1 is a schematic diagram illustrating a configuration of a data backup system according to the present invention. FIG. 3 is a block diagram for explaining a storage function of a storage database. It is a flowchart which shows a transaction application processing procedure. 9 is a flowchart illustrating a procedure for restoring an entire backup. 1 is a schematic diagram illustrating an example of a configuration of a data backup system corresponding to a plurality of servers according to the present invention. It is a flow chart which shows the transaction application processing procedure of the data backup system corresponding to a plurality of servers concerning the present invention. It is a schematic diagram showing a configuration of a conventional data backup system.

Explanation of reference numerals

1, 1a, 1b, 1c server 2 storage center 5 business database 6 transaction data 7 network 10 storage medium 11 storage database 20 storage means 21 data processing means 22 reading means 23 database image file 23a database image file copy data 24 transaction reflection Means 25 Verification means 26 Writing means 27 Backup means 28 Backup storage means 50a, 50b, 50c Buffer 51 TR application server 52a, 52b, 52c Storage area

Claims (14)

In a data backup system comprising a server having a database and a remote storage center for backing up data contents of the database of the server,
The server includes a transfer unit that transfers the transaction data to the storage center every time transaction data is generated,
A storage unit configured to store overall backup data obtained by backing up the database of the server;
Data processing for executing a transaction application process using the transaction data on the whole backup corresponding to the server each time receiving transaction data from the server, and re-storing the whole backup data after the transaction application process in the storage unit Means,
A data backup system comprising: In a data backup system including n servers each having a database and a remote storage center for backing up data contents of the database for each of the n servers,
The n servers each include transfer means for transferring the transaction data to the storage center each time the transaction data occurs,
A storage unit for storing the entire backup data obtained by backing up the database provided for each of the n servers in a corresponding area from among the n areas respectively allocated to the n servers; and ,
Each time receiving transaction data from the n servers, executing a transaction application process using the transaction data on the entire backup stored in the n areas allocated to each of the n servers; Data processing means for restoring the whole backup data after the transaction application processing in the n areas respectively allocated to the n servers;
A data backup system comprising: Each time the transfer means receives the transaction data transferred from each of the n servers, the transaction data is temporarily stored in the corresponding storage area from among the n storage areas assigned to each of the n servers. Storage means for storing the
The data processing means includes:
Acquiring the transaction data stored in the storage area of the storage means assigned to each of the n servers, and obtaining each of the whole backups stored in the area assigned to each of the n servers A transaction application process using the transaction data with respect to the entire backup data after the transaction application process from among the n areas of the storage unit assigned to each of the n servers. 3. The data backup system according to claim 2, wherein the data is re-stored in an area to be restored. The data processing means includes:
The data backup according to claim 1, further comprising a verification unit configured to verify whether execution of the transaction application processing is appropriate, and not performing the transaction application processing when the execution is not appropriate. system. The verification means,
5. The data backup system according to claim 4, wherein when the execution of the transaction application processing is not appropriate, a corresponding error content is notified. The data processing means includes:
6. The transaction application process according to claim 1, wherein the whole backup data read from the storage unit is expanded into a database image file and executed for a copy of the database image file. Data backup system.   7. The data backup system according to claim 1, further comprising a writing unit that compresses and stores the entire backup data after the transaction application processing in the storage unit.   8. The data backup system according to claim 7, further comprising a reading unit that expands and reads out the entire backup data in a data compressed state stored in the storage unit during the transaction application processing.   9. The data backup system according to claim 1, further comprising a network for transferring data between the server and the storage center.   The data backup system according to any one of claims 1 to 9, wherein a writable and readable storage medium is used to transfer data between the server and the storage center. In a data backup method for transferring data contents of a database to a remote location for backup,
A data backup method, comprising: a transaction reflection processing step of executing a transaction application process using the transaction data on the entire backup data of the database that has been backed up in advance each time transaction data is received from the database. . Including a verification step of verifying whether the execution of the transaction reflection processing step is appropriate,
12. The data backup method according to claim 11, wherein the transaction application processing is not executed when the verification result is not appropriate. The transaction reflection processing step includes:
When the number of the databases is n, one transaction data received from the n databases is applied to the corresponding whole backup data of one of the n previously backed up databases by the transaction application. 13. The data backup method according to claim 11, wherein a process is executed. The transaction reflection processing step includes:
When transaction data is received from one of the n databases, the transaction data is temporarily stored, and the stored transaction data is stored in one of the n databases that have been backed up in advance. 14. The data backup method according to claim 13, wherein the transaction application processing is performed on two corresponding whole backup data.

Images