Browse Prior Art Database

Real time deferred process on banking online system Disclosure Number: IPCOM000190057D
Original Publication Date: 2009-Nov-16
Included in the Prior Art Database: 2009-Nov-16
Document File: 2 page(s) / 71K

Publishing Venue



Disclosed is a method to transfer the transaction log originated in the online core banking system to the information processing system (IPS) and build the IPS databases such as Data Warehouse based upon the content of the transaction log in real-time basis.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 46% of the total text.

Page 1 of 2

Real time deferred process on banking online system

In the global depression of these days, the quality of the customer information held by the financial institution is needed to be improved much more to a great extent. Transaction information on a huge quantity generated on real time - how fast and how effectively this information is integrated with the system would be very important key to success of the financial institution. To realize this, many financial institutions take the transaction information (hereafter, transaction log) from the data source such as the core banking online system, transfer it to other system - so called, the information processing system (or abbreviated as IPS), and then build the data warehouse from the transaction log so that it can be used for the sales support activities.

From the second half of the 80s, in order to develop the database build system for the financial institutions' IPS, so called the Deferred Process has been introduced and installed in many financial institutions. However, since these systems transfer the transaction log in the DISK by the Batch process with the constant interval, it took several minutes to several hours to reflect the information of transaction log in the IPS database. For the application which needs the information as much as similar to the core banking system such as the Loan application, this delay of the reflection to the IPS database cannot be allowed. So, to avoid this, these kinds of applications exceptionally refer the information of core banking system directly.

The current art to solve this problem is that the request/reply typed online processing system (such as core banking system) writes the transaction logs to the transaction journal file, and if the volume of the written logs gets reached to some amount, the transaction message is triggered so that it can invoke the non-reply typed online processing system (such as IPS). (Toku Kai Hei 7-15284) This method enables to build the IPS database without the batch process, but, since the update of the IPS database starts after some volume of transaction logs get accumulated, this still does not solve the delay of the reflection (from the core banking system to the IPS database system). The author invented the method to solve this problem, and verified its ability to realization.

The current art transfers the transaction log recorded in the DISK by the core banking system to the IPS database platform through the component which monitors and controls the transaction log. This method definitely causes the delay the transfer from the core banking system to the IPS database platform. Our invention writes the transaction log from the core banking system into Queue instead of DISK, and the IPS reads the transaction log from Queue. This minimizes the delay by monitoring/controlling of transactio...