Based On ETL Technology To Design And Implementation Of The Bank’s Intermediate Business System

With the rapid development of computer technology,network technology and data warehouse technology,it has been widely used in the process of bank information,the design and implementation of the loan management system,cash management system,terminal operation management system,bank office management system,improve the real-time performance and efficiency of the banking business.With the increase of banking business,the management system has accumulated a huge amount of data resources,the bank business management process needs to be based on different business themes need to be a massive data mining,in order to make full use of large data resources for the banking business to achieve information,sharing,standardized management services.In order to improve the integration,sharing and availability of the banking system,this thesis presents a data warehouse management system,which can improve the system’s development efficiency,realize a visual operating interface,and can be easily implemented and popularized.The system can be improved by using B/S system.The main research contents include the following three aspects: first,the overall needs of the banking system,the application status of the intermediate business system,the use of the waterfall model,prototype system software engineering method to analyze the system function,and from the system security,data consistency,high efficiency processing performance analysis,and the feasibility analysis,feasibility analysis results verified the design and implementation of intermediate business system is feasible.Two is the server deployment architecture and system architecture,using structured process technology to the system function module design,describes the system data flow diagram and module flow chart,gives the system key algorithm,using E-R diagram and relational table design system database.The three is to describe the implementation of the system,the use of Java technology to achieve the system of the front interface,and the use of the system to achieve the core code.The intermediate business system of the bank can be independent of the information processing and optimization,the output of the intermediate business report,in order to be able to use,so as to promote the sustainable development of thebanking information technology.At the same time,the system can realize the visualization platform of business operation,and can be very good for the promotion of intermediate business system,which has high practical value.