摘要
数据仓库技术能跨越多个应用系统,集成、转换和汇总所需要的数据,表达完整的数据视图,并通过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.
出处
《烟草科技》
EI
CAS
北大核心
2007年第6期31-34,共4页
Tobacco Science & Technology
关键词
工业企业
数据仓库
数据建模
联机分析处理
Industrial enterprise
Data warehouse
Data modeling
OLAP (Online Analytical Processing)