JPH0535566A - Journal collecting system in on-line information processing system - Google Patents

Abstract

PURPOSE:To eliminate the collecting of an unnecessary journal. CONSTITUTION:During a transaction, a start journal, an end journal, etc., requested to be outputted from a transaction execution means 301 and an updated journal requested to be outputted from a data base access means 401 are stored temporarily in the journal buffer 508 of a journal control means 401. At the end of the transaction, a journal check means 505 checks the journal collecting mode of the transaction set in a collecting mode memory 509 and if a collecting mode is set when a data base is updated or when there is a forcible output request from a transaction processing program, a file output means 506 outputs the journal on the journal buffer 508 to a journal file 601 only on condition that the updated file is present in the journal buffer 508 or that there is the forcible output request.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a journal collecting method in an online information processing system.

[0002]

2. Description of the Related Art In a conventional online information processing system which receives a message sent from an online terminal and performs transaction processing, a journal which is an execution history of each transaction is stored in a journal file on an external storage device such as a magnetic disk device. Output directly to
Alternatively, the contents of the buffer are once output to the buffer and the contents of the buffer are output to the journal file asynchronously with the transaction processing.

Specifically, when a journal is instructed to be collected, a control journal called a start journal is collected and output at the start of a transaction, and what kind of update was performed when the database was updated thereafter. The indicated update journal is collected and output, and at the end of the transaction, a control journal called the end journal is collected and output.

When a database is restored using a journal when a transaction ends abnormally, a journal used as restoration information is input from a journal file to perform restoration processing.

[0005]

By the way, when the journal is collected for the purpose of restoring the database, it is not necessary to store the journal related to the transaction that only refers to the database. However, since it is not possible to know in advance whether the transaction only refers to the database or updates the database, conventionally, the start journal is always output at the start of a transaction, and the update journal is output when the update is performed. In addition, the end journal was output at the end of the transaction.

Therefore, the control journal is collected and output even for the transaction which only refers to the database. As a result, the amount of journals to be collected increases, which is one of the causes of lowering the transaction processing speed.

Further, when the database is restored using the journal when the transaction ends abnormally, there is a problem that the restoration process takes time because the journal used as the restoration information is input from the journal file.

Therefore, a first object of the present invention is to improve the speed of transaction processing by eliminating the collection and output of the control journal relating to the transaction that only refers to the database.

A second object of the present invention is to restore a journal used as restoration information from a memory such as a main memory which can be accessed faster than a journal file when a database is restored using the journal when a transaction ends abnormally. To be able to enter.

[0010]

In order to achieve the above first object, the present invention executes the transaction processing in an online information processing system that receives a message sent from an online terminal and performs transaction processing. Transaction execution means for requesting output of a control journal, and database access means for accessing the database in response to a request from a transaction processing program executed by the transaction execution means and requesting output of an update journal when updating the database. , Journal file,
A journal buffer that is connected to the database access unit and the transaction execution unit, and the journal management unit stores a journal buffer that is requested to be output from the transaction execution unit and the database access unit; The collection mode memory that holds the journal collection mode and the mode that collects the journal when the transaction is completed, when the database is updated in the collection mode memory, or when there is a forced output request from the transaction processing program If the update journal is included in the journal in the journal buffer related to the completed transaction, or a forced output request is issued from the transaction processing program. In the case of Tsu, and journal check means to determine that the required output to the journal file,
File output means for outputting the journal of the journal buffer to the journal file when the journal check means determines that output is necessary.

In order to achieve the second object, when the transaction ends abnormally, the journal stored in the journal buffer is used to restore the state of the database to the state before the execution of the abnormally terminated transaction. Database restoring means is provided in the journal managing means.

Further, in order to reduce the amount of journals for each transaction and enable batch registration of the journal collection mode, the journal output information storage means composed of an external storage device and the journal collection mode for each transaction are started online. And a journal information registration unit for collectively registering in the journal output information storage unit, and the transaction execution unit is configured to set the journal collection mode stored in the journal output information storage unit at the time of online start. A journal collection mode notifying means for notifying the collection mode memory to set the collection mode memory, and the journal check means of the journal management means ends the journal collection mode for each transaction set in the collection mode memory. So that a determination is made by referring to the journal collection mode corresponding to the transaction.

Further, in order to make it possible to change the journal collection mode of each transaction during online execution, the journal collection mode for each transaction stored in the journal output information storage means is changed during online execution according to a request from the center terminal. The journal collecting mode notifying means of the transaction executing means notifies the journal managing mode of the changed journal collecting mode to the journal managing means when the journal information changing means makes a change. I am trying to set it in the mode memory.

