卷烟工业企业的数据仓库构建方法

Establishment of Data Warehouse in Cigarette Industrial Enterprise

数据仓库技术能跨越多个应用系统,集成、转换和汇总所需要的数据,表达完整的数据视图,并通过OLAP技术提供各种数据分析手段。数据仓库的体系结构包含4个层次:数据源、数据的存储与管理、数据访问服务、数据展现分析;数据建模包括概念模型、逻辑模型和物理模型设计,并构建了卷烟工业企业数据仓库的架构,以及在此基础上建立了企业级数据仓库BW系统,实现了企业数据的全面共享。

The data warehouse technology can integrate, transform and collect data crossing manifold application systems, express entire data views, and provide various data analysis means by OLAP technology. The configuration of a data warehouse system contains four levels： data source, data storage and management, data access service, and data display and analysis. The data modeling includes concept model, logical model and physical model design. The framework of data warehouse of cigarette industrial enterprises was constructed, basing on that, the BW （Business information warehouse） system was also established, and the common data sharing within an enterprise was realized.