China Agricultural Development Bank favored its technical advantages by adopting DB2

The Agricultural Development Bank of China uses the IBM DB2 database system. Its cross-platform openness and scalability are the main reasons for attracting the Agricultural Development Bank of China, the Agricultural Development Bank of China has established a nationwide general statistics management information system.

China Agricultural Development Bank is a newly established National Policy Bank in 1994. So far, it has 35 branches, more than 300 regional branches, 1617 county branches, and total assets of nearly 800 billion RMB. With the increasingly fierce competition in the domestic financial industry, major banks have begun to use modern scientific and technological means to improve information acquisition, transmission, and processing methods and improve the level of customer service. The Agricultural Development Bank of China also decided to use the IBM DB2 database to establish a nationwide general statistics management information system.

Before the establishment of the system, the Agricultural Development Bank of China has been using the network transmission business data of the Agricultural Bank of China. From a management perspective, reporting business reports is inconvenient and a large amount of usage fees are required each year. Due to the large number of bank outlets and wide distribution, the daily delivery of reports is time-consuming and laborious, and report delivery Errors often occur, which brings a lot of inconvenience to the daily work of banks. In addition, decision makers cannot grasp the banking business conditions in a timely manner, which brings great difficulties to scientific decision-making.

In order to change these situations, which are difficult to adapt to the banking business situation and seriously impede the electronic financial process, the Agricultural Development Bank of China decided to establish a management information system covering the entire bank. After repeated comparisons between several famous companies at home and abroad, we finally chose the IBM DB2 database.

The primary reason for choosing an IBM DB2 database is its outstanding cross-platform openness and scalability. It supports the most popular operating platforms in the industry, so that the system can be easily upgraded in the future. Currently, the Agricultural Development Bank of China uses RS/6000 as the data volume is not large. With the rapid growth of data volume, you may need to upgrade to a large host. The source code of the database can be smoothly transplanted to the new hardware platform without modification. This greatly reduces the workload of secondary development and effectively protects initial investment.

In addition, the IBM DB2 database has good portability and can support other mainstream databases. Oracle, SyBase, Informix, and other databases can be smoothly transplanted to the DB2 database, the Bank's original data resources were fully utilized.

In addition, the DB2 database manages massive data. As the fastest database in the world, it can complete more than 90 million text searches in a day, and each response time is less than half a second. In addition, compared with competitors of similar products, it is faster, cheaper, and highly cost-effective.

With the help of IBM technicians, it took less than a year for the Agricultural Development Bank of China to build a full-row management information system. Zhou zhiduo, Chief Engineer of the Agricultural Development Bank of China, said that many difficulties have also been encountered in the system implementation process. For example, in the overall design, all 2000 management institutions in the system have established local area networks, connect to a wide area network. This is not realistic for the newly established grass-roots banks to adopt the C/S structure in the absence of technical staff and poor office conditions. To this end, developers creatively install servers and clients on a PC, and use the "All-in-One" machine to implement the C/S structure, saving both investment and, it ensures normal data transmission. There are still many such examples. the developers of the Agricultural Development Bank of China have made full use of the technical advantages of the DB2 database and developed new applications based on the characteristics of their own units to overcome various technical difficulties, this ensures the smooth completion of the system.

The Management Information System of the Agricultural Development Bank of China has been put into use for three years, greatly improving the efficiency of the bank. It takes only a few days for the report data that can be obtained in the previous month. At the same time, the data reliability has also been improved, and the leaders of the bank have a more accurate and timely grasp of the business of the whole bank, providing a powerful guarantee for scientific decision-making. Based on the successful operation of the management information system, the Agricultural Development Bank of China plans to develop it into a general management system so that it can share its successful experience with more companies.

Zhou Zong, an engineer at the Agricultural Development Bank of China, concluded that the biggest advantage of IBM DB2 database is its outstanding cross-platform and scalability. The source code of applications can be consistent on both the mainframe and minicomputer. The Agricultural Development Bank of China is considering further using the Bi solution of DB2 Universal Database to expand the entire system into the highest level of information system with decision-making as the core, provides more effective data analysis for scientific decision-making.