福建烟草数据中心数据质量监控技术应用

The application of data quality monitoring technology in Fujian tobacco data center

以推广福建烟草数据中心应用及提高系统数据质量为目的,结合福建烟草商业公司数据中心平台营销、专卖、物流、人力劳资、综合计划等多个部门的业务主题建设与分析应用项目的具体需要,研究并提出了一种合适的数据中心数据质量监控方法。该方法首先在保证数据质量的前提下成功将烟草公司源系统数据抽取到省公司数据仓库中,然后在数据集市层主要利用星型关系完成数据模型设计作业,最后在BI应用中分析与展现了数据。该方法对整个数据中心的高效应用起到了至关重要的作用。

In order to promote and improve the quality of system data application in Fujian tobacco data center, a suitable data quality control method was proposed which combined specific needs of main business construction and various projects, such as marketing, monopoly administration, logistics, human capital, integrated planning. Data from source system of tobacco companies were extracted to data warehouse of the provincial company to ensure data quality. Data model was designed mainly by star model in data mart layer. The collected data were then analyzed and displayed in BI application. It is concluded that the method can play an important role in enhancing the whole DC project efficiency.