JP2005018463A - Simple backup system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To make it possible to continue the business of an office by installing a simple system for preparing a backup database by base data and updating data transferred from a backup computer, and at the time of an emergency state, retrieving and updating the backup database from a personal computer. <P>SOLUTION: The backup computer 20 is provided with a base data file 22 for storing retreat data, a transaction data file 23 for storing update data, a storage data file 24 for storing journal data and control data, a backup database 26 for substituting a database 12 of an operational computer 10, and a personal computer 3 for retrieving and updating the backup database 26. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a backup system for an operational computer composed of a database and an online terminal, such as a banking system, and in particular, when the operational computer cannot be recovered for a long time due to a disaster or the like, the backup database is searched and updated by a browser of a personal computer, The present invention relates to a simple backup system that supports sales office operations.
[0002]
[Prior art]
In a banking system, there is a system in which control information and inquiry data of a sales office server are also held in a center server, and the sales office server is backed up by the center server in the event of a failure. This backup system can be switched quickly by substituting the store server for the center server, but since the control information and inquiry data of the store server are also kept in the center, a large backup system should be provided in the center. become. In addition, if the server of the branch office fails in a situation where the communication line between the branch office and the center is disconnected for a long time, the center server cannot back up the branch office (for example, Patent Document 1).
[0003]
Furthermore, if a failure occurs in the client application, there is a situation where the database on the center side cannot be used. In this case, the system cannot be used until the application is restored, and it often takes a long time. In order to prepare for such a situation, a backup database that converts and stores the database into an HTML format that can be referred to from a browser is provided separately so that the database can always be referenced. refer. As described above, there is an example of a backup system that makes it possible to use at least a backup database reference function by a browser of a personal computer. This is an example of a medical system, but it is an example of avoiding inoperability of business by securing a function of referring to a database (for example, Patent Document 2).
[0004]
[Patent Document 1]
JP 2000-82040 (FIG. 5 and paragraph 0021)
[Patent Document 2]
JP 11-134228 A (FIGS. 1 and 0027)
[0005]
[Problems to be solved by the invention]
Conventionally, a backup system for a banking system installs the same equipment as the operation computer in a remote place and tries to perform the same processing as the operation computer, but such a backup computer itself is large-scale. And it is expensive. Further, there is a problem that maintenance and the like are required in the same manner as for the operation computer.
[0006]
In addition, when the operation computer is damaged and switched to the backup computer for operation, it is necessary to send personnel to the remote backup computer for operation, and even if the configuration of the operation computer changes, backup Since changes to the computer must also be made, there is a problem that requires a large amount of money to operate.
[0007]
Banking systems are usually large-scale systems in which servers are installed in sales offices, while there are small-scale systems in which sales offices have only online terminals and a centralized database. With such a system, when a social infrastructure failure occurs due to a disaster such as an earthquake, and it is impossible to connect to the center system for a long time, it can be connected from a normal telephone line, and it is cheap and completely unmanned. Therefore, a simple backup system that can be accessed from a browser of a personal computer is desired.
[0008]
This simple backup system includes a backup database in which data in an operation computer and an update processing image for the data are sent to a backup computer as needed. If the connection with the center computer is lost and recovery is impossible in a short time, the backup database can be searched and updated from the browser of the personal computer at the branch office to continue limited operations such as passbook processing. It relates to a simple backup system.
[0009]
With such a backup system, the sales office can refer to the account balance of the customer necessary for the passbook processing. Further, the account balance obtained by partially extracting the backup database for each store is transferred to a personal computer and stored in a portable storage medium. The storage medium is loaded into a personal computer that cannot be connected to the backup computer, and the account is offline. Refers to the balance and supports operations such as passbook processing.
[0010]
An object of the present invention is to configure a backup computer with a simple device such as a database server and to create a backup database from base data and update data.
[0011]
In addition, in the event of a disaster, the other purpose is to search and update the backup database from a personal computer, obtain customer data such as account balance, and continue the operations of the branch office where the online terminal was disconnected. Is to make it possible.
[0012]
Furthermore, another object is to store customer data such as account balance in a storage medium that can be carried by using a personal computer that can be connected from a backup database when the personal computer cannot be connected to the backup computer in an emergency, and can be stored in an offline personal computer. It is to load the storage medium and provide account balance information to support the passbook processing.
[0013]
[Means for Solving the Problems]
Therefore, in the system of the present invention, in response to a processing request from an online terminal, a system having an operation computer that searches and updates a database and returns a processing result to the online terminal, and a backup computer that backs up the operation computer. The backup computer includes a data transmission / reception processing unit that sends and receives file transfers from the operation computer, a base data file that stores base data that is saved data created at a quiesce point of the database, and update data of the database A transaction data file that receives and stores certain transaction data in real time, a storage data file that stores journal data and control data of the operation computer, and data of the operation computer A backup database that replaces the base, a backup database is created using the base data, the backup database is updated with the transaction data, and the database creation processing unit that matches the database, and the operation computer cannot operate A data search / update processing unit for connecting a personal computer having a browser for searching / updating the backup database, a screen data file for storing screen data used for search / update by the personal computer, and a backup database updated by the personal computer An update data file for storing the update data for recovery of the database.
[0014]
The backup computer further includes a partial extraction processing unit that creates a partial backup database that is partially extracted for the store from the backup database and sends the partial backup database to the personal computer through a communication line.
[0015]
Further, the personal computer includes an external storage device loaded with a portable storage medium, and stores the partial backup database in the storage medium.
[0016]
The personal computer further includes an external storage device, and when the communication line is disconnected, the portable storage medium storing the partial backup database is loaded into the external storage device, and the partial backup database is searched and updated. And, it is characterized by supporting sales office operations.
[0017]
Furthermore, the partial backup database is a file obtained by extracting customer data including account balance information for a predetermined store.
[0018]
Further, the backup computer is a database server that can be searched and updated from a web browser.
[0019]
DETAILED DESCRIPTION OF THE INVENTION
The present invention will be described with reference to the drawings. Referring to FIG. 1 showing an embodiment of the present invention, this embodiment includes an online terminal 1 of a sales office, an operation computer 10 installed in a center, and a backup computer 20 that backs up the operation computer 10 in an emergency. A data transmission / reception processing unit 13 for connecting the backup computer 20, a data transmission / reception processing unit 21 for connecting the operation computer 10 in the backup computer 20, a communication line 14, a communication line 15 for connecting the data transmission / reception processing units 13, 21; Communication line 16. The operation computer 10 and the backup computer 20 can be installed with any one of a general-purpose machine, UNIX (registered trademark), Windows (registered trademark), LINUX (registered trademark), and the like.
[0020]
The operation computer 10 includes an online processing unit 11 that processes input data from the online terminal 1 and a database 12 that files customer data updated by the input data. The online terminal 1 has a function of transmitting input data necessary for online processing to the operation computer 10 and receiving a result from the operation computer 10.
[0021]
The backup computer 20 includes a base data file 22 that is saved data of the database 12, a transaction data file 23 that is update data of the database 12, a storage data file 24 that stores the operating state of the operation computer 10, and the backup computer 20. A backup database 26 provided, a database creation processing unit 25 for creating / updating the backup database 26 using base data and transaction data, and a data search / updating processing unit 27 for retrieving / updating the backup database 26 from a personal computer at a branch office The update data 28 for the backup database 26 and the customer data of a predetermined store are stored in the backup database in the off-line personal computer 5. 26, a partial extraction processing unit 29 that creates a partial database from 26, update data 28 that stores the results of updating the backup database 26 from the personal computer 3, and search / update information that is sent to the browser of the personal computer connected to the backup computer 20 Screen data 30 for storing an operation screen.
[0022]
Referring to FIG. 2A showing the storage format of the base data, the base data storage format includes a header part 201, an item M part 202, a data part 203, and a command part 204. If the database creation processing unit 25 is not started immediately after the base data transfer, the command of the command unit 204 is not required.
[0023]
As for the format of the header part 201, referring to FIG. 2B, a keyword “header” 210 for recognizing the header part 201, “base” 211 as base data, and a file name 212 for storing the base data, The table name 213 to be created in the backup database 26, the creation instruction 214 for instructing the table data creation method for initial load or additional load, the character code 215 of the transferred data, and the character code conversion are designated. A conversion instruction 216.
[0024]
As for the format of the item portion 202, referring to FIG. 2C, the keyword “item” 220 for recognizing the item portion 202, the serial number 221 in the item portion 202, the item name of the table item, the presence / absence of a key, An item attribute 222 including length, attribute, and accuracy, and an input data attribute 223 including data position, length, attribute, and accuracy on the base data corresponding to the item attribute 222 are configured.
[0025]
As shown in FIG. 2D, the format of the data portion 203 is composed of a keyword “data” 230 for recognizing the data portion 203, a serial number 231 in the data portion 203, and a data value 232. .
[0026]
Referring to FIG. 2 (e), the command unit 204 includes a keyword “command” 240 for recognizing the command unit 204, “base” 241 that is base data, and a file name 242 that stores base data. It is configured.
[0027]
With these pieces of information, the table creation of the backup database 26 and the data loading method can be determined from the base data, and actual creation can be performed according to the instructions. A plurality of base data files 22 can be provided, and a plurality of tables can be generated and data loaded.
[0028]
Referring to FIG. 3A showing the transaction storage format, the transaction data storage format is composed of a header section 301, an item section 302, a command section 303, and a data section 304. If the database creation processing unit 25 is not started immediately after transfer, the command of the command unit 303 is not required.
[0029]
Referring to FIG. 3B, the header section 301 includes a keyword “header” 310 for recognizing the header section 301, “transaction” 311 as transaction data, a file name 312 for storing transaction data, and a database. 26, a table name 313 to be updated, a creation instruction 314 for instructing whether to update in real time or batch update, a character code 315 for the transferred data, and a conversion instruction for specifying character code conversion 316.
[0030]
Referring to FIG. 3C, the item portion 302 has a keyword “item” 320 for recognizing the item portion 302, a serial number 321 in the item portion 302, an item name of the table item, the presence / absence of a key, and a length. , And an item attribute 322 including the attribute and accuracy, and an input data attribute 323 including the data position, length, attribute, and accuracy of transaction data corresponding to the item attribute 322.
[0031]
Referring to FIG. 3D, the command unit 303 includes a keyword “command” 330 for recognizing the command unit 303, transaction data “transaction” 331, and a file name 332 for storing transaction data. It is configured.
[0032]
Referring to FIG. 3 (e), the data part 304 includes a keyword “data” 340 for recognizing the data part 304, a serial number 341 in the data part, and a data value 342.
[0033]
With this information, the update method of the table data in the database 26 can be determined from the transaction data, and an actual update instruction can be issued. A plurality of transaction data files 23 can be provided, and a plurality of tables in the backup database 26 can be updated.
[0034]
Next, the operation of this embodiment will be described in detail with reference to FIGS. 4, 5, 6, 7, and 8. FIG. Referring to FIG. 4 showing the generation and transfer of base data, the operational computer 10 generates a header part 201 (step 401), generates an item part 202 (step 402), generates a data part 203, and is necessary. For example, the command unit 204 is generated (step 403). If all the base data has been created, a file of base data is transmitted from the operation computer 10 (step 404), received by the backup computer 20, and stored in the base data file 22 (step 405).
[0035]
If the command unit 204 is present, the database creation processing unit 25 is activated (step 406). If the creation instruction is initial load, if the corresponding table exists in the database 26, the table is recreated (step 407). All data is deleted (step 408). Thereafter, the base data is added to the table (step 409).
[0036]
Referring to FIG. 5 showing generation and transfer of transaction data, a header portion 301 is generated (step 501), an item portion 302 is generated (step 502), a command portion 303 is generated if necessary, and a data portion 304 is It is generated (step 503), the transaction data file is transmitted from the operation computer 10 (step 504), received by the backup computer 20, and stored in the transaction data file 23 (step 505).
[0037]
If the command unit 303 exists, the database creation processing unit 25 is activated (step 506), and thereafter, every time transaction data is received, data addition / update processing is performed (step 510). In the operation computer 10, the online processing unit 11 is activated in response to a request from the online terminal 1 (step 507). When there is an update, the transaction data is transmitted (step 508) and received by the backup computer 20 (step 509). If the database creation processing unit 25 has been activated, the database creation processing unit 25 is requested to perform transaction data addition update processing (step 510). The transaction data file 23 is stored in the transaction data both when there is an additional update process and when there is no additional update process (step 511). If there is no command unit 303, the same operation as described above is performed on the transaction data file 23 when a command is given.
[0038]
When the operation computer 10 becomes unable to connect to an online terminal due to a disaster or the like, the personal computer 3 in a sales office or the like is connected to the backup computer 20 to access the backup database 26 to perform search update. The operation will be described with reference to FIG.
[0039]
When the personal computer 3 is connected to the backup computer 20 via the telephone line 4 or the like, and the search / update processing for the backup database 26 is performed through the data search / update processing unit 27, the personal computer 3 is connected to the backup computer 20 (step 701). The backup database 26 is searched and updated through the data search / update processing unit 27 (step 702). At this time, if data update occurs, an update image is output to the update data file 28 (step 703). When the personal computer 3 can be connected to the backup computer 20, the personal computer 3 is loaded with the external storage medium 6 in order to supply the partial extraction data to the offline personal computer 5 (step 704). The partial backup database is searched and updated using the external storage medium storing the partial extraction data of the backup database 26 (step 705). At this time, if data update occurs, the update image is output to the update data file 7 of the personal computer 5 (step 706).
[0040]
An operation for switching back the data updated by the backup computer 20 when the operation computer 10 is restored will be described. If there is a personal computer 5 operating offline, the update data exists in the local update data file 7, and if it is still impossible to connect to the backup computer at this time, the storage medium 6 that can carry the update data file 7 or the like (Step 803), brought into the personal computer 3 connectable to the backup computer 20 (step 804), connected to the backup computer 20 (step 801), and the update data file 7 via the storage medium 6 to the backup computer 20 (step 802). When the update data file 7 is collected in the update data file 28 of the backup computer 20, the transaction data of the update data file 28 is transferred to the operation computer 10 (step 805) and reflected in the database 12 of the operation computer 10 (step 806). . The update data file 28 is transferred to the operation computer 10 (step 807) and reflected in the database 12 of the operation computer 10 (step 808).
[0041]
In this description, the transfer and reflection of transaction data and update data are described. However, all files 22, 23, 24, and 26 existing in the backup computer 20 can be transferred to the operation computer 10.
[0042]
Next, in this embodiment, when the operation computer 10 cannot be recovered due to a disaster or the like, the personal computer 3 in the sales office or the like is connected to the backup computer 20, and the backup database 26 is accessed. An operation in the case of obtaining the extracted data and supporting the bankbook processing of the sales office using the off-line personal computer 5 will be described. As already described with reference to FIG. 7, the partial extraction processing unit 29 is started from the personal computer 3 connectable to the backup computer 20 and the minimum data necessary for continuation of business is acquired. In this case, even when the personal computer 5 is offline, the backup database 26 can be searched and updated to check the account balance that supports the passbook processing.
[0043]
Referring to FIG. 6 showing the operation of the partial extraction processing unit for extracting the customer data of the branch office from the backup database 26, the partial extraction processing is connected from the personal computer 3 to the backup computer 20 (step 601), and the partial extraction command (Step 602), the backup computer 20 receives the partial extraction command (step 603), activates the partial extraction processing unit 29 to extract data (step 604), and extracts the extracted data to the personal computer 3 (Step 605). The personal computer 3 writes the transferred partial extraction data into the external storage medium 6 (step 606), loads it into the offline personal computer 5 and brings it in, so that the offline personal computer 5 also refers to the backup database 26 to perform the business. You can continue. The update data for the storage medium 6 being taken up by the backup computer 20 and reflected in the operation computer 10 is described with reference to FIG.
[0044]
【The invention's effect】
The first effect of the present invention is that the table creation, data load, data update, and data reference operations on the backup computer can all be performed by an instruction from the operation computer or personal computer, so that the operation can be completely unmanned. . This is because the backup computer can be operated by a command attached to the base data and transaction data using a simple device such as a database server for the backup computer.
[0045]
Furthermore, the second effect is that even when the database configuration of the operation computer is changed, the backup database of the backup computer is automatically changed by changing the data content transmitted from the operation computer. No special reconstruction process is required. The reason is that the backup database is created by the designation included in the base data and transaction data.
[0046]
The third effect is that when the configuration change of data or table occurs in the operation computer, it is only necessary to correct the program on the operation computer side, and no correction on the backup computer side is necessary, so that program maintenance is easy.
The reason is that the backup computer can create a backup database according to the base data transferred from the operation computer and the designation included in the transaction.
[0047]
Furthermore, the fourth effect is that the backup data can be referred to / updated with a general WWW browser, so that a personal computer which is usually used for other business can be used for backup.
This is because the backup database can be searched and updated by the browser, and the screen data is provided in the backup computer and can be downloaded.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration of an embodiment of the present invention.
FIG. 2 is a diagram illustrating a storage format and configuration of base data.
FIG. 3 is a diagram illustrating a storage format and configuration of a transaction.
FIG. 4 is a diagram illustrating an operation of creating a database by transmitting base data from an operation computer to a backup computer.
FIG. 5 is a diagram illustrating an operation of transmitting transaction data from an operation computer and an online terminal to update a database.
FIG. 6 is a diagram illustrating an operation of generating and transmitting partial extraction data of a backup database for an off-line personal computer.
FIG. 7 is a diagram illustrating an operation of outputting update data of a personal computer connected to a backup computer and an off-line personal computer.
FIG. 8 is a diagram illustrating an operation of reflecting update data of a backup computer in a database of an operation computer.
[Explanation of symbols]
1 Online terminal
3 Personal computer
4 telephone lines
5 Personal computer
6 storage media
7 Update data file
10 Operation computer
11 Online processing department
12 Database
13 Data transmission / reception processor
14 Communication line
15 Communication line
16 Communication line
21 Data transmission / reception processor
22 Base data file
23 Transaction data file
24 Storage data file
25 Database creation processing section
26 Backup database
27 Data search / update processor
28 Update data file
29 Partial extraction processing unit
30 screen data

