Generalized database system for the central bank of Bangladesh from heterogeneous system of different commercial banks

Abstract

Bangladesh Bank (BB), as a regulatory body and central bank of Bangladesh, collect, filter, organize and process periodical data from different commercial banks operating in Bangladesh for better policy, monitoring and management of the banking sector. There are a number of departments and authorities involved with this process. At present, in most of the cases, all the information is collected manually and stored in separate manual registers, text files and MSExcel sheets in different departments which do not follow a uniform format. This decentralized information is complicated to aggregate for monitoring and policy purpose from a central point. By using current infrastructure it is not also possible for BB to access a heterogeneous banking system where 31 types of banking software are being used with 5 types of databases. To address this problem through a simulated environment a generalized database is designed to collect, filter, organize process and store periodical data in a unique standard format. Proposed system uses the Linked-Server concept of Microsoft SQL-Server to gather data by using distributed query technique. After filtering and processing in SQL-Server, data is exported to the production server of the central bank, which is running an Oracle database management system. Security issues are strictly handled in this regard. Finally, a set of parameterized reports have been designed that can be run from different departments by using central report server and will assist the regulatory body for proper monitoring, control and making policy decision. This system is simulated in the HUAWEI-Lab of the IICT department successfully. Now, with the proper permission of BB and cooperation of different commercial banks, this system can be implemented for the betterment of the banking sector and economy of the country.