The Design Of Hunan Tobacco Data Center System Based On Data Warehouse

According to the construction architecture requirements of Chinese tobacco industry data center, the data center system of Hunan tobacco to achieve the following objectives:guarantee of various business system data upload, support the establishment of new type of business relationship; the tobacco business data for rational planning, built based on different business subjects in the high level data application environment; service industry economic operation, improving industry management.Therefore, this paper studied the Hunan tobacco commercial system information resource service system and data integration and exchange mode and data storage mode, the system uses the data warehouse technology as a core technology. Hunan Tobacco Bureau data warehouse architecture using operational data store (ODS), (DW), data warehouse data mart (DM), a multidimensional database (OLAP online analytical processing), meta database five layer logic architecture; around the city tobacco board using data warehouse (DW), data market (DM), a multidimensional database (OLAP) of the three layer logic framework design. In the province to build the province’s focus on data exchange platform, through the SYBASE ETL tools on the city and province bureau’s own data filtering, washing and converted into the province of ODS, and then distributed to the city of data warehouse, so as to ensure that the provincial and municipal levels, the data in the data warehouse consistency and accuracy; at the same time in the provincial focus building element database, centralized storage of the technology and the business metadata, above the development of metadata management platform and data quality management platform, convenient for unified metadata management and data quality control. The developed data center system in Province Bureau and municipal operation experiment, can satisfy the design request.