[0014]

According to the journal collecting method in the online information processing system of the present invention, when it is desired to stop collecting the journal relating to the transaction which only refers to the database, the journal collecting mode is used when the database is updated or from the transaction processing program. The mode for collecting journals when there is a forced output request is set in the collection mode memory.

The journal collection mode can be set commonly for all transactions or can be set for each transaction. Also, when the forced output request is made, the journal is collected
Even for transactions that only reference the database, there are some transactions that want to keep the evidence that they operated like a management transaction as a journal. Therefore, if you issue a forced output request for such a transaction, make the journal remain. This is because.

When the transaction is started, the transaction execution means requests the output of the start journal, and the database access means that accesses the database in response to the request from the executed transaction processing program requests the output of the update journal when the database is updated. Further, when the output of the end journal is requested at the end of the transaction, these output-requested journals are stored in a journal buffer composed of a memory such as a main memory.

When the above-mentioned journal collection mode is set, the journal check means of the journal management means includes the update journal in the journal in the journal buffer of the completed transaction at the end of the transaction. If there is a forced output request from the transaction processing program, it is determined that output to the journal file is necessary, and the file output means receives this determination and outputs the journal of the journal buffer to the journal file.

Further, when the database is restored using the journal when the transaction ends abnormally, the database restoring means uses the journal stored in the journal buffer to restore the state of the database to the state before the execution of the transaction that ended abnormally. .

[0019]

Embodiments of the present invention will now be described in detail with reference to the drawings.

Referring to FIG. 1, an example of an online information processing system to which the journal collecting method of the present invention is applied is a center terminal 101, an online terminal 102, a journal information registration means 201, a journal information changing means 20.
2, journal output information storage means 203, transaction execution means 301, database access means 40
1, a database 402, a journal management unit 501, and a journal file 601.

The transaction executing means 301 is a means for controlling the processing relating to the execution of the transaction, and as shown in FIG. 2, the transaction control means 302, the journal collection mode notifying means 303, the transaction start processing means 304, and the transaction processing program 305. And transaction end processing means 306.

The journal management means 501 is a means for controlling processing related to journal management such as journal collection, and as shown in FIG. 3, the journal control means 502,
Buffer output means 503, buffer input means 504, journal check means 505, file output means 50
6, database restoring means 507, journal buffer 508 and collection mode memory 509. Note that the main means of the journal management means 501 is also illustrated in FIG.

The journal output information storage means 203 is means for storing a method of collecting a journal which is a transaction execution history. In this embodiment, the information including the transaction name 801, the journal collection mode 802, and other information as shown in FIG. 4 is stored for each transaction so that the journal collection mode can be designated for each transaction. I am trying to do it. The journal collection mode common to all transactions may be stored.

Here, the journal collection mode 8 in FIG.
In the case of the present embodiment, 02 adopts the following modes. Mode 0: Unconditionally collect journals. Mode 1; Collect journals when updating the database or when a forced output request is issued from the transaction processing program. Mode 2: No journal is collected. It goes without saying that other modes may be adopted.

The journal information registration means 201 is means for collectively registering the journal collection mode for each transaction in the journal output information storage means 203 via the path 703 before the start of online work in the online information processing system.

The journal information changing means 202 sets the journal collection mode for each transaction stored in the journal output information storage means 203 in accordance with a display request from the center terminal 101 via the path 704 during the online operation of the online information processing system. Path 707
Through the center terminal 10 via the path 705.
1 to display the data, and then, according to a change request from the center terminal 101 through the path 704, the journal collection mode of the corresponding transaction stored in the journal output information storage unit 203 is changed through the path 706. is there. The journal information changing unit 202 is the journal output information storage unit 203.
When the contents of the above are changed, the fact is notified to the transaction executing means 301 through the path 709.

The transaction control means 302 in the transaction execution means 301 receives a message input from the online terminal 102 through the path 701, controls the entire transaction processing, and sends a message indicating the result etc. through the path 702 to the online terminal 1.
It is a means to return to 02.

The journal collection mode notifying means 303 is
Under the control of the transaction control means 302, the journal output information storage means 2 is used at the time of starting an online operation or when the journal information change means 202 changes the journal collection mode in the journal output information storage means 203.
This is a means for reading the journal collection mode for each transaction stored in 03 through the path 708 and notifying the journal management means 501 through the path 710. The path 711 is a path for transmitting a response to the above notification.

The transaction start processing means 304
Under the control of the transaction control unit 302, it is a unit for performing an initial process at the time of executing a transaction. As a part of the initial process, an output request of a start journal is passed to
2 to the journal management means 501, and the response is received via the path 713.

