Application And Research Of The EDW In Commercial Bank

The Enterprise DataWarehouse(EDW) is important to managing huge data and advanced information and supporting business applicaitons.The Chinese banking attaches more and more importance to the building of EDW ,and has invested much.During the building of EDW,the Chinese banking has attained an abundance of experiences,and improven the methodology and the technology of building EDW. This dissertation is focused on the construction and implementation of Enterprise Data Warehousing to research and summarize, especially the standard process of the building of EDW. Including preparation in advance, business investigation, information investigation, logical and physical design, system structure design, application design, etc. This dissertation shows the corresponding solution concerning logical and physical model design base on an actual implementing. More details are as following:1. The theories of EDW and the technologies of Teradata database,including thekey idea of teradata ,framework and parallel mechanism.2. Make a summary & proposal of optimized EDW standard processes.3. Describe method and procedure for design and implementation of commercialbank EDW logical data model and physical data model.4. The summarization and expectation of the expectation.The main accomplishment is that it sumarize the standard process of EDW,expatiates on the LDM and PDM design and actualizing of bank EDW.And it designs and actualizes a frondose bank PDM.