JPH0696110A - Data updating system - Google Patents

Abstract

(57) [Summary] [Purpose] The purpose of the data update system is to shorten the update time by batch processing of files. [Configuration] A data updating system having a database constructed by a transactable account, having a processing system for collectively updating variable processing for at least the database, and having a processing system for immediately updating the database in response to a transaction occurrence Then, a sub-database is created from the database, an immediate update process is performed on the sub-database according to the occurrence of a transaction and a transaction record is created, and a batch update process is performed on the database. , After closing the transaction process, reflect the account updated in the sub-database to the database that has completed the batch update process based on the transaction record, and execute the batch update process for the database to the reflected account Configure to run.

Description

Detailed Description of the Invention

[0001]

FIELD OF THE INVENTION The present invention relates to a data updating system.

[0002]

2. Description of the Related Art In recent years, financial institutions are rapidly becoming computerized, and most of their work is carried out using an electronic computer system.

Batch processing for updating files used in the following online databases in banking operations is as follows:
It must be performed after the online operation is finished, which is after the customer balance is fixed, and moreover, all the batch processing takes a long time.・ Interest factor addition process ・ Compression process for unregistered passbook unbooked accounts ・ Current account settlement process ・ Deposit / loan ledger maintenance process etc.Batch processing to update such database is not executed every day, but monthly Since the processing is performed several times, the processing is conventionally performed at night or on holidays when the online processing is stopped. However, while the banking system of recent years has such a long batch processing at night and on holidays, it is possible to perform online processing at night or on holidays when such tasks as Sunday banking, automatic machine handling time extension, etc. should be performed. It has to be done, which is a factor that significantly impairs the operation of the office center.

