The Design And Implementation Of Unusual Transactions Monitoring System For Interbank Market

With the rapid development of China’s economy, the interbank currency market, as core of the financial market system, is nowadays increasing siganificantly in number and size of transactions. Electronic trading system accounts for more than90%of the trading volume throughout the whole interbank currency market. While the electronic trading system provides financial institutions with a convenient and efficient means of trading, it also brings a series of problems and risks. Thus, according to the People’s Bank of China, in order to maintain the stability of interbank market, monitor unusual transactions and combat illegal trade practices in time, the China Foreign Exchange Trading System need to develop a special monitoring system to screen and monitor unusual transactions in the interbank currency market.The Unusual Transactions Monitoring System of InterBank Currency Market consists of five main modules, namely abnormal data filtering, report forms exporting, parameter setting, system management, and emergency operations. This system is a traditional Java Web project, of which the technical difficulty and key point are Oracle procedures. Nowadays, large enterprise systems often use Oracle procedures to carry out database related operations, due to the performance advantages of Oracle procedures in dealing with complex business requirements. The Unusual Transactions Monitoring System is no exception. During the actual development, we did sufficient performance tests for each function point. From the Service layer to the SQL statements, we conducted a series of changes, to minimize the number of interactions between Java client and database and improve the efficiency of the SQL statements; In addition, one of the function points, Trading Strategies Filtering Of Bond Market, has very complex filtering logic, large amount of data to process, and filtering parameters taking effect immediately. We adopted multi-task parallel processing technique in the corresponding procedure, and added in necessary LOGGINGMESSAGEs to record the execution time of each sub-process. Via this way, we conducted comparative analysis of the response time changes before and after parallel processing, until the final performance meet customer’s demands. Put into use in November,2011, the Unusual Transactions Monitoring System is now in its2.1.2.0version. This article will mainly describe the requirement analysis, design and implementation of five new functions in this version. These five functions help screen and monitor transactions via different abnormal indicators such as leverage ratio and transaction size. According to the above, the Design and Implementation of related Oracle procedures will be the focus of this article.