Data Warehouse Applications, Data Center In Jiangxi Tobacco

The Decision Support System is widely discussed recently. The management that needs mass data for decision is still a bottleneck, it has not been effectively solved.This thesis applies the data warehouse theory that sprung up in 90s' as the solution of data management in DSS, and carries out thoroughly the research for the effective combination of the DSS and data warehouse technical. On this foundation, with the background of Jiangxi tobacco data center construction, we design and implement a data center system of Jiangxi tobacco based on data warehouse.The major research work and achievement of this thesis are:1)The architecture of data warehouse and the related technology are discussed;2) Focus on the data extraction, clean up and transformation technology;3) Analyze the method and the related technology in the important function and realization of the application OLAP of data warehouse;4) Design and implement a data center system of Jiangxi tobacco based on data warehouse.