JP3572928B2 - Online database information processing system with backup function - Google Patents

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an online database information processing system, and more particularly, to a backup function of a social system such as a financial system or a medical system in which interruption of service has a great social impact.
[0002]
[Prior art]
In a so-called social system, which has online data terminals in social life places such as banks and hospitals and provides services to citizens through a large-scale online database information processing system, unexpected interruption of services not only has a great impact, There is a constant demand for improved services by extending service hours. Therefore, in order to quickly recover from an unexpected failure of the operating system or service interruption in the event of a disaster, these systems have a system that is in a standby state and can be switched to this system. Hereinafter, a system mainly used for operation will be referred to as a main system, and a system which is always on standby for backup will be referred to as a sub system. When the main system stops operating due to a failure, the operation is switched to the sub system. In addition to this, maintenance and inspection of system equipment is also important, and it is an important role of the sub-system to suspend the main system for a certain period according to schedule and switch to the sub-system during that time to continue service work.
[0003]
There are two methods of switching to such a sub system, a dual system and a duplex system. The dual system is a fully duplicated system in which the main system and the sub system are completely equal, and all the system components are duplicated, and both operate simultaneously at the same time. Therefore, transactions from online data terminals are similarly processed in the two systems simultaneously. On the other hand, the duplex system has a separate sub system that can be substituted for the main system. The online data terminal group is always connected to the main system, and when switching to the sub system, the connection of the online data terminal group is also switched to the sub system side.
[0004]
The dual system has the advantage that system switching is quick, but the mechanism for passing one transaction to the primary and secondary sides and the synchronization method are complicated, and a system that emphasizes response requires very expensive and high-performance equipment. Disadvantages. On the other hand, the duplex system has the advantage of maintaining the same response performance as the single system, but it requires time to reflect the status of the operating system at a certain point in the standby system, and prompt switching is required. It has disadvantages that cannot be achieved. For this reason, techniques for reducing the system switching time of the duplex system have been conventionally developed.
[0005]
For example, in JP-A-03-250257 and JP-A-09-259023, a record of database access during the online operation of the main system is recorded in the journal as an access log, and this is appropriately reflected in the sub system in hot standby. A technique is disclosed in which a secondary system catches up with a main system with a slight time delay. However, even in such a system, the switching time cannot be made zero. This is because the backup reflection processing with a low priority level is performed during the gap time between the online transaction processing with the highest priority level, and a reflection processing queue occurs. For this reason, current banking systems and the like generally require several tens of minutes of switching time.
[0006]
When switching the main system to the sub-system due to an unexpected accident such as a disaster, it is necessary to have time to take other human response systems, and the above switching time is acceptable, but for maintenance of equipment etc. In the case of switching from the main system to the sub-system according to the schedule, the online service cannot be stopped even for a short time. Therefore, at present, the main system is switched from the main system to the sub-system during the night when the service ends, and after the maintenance and inspection of the main system, the sub-system is switched back to the main system after the night-time service ends.
[0007]
[Problems to be solved by the invention]
As described above, in the conventional technology, the scheduled switching between the main system and the sub system of the online database information processing system with the backup function has to be performed after the nighttime service ends. However, in recent years, there has been an increasing demand for extending the nighttime service time, which is ideal for a 24-hour service, and an increase in the backlog of batch processing operations has made it possible to switch the system during the service time. An object of the present invention is to provide an online database information processing system with a backup function that solves such a problem.
[0008]
[Means for Solving the Problems]
In the online database information processing system with the backup function, the above-mentioned problem that scheduled switching between the main system and the sub-system cannot be performed without providing a service stop time, as shown in FIG.
Online database information processing for connecting a main system 1 having a first database DB1 and a sub system 2 having a second database DB2 and reflecting the contents of the first database DB1 in the database DB2 with a certain time delay (T) In the system,
An access key server 5 that can be written and referenced from both the main system 1 and the sub system 2,
A transaction processing unit 121 that records at least a key portion of the transaction content in the access key server 5;
A log reception reflection processing unit 222 that collates the content of the access request from the online data terminal group 4 with the content of the access key server 5 and performs a limited process for an access request having the same key;
The problem is solved by providing an online database information processing system with a backup function having the following.
[0009]
That is, in the example of a system switching time chart from the main system to the sub system shown in FIG. 2, the service by the main system 1 is switched at time t2, and thereafter becomes the service by the sub system 2, during which the service stop time Is not provided. To make this possible, switching preparation starts at time t1. In this sense, the time between the time t1 and the time t2 is referred to as a switching preparation period T12 in FIG. 2, but the online service is performed in the same manner as the normal service period. Here, the time t1 is selected such that the content DB1 (1) of the first database DB1 of the main system 1 at this point has been reflected in the second database DB2 of the sub system 2 at least before the scheduled switching time t2. Have been. In FIG. 2, this is expressed as content DB2 (2) = DB1 (1) at time t2 of the second database DB2 of the sub system 2.
[0010]
However, at time t2, the content DB1 (2) of the first database DB1 has already changed and does not remain as DB1 (1). Here, when DB1 (2) and DB1 (1) are compared, many records are unchanged, but part of the records are changed by the accesses (1) to (4) from the online data terminal group 4 during the switching preparation period T12. Records have been changed, that is, updated or added or deleted. Here, if the record changed by the transaction during the switch preparation period T12 is represented by C 1, and the record unchanged during the switch preparation period T12 is represented by R 1, DB1 (2) becomes the union of C 1 and R 2. In FIG. 2, this is expressed as DB1 (2) = C + R.
[0011]
The main system 1 resets the content AS (1) of the access key server 5 at the initial time t1 of the switching preparation period T12, and stores at least the key information for each subsequent transaction. The key information is information for determining which record on the first database DB1 has been changed, such as a business office number and a bank account number in a bank system, for example. In FIG. 2, this is represented by <C>, and the content AS (2) = <C> of the access key server 5 at time t2.
[0012]
The content DB2 (2) of the second database DB2 of the secondary system 2 at the time of switching at time t2 reflects only the content DB1 (1) of the first database DB1 at time t1, and the switching preparation period It is necessary to reflect the record C changed by the transaction during T12 in the second database DB2, but it takes until time t3. Therefore, the time from time t2 to time t3 is defined as a limited service period T23, and the subsystem 2 performs a limited process, for example, a transaction deterrent process on an access request to refer to a record included in C 1. This action determination can be made using the content AS (2) of the access key server 5.
[0013]
That is, in FIG. 2, the sub system 2 transmits the key information included in each of the access requests (5) to (7) from the online data terminal group 4 during the limited service period T23 to the contents AS (2) of the access key server 5. Then, it is compared with the key information <C> on C that the access request relates to to determine whether the relevant access request is related to C 2. If the transaction request is related to C 1, the transaction is suppressed. Otherwise, the transaction transaction is established with reference to R 2 included in the contents of DB2 (2). In this manner, the secondary system 2 does not stop the service even during the limited service period T23, and provides the limited online service with reference to the DB2 (2) of the second database DB2 and the AS (2) of the access key server 5. It can be carried out. Time t3 is a time when all transactions in the switching preparation period T12 and the limited service period T23 have been reflected in the second database DB2. The online service after the time t3 is returned to the normal service form by the sub system 2. In addition, when the main system 1 is subjected to maintenance and inspection and the switching is returned from the sub system 2 to the main system 1, the two systems may have the same functions so that the above description can be reversed.
[0014]
BEST MODE FOR CARRYING OUT THE INVENTION
An embodiment of an online database information processing system with a backup function will be described with reference to FIGS. Note that the computer processing in the present invention is executed on a main storage device of the computer by a computer program, and the provision form of the computer program includes an auxiliary storage device connected to the computer, a floppy disk and a CD-ROM. It is provided by being stored in a recording medium such as a portable storage device such as a ROM or a main storage device and an auxiliary storage device of another network-connected computer. It is loaded on a storage device and executed.
[0015]
An embodiment of the present invention will be described with reference to FIGS. FIG. 1 is a configuration example of an online database information processing system with a backup function. The online data terminal group 4 is switched to the main system 1 side by the switching control means 11 of the main system 1 and the sub system 2, and during the normal service period in which the main system 1 performs the online service, the online data terminal group 4 4 is transmitted to the first information processing means 12 of the main system 1.
[0016]
FIG. 3 shows an example of a configuration in which, of the functions of the first information processing means 12 and the second information processing means 22, only the part relating to the present invention is extracted. As shown, the first information processing unit 12 has a transaction processing unit 121 and a log output transmission processing unit 122. The transaction processing unit 121 is activated when a message arrives from the online data terminal group 4 during the normal service period and the switching preparation period T12, and performs these transaction processes. On the other hand, the log output transmission processing unit 122 is started in response to a request from the transaction processing unit 121, stores the history of these operations in the access log 15 of the main system 1, and uses this as a reflection log by a periodic interruption by a system timer. Send to system 2. Also, control related to system switching at times t1 and t2 is performed.
[0017]
On the other hand, the second information processing means 22 of the secondary system 2 has a transaction processing unit 221 and a log reception reflection processing unit 222. During the normal service period of the main system 1, the transaction processing unit 221 does not operate, and the log reception reflection processing unit 222 receives the log from the main system 1 and reflects it on the second database DB2. At time t2, the system switching is performed, and during the limited service period T23 and during the normal service period thereafter, the message from the online data terminal group 4 enters the second information processing means 22 of the sub system 2, so that the transaction processing is performed. The unit 221 is activated and performs necessary processing.
[0018]
As described above, in this embodiment, the log output transmission processing unit 122 is activated upon receiving a log output request each time the transaction processing unit 121 performs one process, and is accumulated in the access log 15 of the main system 1. As a timing for sending the data to the subsystem 2, a periodic interrupt by a system timer was used. That is, the log output transmission processing unit 122 is called at regular intervals when there is a sufficient space for the access log, and the log is transmitted to the secondary system 2. On the other hand, the log reception reflection processing section 222 of the second information processing means 22 receives the reception notification from the communication control means 14 and reflects the received content in the second database DB2. With a time delay determined by the interval, the data reflection on the subsystem 2 is maintained. In addition, during the normal service period by the sub system 2 after the limited service period T23 ends, the system of the partner main system 1 is stopped, so that the periodic interrupt is not generated until the main system 1 is separately put into the recovery standby state. .
[0019]
The backup method based on the time delay described above is the same as the method in the related art. In the present invention, the main point of the above operation is that the transaction processing unit 121 in the switching preparation period T12 and the transaction processing unit 221 in the limited service period T23 use the access key server 5 to perform non-stop service switching.
Hereinafter, this operation will be described in detail with reference to FIGS.
[0020]
FIG. 4 is an operation flow of the transaction processing unit, which performs transaction processing during the normal service period and the switching preparation period T12. First, in step S401, an access request message is transmitted from the online data terminal group 4 via the switching control unit 11. In step S402, these transactions are executed unconditionally while referring to the ledger of the first database DB1, and the execution results are entered in the first database DB1 to update the ledger. That is, a service based on a complete ledger capable of handling all transactions is provided.
[0021]
Next, in step S403, it is confirmed that the log output transmission processing unit 122 is not transmitting a log, and in step S404, the log output transmission processing unit 122 is started to record this ledger access history in the access log 15 of the main system 1. . The symbol “☆” in the figure indicates a start trigger to the log output transmission processing unit 122. Information output to the access log 15 of the main system 1 includes a ledger access history, a logical time corresponding to the access time, the contents of the phase flag ph, and the like. The ledger access history is a record capable of reproducing the changed contents of the first database DB1 in step S402. For example, even the database access macro (record update, generation, deletion) itself issued in step S402 is used. Good. A logical time, which is a serial number that guarantees the order of access, is added to this, and the order of reflection in the subsystem 2 is ensured. The phase flag ph is a flag indicating that the corresponding transaction is in the phase of the switching preparation period T12 or the limited service period T23, and the log output transmission processing unit 122 described later is used by the first information processing unit 12 and the access key server. 5 is set.
[0022]
Next, in step S405, it is determined whether or not the current time is during the switch preparation period T12 by checking the phase flag ph. If the current time is during the normal service, the process ends. The access key is written in the key server 5. That is, of the changes made to the first database DB1 in step S402, at least key information corresponding to the changed record is recorded to prepare for future access from the secondary system 2.
[0023]
FIG. 8 shows an example of setting an access key including key information corresponding to the example of the structure of the first database DB1. In the ledger of the first database DB1, as shown in FIG. 8 (a), there are management records for each account of each financial instrument under customer management records, and records of transaction details are linked under each. are doing. FIG. 8B shows an example of the data format of the deposit management record. The access request from the online data terminal group 4 includes at least a store number, an account number, and a subject. In step S402, the corresponding management record in the first database DB1 is searched based on the request, and the corresponding transaction record is determined. After the update of the detail record is performed, the summary information such as the balance of the management record is rewritten.
[0024]
Since a record changed in one transaction always has a corresponding unique set of store number, account number, and item, the record is managed as an account id and used as key information. The minimum role of the access key is to know the account id that caused the change in the first database DB1 during the switch preparation period T12. That is, if the account id is recorded as key information in the access key server 5 one by one, the record corresponding to the account id not found by searching the access key server 5 has not been changed during the switching preparation period T12. Guaranteed.
[0025]
A single transaction may generate more than one key. For example, in a transaction in which the savings account of A is transferred to the checking account of B, two key information of the account id of the withdrawal source and the account id of the depository are recorded as shown in FIG. In FIG. 8C, the balance is recorded as the access key in addition to the key information, but this is an example of what is required depending on the contents of the limited transaction processing described later in step S605 of FIG.
[0026]
Next, log transmission and system switching operation of the log output transmission processing unit will be described with reference to FIG. The log output transmission processing unit 122 is a log output part (steps S501 to S504) activated by the access log output request (step S404 in FIG. 4) of the transaction processing unit 121 described above, and a periodic interruption of the system timer. (Steps S521 to S530).
[0027]
The log output portion checks in step S501 whether the communication control unit 14 is transmitting a log. If the log is not being transmitted, the log output flag lo is set in step S502, and the transaction is transmitted to the access log 15 of the main system 1 in step S503. The log contents entrusted from the processing unit 121 are written out. Then, in step S504, the log output flag lo is reset, and the process ends.
[0028]
The periodic interrupt from the system timer includes three types: a periodic interrupt during normal service, a periodic interrupt for instructing switching preparation, and a periodic interrupt for instructing execution of switching. These are instructed to the main system 1 by an operation from a console of a system administrator in an initial mode schedule setting section (not shown). That is, when the date and time at which the system of the main system 1 is to be stopped for maintenance and inspection is input, the first information processing means 12 sets the closest periodic interrupt to the switching execution interrupt and prepares the immediately preceding periodic interrupt for switching. Schedule for an interrupt. Other periodic interrupts are normal interrupts.
[0029]
Upon receiving these periodic interrupts, the log output transmission processing unit 122 checks that the log output has been completed in step S521, sets the log transmission flag ls in step S522, and then transmits the log transmission flag ls to the communication control unit 14 in step S523. It instructs the contents of the access log 15 of the main system 1 to be transmitted to the sub system 2. In response to the successful completion of the log transmission from the communication control unit 14, the log output transmission processing unit 122 resets the access log 15 of the main system 1 in step S524 to prepare for the next log accumulation. When the above is completed, the log sending flag ls is reset in step S525.
[0030]
Next, in step S526, the type of the interrupt is checked, and if the interrupt is a normal scheduled interrupt, the process ends. If the request is a switching preparation request, the buffer contents of the access key server 5 are reset and the phase flag ph is set to a switching preparation value in step S527 as preparation for recording the key portion of the subsequent transaction in the access key server 5. To inform the transaction processing unit 121 that it has entered the switching preparation period T12.
[0031]
If it is determined in step S526 that the interrupt is a switching execution request, the log output transmission processing unit 122 executes system switching in step S528. That is, an instruction to switch the switch of the switching control unit 11 to the subsystem 2 is issued. As a result, the online data terminal group 4 is connected to the subsystem 2, and subsequent access requests enter the second information processing means 22. Then, in order to notify the second information processing means 22 that the limited service period T23 has been entered, the phase flag ph at a predetermined position in the access key server 5 is set in step S529. After this, the main system 1 can no longer be stopped, so the main system 1 is automatically stopped in step S530. When the main system 1 is restarted, initial values of flags are set by an initial mode schedule setting unit (not shown).
[0032]
The operation of the second information processing means 22 corresponding to the operation of the first information processing means 12 will now be described with reference to FIGS. As described above, the second information processing means 22 includes a transaction processing unit 221 for processing a transaction during the limited service period T23 and the subsequent normal service period, a limited processing log during the limited service period T23, and a log at a time earlier than that. And a log receiving / reflecting processing unit 222 for reflecting the received data.
[0033]
FIG. 6 is an operation flow of the transaction processing unit of the second information processing means. When a message from the online data terminal group 4 is received, the transaction processing unit 221 is activated. First, if the limited processing log is being reflected in step S601, the message processing is made to wait until the end. This meaning will be described later in the description of the limited processing log in FIG. Next, in step S602, the current phase is confirmed. That is, the access key server 5 is read and the value of the phase flag ph is checked to determine whether it is during the limited service period T23. In this embodiment, the phase flag ph is provided on the access key server 5 for simplicity, and during the normal service period by the subsystem 2 after the end of the limited service period T23, the access key server is executed every time a message is received in step S602. Although an example of accessing the access key server 5 has been described, the system administrator intervenes and sets a mode schedule at a certain time after the end of the limited service period T23 as shown in a second embodiment later. Can be made unnecessary.
[0034]
If the current phase is not during the limited service period T23, the transaction processing unit 221 proceeds to step S606, performs normal transaction processing with reference to the subledger of the second database DB2, and stores the result in the second database DB2. Write to. Also, in step S607, it is confirmed that the transaction processing unit 221 is not transmitting a log, and then, in step S608, a request is issued to output this access history to the access log 25. In steps S606 to S608, the main system 1 and the sub system 2 perform steps S402 to S404 in FIG.
[0035]
If it is during the limited service period T23 in step S602, the transaction processing unit 221 searches the access key server 5 in step S603, and determines whether key information included in the message is registered in the access key server 5 in step S604. Judge. If not registered, the access request for the message can be processed using the subledger of the second database DB2, so that the normal transaction processing already described in step S606 is performed.
[0036]
If the access keys match in step S604, a predetermined limited transaction process is performed in step S605, and the result is written to a limited process log. Here, the limited transaction process refers to a process in which a transaction request of a message performs only a process that can be transacted on the basis of the contents of the access key server 5, and if not, the transaction request is suppressed. In the simplest case, all messages including the account id of the key information registered in the access key server 5 are deterred from trading, and, for example, a message saying “It is crowded and cannot be accepted.” Replies to online data terminals.
[0037]
As shown in FIG. 8C, when the access key server 5 always records the account id and its balance as an access key, a certain degree of service is possible as limited transaction processing. For example, a deposit deposit and payment service can be performed by referring to the balance of the access key server 5, but a bookkeeping service that requires reference to a detailed record cannot be performed. As described above, the service to be executed by the limited transaction processing and the service to be suppressed are determined by comparing the type range of the access key information recorded in the access key server 5 with the type range of the information required by the transaction service. The access key is designed in consideration of these at the time of design.
[0038]
The details of the limited transaction processing performed in this manner are temporarily stored in a limited processing log. Because, at this point, the contents of the change during the switch preparation period T12 of the account id may not be completely reflected in the second database DB2 of the sub system 2 which is the sub ledger. This is because this limited transaction process cannot be written to the subledger. The limited transaction history recorded in the limited processing log includes all information regarding the transaction details that should be reflected later in the detail record of the ledger, and this information is accumulated together with the logical time.
[0039]
Finally, a log reflection operation including the above-described limited processing log will be described with reference to FIG. The log reception reflection processing unit 222 of the second information processing unit 22 is activated by a log reception notification from the communication control unit 14. In step S701, the log reception reflection processing unit 222 stores the log received from the communication control unit 14 in the access log 25. When the entire storage is completed, this content is reflected in the sub-ledger of the second database DB2 in step S702. In other words, when the log content is a database access macro sequence in the order according to the logical time, the macro is executed in this order and the second database DB2 is accessed, as if the transaction processing was performed sequentially. The record of the second database DB2 is changed. Thus, the secondary ledger finishes reflecting the contents of the first database DB1, which is the primary ledger, with a time delay. Upon completion of the reflection processing in step S702, the log reception reflection processing unit 222 resets the contents of the access log 25 in step S703 to prepare for the next log reception.
[0040]
Next, in step S704, the log reception reflection processing unit 222 checks the phase flag ph to determine whether the current time is during the limited service period T23. In the case of receiving the log during the limited service period T23, it is known that the log content is the change during the switch preparation period T12, and the content of the second database DB2 is currently the first database immediately before the switch. This means that the state of DB1 has been completely reflected, and it is now possible to reflect the limited processing log from step S705 to step S707.
[0041]
Step S706 is a process of reflecting the limited process log, which is a record of the limited transaction process during the limited service period T23, in the secondary ledger of the second database DB2. When all the components have been reflected, the limited process log area is reset. At this point, the second database DB2 has become a complete ledger, and is ready to handle the normal transaction service thereafter. If a new limited transaction process occurs during the process of step S706, the reflection is omitted. Before and after this process, the limited log reflecting flag gl is set in step S705, and this flag is reset in step S707. In step S601 of the transaction processing unit 221 in FIG. 6 described above, this flag avoids conflict between the limited transaction processing and the reflection of the limited processing log in step S706.
[0042]
In step S707, the reset of the limited log reflecting flag gl and the setting of the phase flag ph to the normal service phase value are performed simultaneously. This completes the system switching process, the secondary system 2 takes over the online transaction, and the main system 1 is in a state of stopping the system. Finally, in step S708, an interrupt mask (not shown) of the second information processing unit 22 is instructed to mask the interrupt so that the transfer of the access log 25 to the main system 1 does not occur. I do.
[0043]
In the above description, in order to make the main point of the present invention easy to see, the main system 1 performs the normal service while the sub-system 2 follows the time-delay while the sub-system 2 follows the sub-system 2 through the switching preparation period T12. Only the process of switching to the online service by the sub system 2 and establishing the normal service system by the sub system 2 via the limited service during the limited service period T23 has been described.
[0044]
However, in an actual implementation system, however, a process is required after which the main system 1 returns after completing the maintenance and inspection, and returns the transaction connection from the sub system 2. That is, the main system 1 goes through a return switching preparation period T12 'in which the main system 1 receives the access log during the normal processing before the return, and a return limited service period T23' in which the limited transaction processing by the main system 1 is performed at the time of switching. Will return to 1. These can be easily realized by causing the operation of the first information processing means 12 shown in the embodiment of the present invention to be performed by the sub system 2 and the operation of the second information processing means 22 to be performed by the main system 1. So I'll just add a brief description here.
[0045]
That is, in order to realize switching between the main system 1 and the sub system 2 in both directions, a common information processing unit having the functions of the first information processing unit 12 and the second information processing unit 22 of the above embodiment is provided. What is necessary is just to implement the online database information processing system with a backup function consisting of the main system 1 and the sub system 2. FIG. 9 shows such a second embodiment.
[0046]
As shown in FIG. 9 (a), in the case of the present embodiment, both the main system 1 and the sub-system 2 have an information processing means 32 common to them, and the configuration of the parts related to the present invention is shown in FIG. 9 (b). It is. Here, the initial mode schedule setting unit is started by the system administrator to change the mode at the time of initial startup of the system or at any time during operation. Here, parameters input for mode setting are, for example,
-Self id: G (Load to main system 1)
B (Load to Subsystem 2)
Initial id: 1 (starts from the state of the system in which the main system 1 is the operating system and the sub system 2 is in the standby state, that is, the state in which the switching control means 11 is switched to the main system 1 side).
2 (Start from the state of the system in which the main system 1 is a standby system and the sub system 2 is in operation, that is, the state in which the switching control means 11 is switched to the sub system 2 side.)
It is. With these settings, the common information processing means 32 of the main system 1 is set to one of G1 on the working side and G2 on the standby side, and similarly, the common information processing means 32 of the sub system 2 is switched to the working side. B2, or B1 around the standby side. The input parameters for schedule setting are
-Periodic interrupt interval value: 999 min. (Enter in 3 digits in minutes)
-Self stop date and time: mm. dd. hh (Input request is made when G1 or B2 is selected.)
and so on. With the above parameter setting, the initial mode schedule setting unit resets the subordinate transaction processing unit, log output transmission processing unit, and log reception reflection processing unit to standby. That is, the flags are reset, the periodic interruption prohibition after the limited service period T23 is released, and the switching control means 11 is switched to the main system 1 or the sub system 2 according to the mode. Thereafter, the functions of FIGS. 4 to 7 described above operate due to the already described factors such as message reception and periodic interruption. However, the parameters shown in FIG. 9B are replaced according to the operation modes G1, G2, B1, and B2 of the common information processing means 32. For example, the log transmission flag is set and managed in two independent areas, ls used in the G1 mode and ls' used in the B2 mode. In such an embodiment, when returning from the sub system 2 to the main system 1, the system administrator can activate the initial mode schedule setting unit and give an instruction to return. Further, in the normal processing after the limited service period T23, logs are accumulated in the access log 25 of the sub system 2 more and more, so that the system administrator intervenes by the initial mode schedule setting unit when the preparation is completed. As a result, the flag management shifts to the normal processing before the switching preparation period T12, so that the scheduled transfer of the access log is restored again.
[0047]
Although the gist of the present invention seems to have been clarified by the above, some supplementary explanations will be given in the following. In this embodiment, the positional relationship among the main system 1, the sub system 2, and the access key server 5 is not specified. In consideration of disaster countermeasures, these may be located at remote locations and connected by a communication line, or all may be installed in one room. If the main system 1 and the sub system 2 are designed to notify the phase flag ph via a communication line without using the phase flag ph on the access key server 5 as in this embodiment, at least the access key server 5 May be operable only at the time of system switching, and may be in a system stopped state at other times.
[0048]
Further, the first information processing means 12, the access log 15, and the like may be composed of a plurality for load sharing. In this case, the first information processing means 12 needs to have a manager that keeps unification among the plurality of information processing means and exclusively accesses the common first database DB1. A plurality of transaction processing units 121 under its control need to access the database by requesting the manager and receive a logical time according to the access order. In such a configuration, the communication line 3 is also multiplexed, and the transfer efficiency of the access log can be increased. Since the logical time guarantees the time order of the history over the plurality of access logs transferred in parallel, the log receiving / reflecting processing unit 222 merges the contents of the plurality of access logs 25 and sets the logical time. After that, the reflection process described in step S702 is performed.
[0049]
【The invention's effect】
As is apparent from the above description, according to the present invention, in the online database information processing system with the backup function, when the system is switched between the main system and the sub system, a part of the access request from the online data terminal group is limited. Thus, a normal service can be performed for other access requests, and the system can be switched even during a time period in which the system cannot be stopped.
[Brief description of the drawings]
FIG. 1 is a configuration example of an online database information processing system with a backup function.
FIG. 2 is a timing chart of system switching from a main system to a sub system.
FIG. 3 is a configuration example of first information processing means and second information processing means;
FIG. 4 is an operation flow of a transaction processing unit of the first information processing means;
FIG. 5 is an operation flow of a log output transmission processing unit of the first information processing means;
FIG. 6 is an operation flow of a transaction processing unit of the second information processing means;
FIG. 7 is an operation flow of a log reception reflection processing unit of the second information processing means;
FIG. 8 is a structural example of a ledger database and an example of setting an access key.
FIG. 9 is an embodiment of an online database information processing system with a backup function having common information processing means.
[Explanation of symbols]
DB1 First database
DB2 Second database
1 main system
2 Subsystem
5 access key server
12 First information processing means
15 Main system access log
22 Second information processing means
25 Access log of the secondary system
32 Common information processing means
121 Transaction Processing Unit of First Information Processing Means
122 Log output transmission processing unit of first information processing means
221 Transaction processing unit of second information processing means
222 Log reception reflection processing unit of second information processing means

Claims (2)

An online database information processing system for connecting an operating system having a first database and a standby system having a second database to reflect the contents of the first database in the second database with a certain time delay. ,
An access key server that can be written and referenced from both the operating system and the standby system;
The operating system is a transaction process that records at least the key portion of the transaction content generated within a predetermined period (T12) before the switching from the operating system to the standby system in the access key server. has a part,
System in the standby, the access request content from a predetermined time period (T23) line data terminal group that has been generated in the following implementation of switching to the system in the standby against the contents of the access key server, the same key An online database information processing system with a backup function, comprising a log reception reflection processing unit that performs a limited process for an access request having (1). 2. The online database information processing system with a backup function according to claim 1, wherein a transaction service of the request is suppressed as the limited processing.

Images