Transaction processing program 305
Is a program for executing transaction processing related to a message input from the online terminal 102 under the control of the transaction control unit 302. When referring to or updating the database 402 during execution, the request is sent to the database access means 401 through the path 714, and the response is received through the path 715.

The transaction end processing means 306 is
Under the control of the transaction control unit 302, it is a unit for performing a transaction termination process. As a part of the termination process, an output request for an end journal is issued to the journal management unit 501 via the path 720, and the response is sent to the path 7.
21. Processes such as receiving through 21 are performed. In addition, when the transaction ends abnormally, processing such as issuing a restoration request for the database 402 is also performed.

The database access unit 401 is a unit that operates according to a request from the transaction processing program 305 through the path 714 and collectively manages the input / output of the database 402. Reference to the database 402,
The update is performed via paths 718 and 719. Further, when updating the database 402, an output request for an update journal is issued to the journal management means 501 via the path 716, and the response is received via the path 717.

The database 402 is a database that holds various data related to online business of the online information processing system.

The journal control means 502 in the journal management means 501 is a means for controlling the entire processing relating to the output of the journal and the like.

The journal buffer 508 is used for the transaction execution means 301 and the database access means 40.
1 is a buffer for storing the journal requested to be output from the first buffer, and unlike the journal file 601, this is composed of a high-speed accessible memory such as a main memory.

The buffer output means 503 is under the control of the journal control means 502.
Is a means to write a journal in.

The buffer input means 504, under the control of the journal control means 502, has a journal buffer 508.
Is a means to read journals from.

The collection mode memory 509 is a memory for storing the journal collection mode for each transaction notified from the transaction executing means 301.

Under the control of the journal control means 502, the journal check means 505 holds in the collection mode memory 509 whether or not it is necessary to output the journal written in the journal buffer 508 to the journal file 601. This is a means for checking based on the journal collection mode for each transaction and the contents of the journal stored in the journal buffer 508.
Further, the necessity of outputting the output-requested journal to the journal buffer 508 is also checked.

The file output means 506 is under the control of the journal control means 502.
It is a means for writing the journal in the journal buffer 508, which is judged to be necessary to be output according to 05, to the journal file 601 through the path 723.

Under the control of the journal control unit 502, the database restoration unit 507 uses the journal stored in the journal buffer 508 to change the state of the database 402 to the state before the execution of the transaction when the transaction ends abnormally. It is a means to return to.

The journal file 601 is a file on an external storage device such as a magnetic disk device in which a journal is written.

Next, the operation of the present embodiment configured as described above will be described.

In the online information processing system of this embodiment, prior to the start of online work, the journal information registration means 201 sets the journal collection mode for each transaction in the format shown in FIG. It is collectively registered in 203.

After that, when the online business is started,
At the start, the transaction control means 302 of the transaction execution means 301 activates the journal collection mode notification means 303.

The journal collection mode notification means 303
The journal collection mode of each transaction stored in the journal output information storage unit 203 is read through the path 708, and the journal management unit 501 is notified of the read mode through the path 710.

The journal control means 502 of the journal management means 501 stores the journal collection mode and the like of each notified transaction in the collection mode memory 509, and thereafter, in the same mode until the new journal collection mode is notified. Control collection.

When the storage of the journal collection mode and the like in the collection mode memory 509 is completed, the journal control means 5
02 notifies the journal collection mode notifying means 303 of that fact through the path 711, and the journal collection mode notifying means 303 notifies the transaction control means 302 of this.

The journal output information storage means 203
The journal collection mode for each transaction registered in can be changed by the change request from the center terminal 101 using the journal information changing means 202 while the online business is operating.

When such a change is made,
The journal information changing means 202 notifies the transaction control means 302 through the path 709,
The journal collection mode notification means 303 is activated. As a result, the changed journal collection mode is notified to the journal control means 502 by the journal collection mode notification means 303 and stored in the collection mode memory 509, and the journal control means 502 controls the journal collection in the newly notified mode. To do.

Now, when a message is input from the online terminal 102 through the path 701 after the start of the online business, the transaction control means 302 of the transaction execution means 301 which has received the message.
Activates the transaction start processing means 304.

The transaction start processing means 304
Performs the initial processing of the transaction related to the message. Then, as a part of the processing, the journal management means 501 is requested to output the start journal of the transaction through the path 712.

When the journal control means 502 of the journal management means 501 receives the output request of the start journal through the path 712, it causes the journal check means 505 to judge whether or not the journal output is necessary.

