The Design And Realization Of The Data Acquisition And Processing Subsystem Of CCPAS

Cost control belong to the scope of management accounting, and broad cost-control means the control of production and operating costs of all aspects and at all stages. It includes all the efforts to reduce costs and is synonymous with cost management. Therefore, in this sense, the cost control of commercial bank should be carried out all-round in the whole process. Agricultural Bank of China is one of the four major state commercial banks, and provides more types of business. In order to meet the needs for staff evaluation, as well as the implementation of the development of product differentiation in a highly competitive market environment, the bank should set up an information system for all-round, multi-dimensional cost-benefit analysis. In this paper, I do the analysis, design and realization of the Cost Controlling and Profit Analysis System from the perspective of software engineering.This paper analyzes the management informationization status quo of domestic and foreign banks and pointed out the problems in the commercial banks management as well as the need for management informationization. The problems include the following. The cost-benefit data is lack, staff performance can not be accurate evaluated, income and spending brought by customers or products can not be accurate evaluated, the bases for forecasting market risk are lack and scientific decision-making can not be made.To deal with the problems as well as learning from foreign advanced business intelligence ideas, this paper put forward that there should be a business intelligence system based on data warehouse for helping the decision-makers to improve management and decision-making efficiency. In order to realize the process that from data to information then to knowledge which described in business intelligence the paper set the goal of the system and then put forward a total solution which use data warehouse, ETL and J2EE technology. On this basis, the system is divided into two sub-systems, one is Data Acquisition and Processing System and the other is Data show subsystem. At the same time, the functional structure of the system security problems are also be discussed. Then each of the two sub-systems is detailed designed. I use data flow chart to discuss the Data Acquisition and Processing subsystem and use UML to discuss the Data show subsystem. Then I did the database design. Because there is no different between the realization of Data show subsystem and other J2ee-based systems, the paper has discussed the Data Acquisition and Processing subsystem more.The system builds a data warehouse from the existing production systems with business intelligence idea to process the data into useful information. This helps the bank policy makers to understand the bank operations and make future policy. After the implementation of the system bank management has improved as the decision-making is based on accurate data. The cost has been reduced and the market competitiveness has been improved. At the same time, the system is conducive to improving the quality of bank assets and the level of risk control.