| The development of the comprehensive statistics report building system(A Certain Commercial Bank) is a foundation of common report for commercial banks, and is also an automatically information foundation of comprehensive statistics for commercial banks'decision-makers and leaders. Especially used in intellective management and decision support. The purpose of this report building system is automatically collect business data of every system for the commercial banks, then create a foundation to cover all the business data (including collect, storage and processing), to carry on statistics collecting. In order to achieve automatically statistical all business data, generate the report, and sharing data resources for"T+1"days in the commercial banks.Along with the information technology improvement, when the people using IT system, they hope the IT system can provide more and more information. The function of statistics report flexible inquiry OLAP analysis and etc. are occupying more proportion. At the present time, banks'information system gradually to: 1.business system, management system support to ensure business work on smoothly. These systems can make data and output all kinds of business data. 2. Every kinds of analyzed system provide data support to different business staff, analysis staff, and leaders for making decision. These systems can not produce data, but they can process all kinds of business data, and flexible emerge these data. Then directly used in enterprise management and business guide. Integrate the two systems in order to make up smooth loop of internal information. It means that the business system, the management system and etc. continually produce data in business operation; these data enter analysis system to carry on drastically process, finding loopholes in the business system and the management system. Then it can indirectly or directly provide management decision, optimizing the above two system.However, in business banks, business staffs need to manage data and make report. Along with more and more data need to process cause more cost to collect and process huge data in the business operation. Along with the various data is used in business banks in large-scale, it is a very important task that how to use improved internet technology to achieve automatic data collecting, and also develop one system for report building and inquiring in a very short time. Therefore, we need to build up a report aggregation to satisfy the bank's development, management, strategy decision, information publish, outside control, and audit. On this base to achieve a standard of interrelated target's collect, process, storage, increase/decrease, customize, issue, authorize, inquiry, and to use. Then to improve data management level, tamp basement of intelligent management in the business bank. We are urgent to achieve concentrated management of report building, liberate human resource for drawing up report, increase the effective of information application, neutralize the contradiction of data's needs and wants, decrease report management cost. Face to these urgent needs, using computer to manage automatically can help to overcome these difficulties. Computer management information system can improve the automatic level of data collecting and report establishment. Then to increase the effective of information exchanged, save large human cost, matter cost and money as well. Therefore, operation management can be more scientific, operating situation is more detail and correct.Follow the above background, this paper is to research, design the comprehensive statistics report building system and to emphasize the system's technology stage, structure and achievement plan. Start from the system structure, data plan, and internal data process, design program for database, operation management working station, reporting inquiry, system management and data input. Then, achieve the research result of the comprehensive statistics report building system and its implement. The implement of this system is based on Browse/Server mode, using JAVA as the main exploit language, using JDBC to access database, using PL/SQL to develop storage of database, using VB to develop operation management mode (C/S structure), using COGNOS of IBM to bring out report. The service of database is used with Oracle10G as the service system for database; the servers are connected with Oracle JDBC Driver. Using IBM WebSphere6.0 as the midbody for system exchange at the server terminal, through local pipeline to achieve effective trade inquiry.The comprehensive statistics report building system need to follow the principle of"flow bank"concept and"whole organization cover"to design and plan, provide statistics reporting analysis function for business banks, achieving automatic management of reporting business and one-step service. The system is equipped with exchange function between human and the computer, and user friendliness & convince as well. The system is also equipped with high suitability of business. The system is designed with the principle of"first computer working, second manual working", so the produce of the report can adapt to internal management and external control in the business bank.The comprehensive statistics report building system overcome the problem that the high leaders of the business bank cannot gain the data promptly. The system overcome the difficulty of huge organization when the leader is analyzing business and making decision, they can expediently gain management information whatever they want. The system also resolve the problem that dispersive information and hard inquiry. The problem of dispersive user and rights limits management are overcome as well. Through uniform user system and rights system, and share this information, users can start working conveniently when they check one kind of business report.The comprehensive statistics report building system will strengthen operation management for the business banks. Fully use of business data can provide timely, correct, and full-scale information support for management and decision-making. It improves the management, control and cooperation of every parts of one bank that the whole bank's operation management will be more scientific, more effective, and more standard. The system provides many tools of scientific management decision, and flexible processing, it helps every bank staff gain the information what they want, timely feedback and moving control. This system can achieve non-paper work so that in daily business processing, the cost of paper can be saved, the number of print can be decreased. Therefore, the general cost of operation of the business bank will be final reduced. |
PDF Full Text Request