At this time, the journal check means 505
Refers to the journal collection mode corresponding to the transaction from the collection mode memory 509,
If it is 1, it is determined that output is necessary, and if it is mode 2, it is determined that output is unnecessary.

When the journal check unit 505 determines that the output is necessary, the journal control unit 502 uses the buffer output unit 503 to store the requested start journal in the journal buffer 508, and sends the response to the path 713.
Through the transaction start processing means 304.
If output is not necessary, the start journal is not stored in the journal buffer 508 and a response is returned to the transaction start processing means 304.

When the transaction start processing ends,
The transaction control unit 302 executes the transaction processing program 305.

A reference request for the database 402 is issued from the running transaction processing program 305 in the path 7
14, the database access means 401
Passes the relevant data in the database 402 to paths 718, 7
It is read through 19 and returned to the transaction processing program 305 by the path 715.

The transaction processing program 3
When an update request for the database 402 is issued from 05 through the path 714, the database access means 401
Requests the journal management means 501 to output the update journal of the database 402 through the path 716.

There are two methods for updating the database 402 by the database access means 401: a method for sequentially performing an update request from the transaction processing program 305 and a method for performing a batch at the end of the transaction. In the present embodiment, the former method is adopted, and the update journal having the contents suitable for the former method is collected. Of course, the latter update method can be adopted. In that case, an update journal suitable for the latter update is collected, and the database 40 is stored in the journal buffer 508 at the end of the transaction.
2 updates are made. In the latter case, the database 402 is not updated when the transaction ends abnormally, so that
It is possible to restore.

When the journal control unit 502 of the journal management unit 501 receives the output request of the updated journal through the path 716, the journal check unit 505 makes the same judgment as in the case of the start journal, and when it is judged that the output is necessary. The buffer output means 503 is used to store the requested update journal in the journal buffer 508. The response is returned to the database access unit 401 via the path 717.

At the end of the transaction processing program 305, that is, at the end of the transaction, the transaction control means 302 activates the transaction end processing means 306.

The transaction end processing means 306
Post-process the transaction. Then, as part of the processing, the journal management unit 501 is requested to output the end journal of the transaction through the path 720.

The transaction processing program 3
When a forced output request of a journal is issued from the program 305 during execution of 05, the transaction control means 302 stores this internally and notifies the transaction end processing means 306 at the end of the transaction, and the transaction end processing The means 306 notifies the journal management means 501 at the same time when the end journal output request is made.

When the journal control means 502 of the journal management means 501 receives the output request of the end journal through the path 720, whether or not it is necessary to output this end journal and other journals related to the transaction to the journal file 601. Is checked by the journal check means 505.

The journal check means 505 refers to the collection mode memory 509 and unconditionally determines that the output is necessary if the journal collection mode of the transaction is mode 0. Further, in the mode 1, the transaction processing program 3 is stored in the transaction control unit 302.
Inquire whether there is a forced output request from 05,
If there is, it is judged that the output is necessary, and if there is not, journal control means 5
02 and the buffer input means 504, the journal related to the transaction in the journal buffer 508 is input to check whether or not the update journal is included. If the update journal is included, it is determined that the output journal is required. Judge that output is not required. Further, in the case of mode 2, it is determined that output is unnecessary.

The journal control unit 502 uses the file output unit 506 only when the journal check unit 505 determines that the output to the journal file 601 is necessary, and the transaction is stored in the journal buffer 508. All such journals are output to the journal file 601.

When the journal control means 502 finishes controlling the output of the journal, it returns a response to the transaction termination processing means 306 through the path 721, and the transaction termination processing means 306 terminates the termination processing.
This is notified to the transaction control means 302.

When the transaction post-processing is completed, the transaction control means 302 determines that the online terminal 1
02, the message is transmitted via the path 702.
This completes the processing of one transaction.

The above is the operation when the transaction ends normally. The transaction processing program 3
When the transaction is abnormally terminated due to an execution error 05, an I / O error in the database access unit 401, or the like, the following operation is performed.

When the transaction ends abnormally, the transaction control means 302 requests the transaction end processing means 306 for post-processing associated with the abnormal end.

The transaction end processing means 306
As part of the post-processing, the journal management means 501 is requested to restore the database 402 via the path 720.

The journal control means 502 of the journal management means 501 uses the path 720 for the database 40.
When the second restoration is requested, the journal relating to the abnormally terminated transaction is input from the journal buffer 508 by using the buffer input unit 504, and the database restoration unit 507 is activated by passing it.

The database restoring means 507 uses the passed journal to restore the database 402 to the state before the start of the transaction through the path 722.

