ETL Technology Research And Application In The Control System Of The Securities Risk

Using the ETL technology,risk management control system built a bridge between data warehouse and business systems, makes the business data into the data warehouse, and provided data base for data analysis and display. Through monitoring and audit found that securities risk abnormal situation, achieve the purpose of timely and effective risk prevention. According to the reality of the securities firm, design and implement the prototype of risk management control system.In this paper, the system development and key technology of research work is as follows:(1) Focuses on the ETL technology, according to the stages of data processing to design ETL data model and the data processing flow, and put forward the application solutions of ETL technology in the risk control system.(2)Combining parallel technology and ETL technology, improve the efficiency of processing data ETL technology. Using the corresponding scheduling algorithm allocate resources appropriately to thread, make each server can parallel processing task request.(3)Using Quartz open source job scheduling framework manual and automated tasks, ensure the ELT technology can provide data support for the system in a timely manner.(4)Design the architecture of the securities risk control system, and described the function module of the system. In the implementation process, through the static data and dynamic information inside and outside the enterprise, risk valuation, assessment of business risks, design and implement each module of the system.This system has been used in practice, the research of this topic is ETL technology and risk control concept and an attempt to practice, and provides some ideas for later risk control.