Claims (6)

In response to a processing request from an online terminal, in a system having an operation computer that searches and updates a database and returns a processing result to the online terminal, and a backup computer that backs up the operation computer,
The backup computer is
A data transmission / reception processing unit for sending and receiving file transfers from the operational computer;
A base data file that stores base data that is saved data created at a quiesce point of the database;
A transaction data file for receiving and storing transaction data as update data of the database in real time;
A storage data file for storing journal data and control data of the operation computer;
A backup database replacing the database of the operational computer;
Creating a backup database using the base data, updating the backup database with the transaction data, and making the database consistent with the database; and
When the operation computer cannot be operated, a data search update processing unit for connecting a personal computer including a browser for searching and updating the backup database;
A screen data file for storing screen data used by the personal computer for search update;
An update data file for storing update data of a backup database updated by the personal computer for recovery of the database;
A simple backup system characterized by comprising: The backup computer is
The simple backup system according to claim 1, further comprising a partial extraction processing unit that creates a partial backup database partially extracted for a sales store from the backup database and sends the partial backup database to the personal computer through a communication line. The personal computer is
3. The simple backup system according to claim 2, further comprising an external storage device loaded with a portable storage medium, wherein the partial backup database is stored in the storage medium. The personal computer is
With external storage,
When the communication line is disconnected, the portable storage medium storing the partial backup database is loaded into the external storage device, and the partial backup database is searched and updated to support a branch office operation. The simple backup system according to claim 2. The partial backup database is
3. The simple backup system according to claim 2, wherein the file is a file obtained by extracting customer data including account balance information for a predetermined store. The backup computer is
The simple backup system according to claim 1, wherein the database server is a database server that can be searched and updated from a web browser.

Images