The Design And Realization Of International Settlement Reporter System

With world commerce continued and rapid development, the international settlement becomes more and more important. Along with our country joins the WTO, the financial market further opening up, and gradually tied to the international market, which brought both opportunities and challenges to the financial industry in China. In order to adapt the new market demand, the banks which in China have developed their own international operations early or late. However, at present, compare to the developed countries, there is still a lag in the international business level of ours by all means. To promote the financial industry for further development in international business, accelerate the convergence of international financial markets, and provide better service for customers, and strengthen the competitive ability in the international financial market. By analysis of the domestic and foreign products, the commercial bank introduces IBS system which developed by the third part Corporation, and combined with China actual situation and the bank's international settlement business needs, carried on the localization development, researches and develops an international settlement system what suited to Chinese national conditions.The system use TD as development platform, base on Oracle database widely used. This reporter subsystem is integrated with the system itself, and also uses the TD as development platform, using the Oracle database to store data.The reporter subsystem integrated with the application system, does not need the individual server, can shared the application server cluster ability and the connection pool management; Unified deploy to uses the user role management mechanism which in the application system directly, so the two management mechanism will not have the compatible question. Providing the uniform login surface, the end-user does not need to register twice. The accurate and effective report data can automatically generated from the business data, does not need the layers of reporting summary; the report data can be batch built in the idle time, to avoid impact on producing system.Taking into account the complexity of international settlement service rule, the report data must be produced through the complex computation, therefore, using the Oracle store procedure to carry on the statistical data in this report subsystem;In order to display the complex form report, this report subsystem use html template which compatible excel to custom-made various types of report. It not only can view on-line report, but also can preserve and see the report document off-line. And can transform to the excel form for editorial revision.Along with the international situation unceasing change, the international service continuous development, the emerging international service varieties increasing, as well as the business analysis request to bank unceasing improvement, supervising and managing of the relevant government agencies strengthening, it will be have more and more report demand, the system must conform to the form, providing more reports. System design will be able more and more complex, the system pressure also will increase. Therefore, the future system needs to continue to carry on the optimization, and eventually realize the system to have the powerful functions, so be able to guarantee the system highly effective and stably moves.