The Design And Implementation Of The Foreign Bank Supervision Data Submitted System

Regulators’ demand of foreign banks data statistics standardized management is higher and higher, they require financial institutions to establish supervisory statistics under centralized management pattern, formulate and implement every data standard and institution. However, with the expansion of banking business, the increase of bank outlets, the process of submission is relying too much on branches, cumbersome process, link is overmuch, new products and business emerge endlessly, the existing management mode can not meet the rapid development of business needs, the standard of reporting is also declining. Besides, many aspects, such as the business logic and system performance, they can’t meet the regulatory requirements and the development of banking business.In order to further improve regulatory statistical data quality, launched by the headquarters of financial management, put forward a kind of banking more proactive "head to head" of the line of the business management mode, established a management architecture, which supervise data from top to bottom, meetting the development of banking business and the needs of the banking regulatory commission data standards. On the basis of this business, by developing a new supervision data submitted system to complete the data submission of head to head. The main content is as follows:(1) Understanding deeply regulatory reporting with data submission of head to head, including the data flow and the business process; learning related knowledge with ETL, designing the ETL architecture of meeting data management component of supervision data submitted system, summarizing principles of its designment and development.(2) According to the architecture of the ETL, the process to submit, Designing overall project, process project and development project of data management component; researching the problem of data storage, then giving the solution of the specific storage and some important database tables.(3) Based on the designment of data management component, grasping the ETL design thought, making the data management component module partition, and implementing every module; at the same time, summarizing some problems in the software development.