FIG. 6 is an explanatory diagram of processing of a conventional database update processing system. 30 in the figure is a database (DB
It is a database composed of files used for various transaction processing such as banking system. On the normal business day of (A) in the figure, online processing of transactions generated using this DB30 is performed. For example, if you need to calculate the interest on a deposit and add it to the principal,
Such interest addition processing is carried out during business closure periods such as holidays in (B) of the figure. For the processing of the next business day after the holiday in (C) of the figure, the online processing of the transaction is performed using the DB30 that has been subjected to the interest addition processing on the previous day.

[0005]

[Problems to be solved by the invention] Banks are investing personnel costs to invest in center operations, such as hiring full-time operators and thoroughly implementing shift work. It is difficult to achieve both saving and saving.

Therefore, there has been a demand for a mechanism for carrying out batch processing for a DB in parallel with the holiday (Sunday banking) system operating time. In view of the above point, the present invention has an object to provide a means for shortening the update time of the business DB by executing online processing and batch processing in parallel.

[0007]

The above problems can be solved by a data updating system configured as described below.

FIG. 1 shows the principle of the present invention. Having a database 11 constructed with a tradable account, having at least a processing system for collectively updating variable processing for the database 11, and having the database depending on the occurrence of a transaction
A data update system comprising a processing system for updating 11 immediately, wherein the database 11 is a sub-database
10 is created, the sub-database 10 is immediately updated according to the occurrence of a transaction, and a transaction record 12 is created,
On the other hand, a batch update process is executed for the database 11 to close the transaction process, and the database 11 that has completed the batch update process based on the transaction record 12 for the account updated in the sub-database 10. Then, the batch update processing for the database 11 is executed for the reflected account.

[0009]

Operation: A sub-database 10 is created from the database 11, an immediate update process is performed on the sub-database 10 according to the occurrence of a transaction, and a transaction record 12 is created, while
A batch update process is executed for the database 11, the transaction process is blocked, and then the account updated in the sub-database 10 is reflected in the database 11 that has completed the batch update process based on the transaction record 12. The database 11
The batch update process for is executed for this reflected account.

Therefore, by performing batch processing on the database 11 in parallel with the online processing on holidays in the sub-database 10, reflecting only the variation of the sub-database 10 in the database 11, and then performing the batch processing again. The same result as online processing and batch processing can be obtained equivalently, and the variation in the sub-database 10 is small compared to the data amount in the database 11, which is effective in shortening the online system operation time. There is.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention consists in constructing a specific account from a database into a sub-database, executing independent online processing and batch processing in parallel in these two databases, and combining the results of both by post-processing. The result is the same as serially executing the online processing and batch processing.

FIG. 2 is a block diagram of a data updating system according to an embodiment of the present invention. In the figure, reference numeral 25 is a transaction call, which is generated by requesting real-time processing. Reference numeral 30 denotes a DB for online processing used on weekdays, which is a database connected online such as a banking system and used for real-time processing of transactions caused by the occurrence of a call. An online DB 31 for holiday processing is a sub-database extracted from the weekday online DB 30 by the holiday DB creation unit 40.

Reference numeral 40 denotes a holiday DB creation section, which extracts a target account (for example, a savings account) to be updated online on holidays from the weekday online DB 30 and copies it as a holiday online DB 31. An online processing unit 41 processes a transaction call using the holiday online DB 31 during the holiday operation, and records the processed customer identification code and account as a transaction record file 32. A batch processing unit 42 performs batch processing of the weekday online DB 30.

Reference numeral 43 denotes a holiday fluctuation copying unit, which refers to the transaction record file 32 and performs batch processing of account data of customers who have transactions from the holiday online DB 31 for each customer to the weekday online DB 30. , To be copied. A selective batch processing unit 44 refers to the transaction record file 32 on the weekday online DB 30 and selectively performs batch processing on the account of the customer who has a holiday transaction.

FIG. 3 is an explanatory view (No. 1) of processing of the data updating system according to the embodiment of the present invention. FIG. 4 is a process explanatory diagram (2) of the data updating system according to the embodiment of this invention. Reference numerals are the same throughout the drawings. The operation of the present invention will be described below with reference to FIGS. Only holiday target accounts are extracted from weekday online DB30 to create holiday online DB31. FIG. 3A shows this operation. Here, the holiday operation target account means, for example, an ordinary savings account that can be performed by automatic machine transactions.

FIG. 4A shows data for one customer in the weekday online DB. . The weekday online DB data stores customer identification codes, customer information (address, name, etc.), and accounts (saving account, checking account, etc.).
Here, in the holiday online DB, for example, only ordinary savings accounts can carry out card transactions with automatic machines, so the account data is created by extracting only ordinary savings accounts.

(B) is data showing one customer of the holiday online DB. The data in the holiday online DB is used only for holiday online processing, for example, only ordinary savings accounts. As a result, in the holiday online processing, the online operation using the holiday online DB 31 can be performed. Since the weekday online DB 30 is not used for online processing during the holiday online operation, the batch processing that requires a long time is executed by making the best use of this time zone.
FIG. 3B shows an operation of executing holiday online processing using the holiday online DB 31 and batch processing for the weekday online DB 30 in parallel.

FIG. 4C shows the data of the ordinary deposit account in the weekday online DB. On weekday online DB30, the interest principal addition process for the principal amount of 100,000 yen is performed in batch processing, so if the interest rate is 3%, the interest will be added by 3,000 yen.

On the other hand, holiday online processing is performed using the holiday online DB31. If it is assumed that an automatic machine withdraws 30,000 yen, the data of the savings account in the holiday online DB31 is withdrawn 30,000 yen. The record remains, and the identification code of the customer who updated the account data is recorded in the transaction record file 32. FIG. 4D shows the data of the savings account in the holiday online DB 31. The holiday online process and the batch process are executed in parallel, and the holiday online DB 31 and the weekday online DB 30 receive the above updates. FIG. 3C shows that the holiday variable copy process is performed.
This is the holiday online DB 31 by identifying the customer account data (hereinafter referred to as holiday transfer account data) updated by the holiday online processing by the transaction record file 32.
Is a process of copying from the account data of the customer in the weekday online DB 30. By this processing, weekday online DB30
The customer's account data is replaced with the results of the holiday online processing. Therefore, only the holiday transfer account data is entered in the weekday online DB 30, and the result of the interest principal addition process which is the result of the batch process is lost. Figure 4
(E) indicates the result of the holiday variable copy process. Therefore, with respect to the weekday online DB 30, the batch processing of, for example, the addition of the principal amount of interest is executed again for the customer's account recorded in the transaction record file 32. FIG. 3D shows the selected batch process.

Since the amount of data for the holiday mobile account is much smaller than that of the weekday online DB 30, the processing time of the selected batch processing is completed in a shorter time than the batch processing time of all data.
At this point, the contents of the weekday online DB 30 reflect all the batch processing results and the online processing results. FIG. 4F shows the result of the selected batch process. Here, the results of the withdrawal transaction and the interest principal addition process by the online process are recorded.

By processing as described above, in Sunday banking provided with the holiday online DB 31,
Batch work that could only be executed at night after the balance of the weekday online DB 30 was settled can be executed during holiday operation.

FIG. 5 is a processing explanatory view (No. 3) of the data updating system according to the embodiment of the present invention, which is a time chart of the online banking system on holidays. Starting the business from 8:00, first perform the holiday file creation processing, create the holiday online DB31, start the holiday online processing from 9:00, and start the weekday online D
The batch process for B30 is executed in parallel. 16: 3
The batch processing ends at 0, the holiday online processing ends at 17:00, the holiday variable copy processing and the selected batch processing start at 17:00, and the processing ends at 18:00.

According to the conventional method, it was necessary to carry out the batch processing for 7 hours and 30 minutes for the weekday online DB 30 after the holiday online processing was completed at 17:00. The costs (machine time, personnel costs) related to center operation can be significantly reduced.

Further, in this embodiment, the holiday online DB 31
Was created by extracting the data required for holiday online processing from the weekday online DB30.
The creation method of is not limited to this, and the weekday online DB 30 may be simply copied.

Further, in the above embodiment, the holiday online D
Weekday online D for batch processing of B31 holiday transfer account
Although it was carried out after it was selectively copied to B30, it is also possible to carry out batch processing on the holiday online DB31 only for fluctuations and then selectively copy it to the weekday online DB30.

Further, in the present embodiment, the updating target is the banking business, but the present invention is not limited to this and is effective when applied to an online real-time computerization system of another industry.

[0027]

As is apparent from the above description, according to the present invention, the update time of the online DB used in the online banking system or the like can be shortened, and the cost (machine time, personnel cost) related to the operation of the center can be reduced. There is a remarkable industrial effect that it can be greatly reduced.

[Brief description of drawings]

FIG. 1 is a principle diagram of the present invention.

FIG. 2 is a configuration diagram of a data update system according to the embodiment of this invention.

FIG. 3 is an explanatory diagram of the processing of the data updating system according to the embodiment of this invention (No. 1).

FIG. 4 is an explanatory diagram of the processing of the data updating system according to the embodiment of this invention (No. 2).

FIG. 5 is an explanatory diagram of the processing of the data updating system according to the embodiment of this invention (part 3).

FIG. 6 is a process explanatory diagram of a conventional database update processing system.

[Explanation of symbols]

10 sub-database 11 database 12 transaction record 20 holiday file creation function 21 online processing function 22 batch processing function 23 holiday fluctuation copy function 24 selective batch processing function 25 transaction call 30 weekday online DB 30a online DB 31 holiday online DB 32 transaction record file 40 Holiday DB Creation Department 41 Holiday Online Processing Department 42 Batch Processing Department 43 Holiday Variation Copying Department 44 Selected Batch Processing Department

Claims (1)

[Claims] [Claim 1] A database (1
A data update system having 1), having at least a processing system for collectively updating variable processing for the database (11), and having a processing system for immediately updating the database (11) when a transaction occurs. , Creating a sub-database (10) from the database (11), performing immediate update processing on the sub-database (10) according to the occurrence of a transaction, and creating a transaction record (12), while the database Batch update processing is executed for (11), the transaction processing is blocked, and then the account updated in the sub-database (10) is completed based on the transaction record (12). A data update system characterized by reflecting in a database (11) and executing a collective update process for the database (11) to the reflected account.