When the restoration of the database 402 by the database restoration means 507 is completed, the journal control means 5
02 notifies the transaction end processing means 306 of that fact through the path 721.

The transaction end processing means 306
Next, the output of the end journal is requested to the journal management unit 501 via the path 720. This end journal output request is processed in the same manner as described above.

Then, the transaction end processing means 3
When the end processing according to 06 is completed, the transaction control unit 302 sends a path 702 to the online terminal 102.
To notify that the transaction ended abnormally. This completes one transaction process.

[0077]

According to the journal collecting method in the online information processing system of the present invention described above, the following effects can be obtained.

(1) If the journal collection mode is set so that collection is performed when the database is updated or when a forced output request is issued from the transaction processing program, all journals related to transactions that only refer to the database are set. Can be eliminated. In addition, when a forced output request is made, it is collected. Therefore, even if it is a transaction that only refers to the database, transaction processing is required for a transaction that wants to retain the evidence that it operated like a management transaction as a journal. The journal can be collected by issuing a forced output request from the program.

(2) When a database is restored using a journal when a transaction ends abnormally, a journal used as restoration information is input from a journal buffer composed of a memory such as a main memory that can be accessed faster than a journal file. Therefore, the restoration process can be speeded up.

(3) Since the journal collection mode can be set for each transaction, fine journal collection control such as reduction of the journal amount for each transaction becomes possible.

(4) Since the journal collection mode can be changed during online execution, it is not necessary to stop the online work for changing the journal collection mode.

[Brief description of drawings]

FIG. 1 is a block diagram showing an example of an online information processing system to which a journal collecting method of the present invention is applied.

FIG. 2 is a block diagram showing a configuration example of a transaction executing means.

FIG. 3 is a block diagram showing a configuration example of journal management means.

FIG. 4 is a diagram showing an example of contents of information stored in a journal output information storage means.

[Explanation of symbols]

101 ... Center terminal 102 ... Online terminal 201 ... Journal information registration means 202 ... Journal information changing means 203 ... Journal output information storage means 301 ... Transaction execution means 302 ... Transaction control means 303 ... Journal collection mode notification means 304 ... Transaction start processing means 305 ... Transaction processing program 306 ... Transaction end processing means 401 ... Database access means 402 ... Database 501 ... Journal management means 502 ... Journal control means 503 ... Buffer output means 504 ... Buffer input means 505 ... Journal checking means 506 ... File output means 507 ... Database restoring means 508 ... Journal buffer 509 ... Collection mode memory 601 ... Journal file

Claims (4)

[Claims] 1. An online information processing system for receiving a message sent from an online terminal and performing a transaction process, a transaction execution unit for executing the transaction process and requesting output of a control journal, and the transaction execution unit. Database access means for accessing the database in response to a request from the transaction processing program executed in the above, and for requesting output of an update journal when updating the database; journal file; journal management connected to the database access means and the transaction execution means Means, and the journal management means is a jar output requested by the transaction execution means and the database access means. And journal buffer for storing Le, and collecting mode memory for storing a journal collection mode, at the end of a transaction, the collection mode memory,
When the database is updated or the mode to collect the journal when a forced output request is issued from the transaction processing program is held, the journal in the journal buffer related to the terminated transaction includes the update journal. If there is a forced output request from the transaction processing program, the journal check means determines that output to the journal file is necessary, and the journal buffer is determined by the journal check means when output is required. And a file output means for outputting the journal to the journal file. 2. The journal management means is provided with database restoring means for restoring the state of the database to the state before the execution of the transaction that ended abnormally by using the journal stored in the journal buffer when the transaction ended abnormally. A journal collection method in the online information processing system according to claim 1. 3. A journal output information storage means composed of an external storage device, and journal information registration means for collectively registering a journal collection mode for each transaction in the journal output information storage means before starting online. At the same time, the transaction executing means is provided with a journal collecting mode notifying means for notifying the journal managing means of the journal collecting mode stored in the journal output information storing means at the time of online start and setting the journal collecting mode in the collecting mode memory. The journal check means of the journal management means makes a determination by referring to the journal collection mode corresponding to the completed transaction among the journal collection modes for each transaction set in the collection mode memory. Journal collection system in the online information processing system of the other two described. 4. A journal information changing means for changing the journal collecting mode for each transaction stored in the journal output information storing means during online execution according to a request from a center terminal, and notifying a journal collecting mode of the transaction executing means. 4. The online information processing according to claim 3, wherein the means, when there is a change by the journal information changing means, notifies the changed journal collecting mode to the journal managing means and sets the journal collecting mode in the collecting mode memory. Journal collection method in the system.