The Design And Implementation Of ETL In Data Warehouse Of Postal Name And Address Information

With speeding up of postal information system construction and increasing of network applications, it is necessary for postal business development to build a name and address information system with massive data, high quality, scientific classification, broad covering and usage facility. It is also the basis and valuable resource of postal sustained and healthy developments.Building postal name and address information system should depend on postal integrated information network. It should also take the address as the foundation, the customer's name and address information as the core, integrate all kinds of postal business data about name and address, extract and enrich name and address information with high quality. Name and address information data warehouse, especially design and implementation of ETL is the key to guarantee information's validity and value.This paper concerns about analyzing and designing data warehouse construction strategy , and it emphasizes designing and realizing ETL process according to ETL project method. The main contents of this thesis is as follows:Data warehouse basic theoryCharacteristic and function of TeradataOverall demand analysis of postal name and address information systemdesign and realization of ETL: including design of ETL process , preparation of ETL environment, establishment of ETL Automated flow, ETL job, ETL test and application, ETL daily administration.This system has already been successfully used in China Post, it supports powerfully the development of postal business such as commercial correspondence by supplying information, improves postal system running efficiency and service quality, it also gradually becomes basic information resource of national economy, and has gained great social benefit and economic benefit.