The Design And Implementation Of Commercial Bank Report System Based On Data Warehouse

With the rapid development of enterprise business and the rise of e-commerce, all kinds of reporting tools have a broader development prospects and the reporting system is still be in the ascendant at home and abroad. However, as the financial market gradually globalization, banking industry has developed rapidly. Causing an enormous data in the internal and external of the bank every day, the business types are increasingly multifarious. Because of the increasing data in the bank, the traditional business reporting software cannot meet the demand of commercial banks. As a result, the commercial banks should use the advanced technology to transform the business data into the effective information. The managers can use that information leading the enterprise to the better way.Using the data warehouse to the commercial bank report system can improve the quality of the report and make the report mort efficiency. According to the actual situation of commercial banks and technical requirements, we use the oracle database and ETL technology to build the stabile, expansibility, safety and ease to maintain commercial bank report system. With the data warehouse, the report system can offer the users a valuable data.Using the advanced data framework, we trend to build the data integration platform and report system. Based on the data warehouse, the system can establish scientific financial data model and formulate the data standards so that we can monitor the data.Compared to the traditional manual entry, artificial selection and processing method, the system based on data warehouse can process and analyze the data more intelligent. Because of the intelligent analysis, the data become more accurate. And the managers can make a decision depended on the accurate data. So maybe data warehouse can be the standard in the financial market someday in the future.