Design And Implementation Of Bank Branch Data Open Platform

Current bank development strategy gradually transfer to the branch line,with branches of fine management requirements to improve,also branch demand has data demand for personalized,front-end access demand high concurrent,functional requirements of operational and analytical balance characteristics.Branch of the more concentrated and urgent need is the core of the data can not meet the needs of the business decision-making data,the head office issued data warehouse data.For new data integration and application of the new normal,how to continue to do a good job of data service requirements is a key foundation for the opening of the value of the branch data.Paper around the goal of open data requirements,involved in the construction of branch data open platform key technique is studied and put forward a not directly issued by the opening of branch data architecture,the architecture to data warehouse based data environment,in the common needs and the headquarters of unified development based on Support Branch characteristic and demand of the rapid development of response,to innovate the management pattern and the data structure to improve branch independent data service capacity,by opening a branch of data to meet the branch management and customer marketing and regulatory filing,management evaluation analysis various data analysis applications.The main work of this paper is as follows:1)separation of batch data processing and query environment.In data warehouse Teradata data environment for summary data processing,the processing results import branch independent data open environment branch data model for branch business users access.Meet the data does not need to be open to the needs of the data,to avoid the data sent to bring the data security risks.2)relying on the head office data warehouse and data mart and take reports fixed and random query and regulatory data access to a variety of forms,such as,support branch including flexible business management decision-making,business marketing,management assessment,regulatory submission and historical data verification,and other types of characteristic data needs.3)branch data open platform functional requirements was described in detail,system use case,design the system architecture,ETL design,database design and system process design,and gives the platform implementation environment,interface design and data open to the testing process.Through this topic research and test,to get the final platform to avoid data issued brings hidden trouble of data security;to meet the flexible branch of characteristic data needs;and has significantly improved data monitoring and allocation of resources advantage.