| Data warehouse has been developed in domestic commercial banks for more than ten years,since it was first used in large state-owned commercial banks,and now it has been everywhere in city commercial banks.Most of the commercial banks to build data warehouse system from scratch are based on the model of Corporate Information Factory,they use normal form modeling technology to design data warehouse model.The model has the obvious disadvantages.For example the model is too abstract,and the processing is inefficiency etc.So the commercial banks need a new data warehouse model to adapt to the development of new business requirements.To solve the above problem,this dissertation designs and implements a data warehouse system in dimensional modeling technology based on the data warehouse requirement of a commercial bank.In the implementation of the whole data warehouse system,this dissertation mainly uses the idea of software engineering to carry out the unified development of the system.Firstly,according to the business requirements of a commercial bank,this dissertation carries out the requirement analysis to determine the function of the system.Secondly,this dissertation constructs the overall framework of a data warehouse system by designing the logical architecture and data architecture.Finally,this dissertation uses dimensional modeling technology to build a multi-dimensional data model on Greenplum database,and completes the design of physical model,the ETL of data and the functions of data applications with a variety of tools.Through the research of this dissertation,we expect to obtain a more practical commercial bank multidimensional data warehouse system.And then change the model design form and thought of the former commercial bank data warehouse,to solve the series of problems caused by normal form modeling.Finally we expect can provide some reference for construction of the next generation commercial bank data warehouse. |
PDF Full Text Request