ERP中BOMDWS系统的设计研究  

Design and realization of BOMDWS system in ERP

作　　者：吕鸣剑[1] 

机构地区：[1]宝鸡文理学院计算机系,陕西宝鸡721016

出　　处：《现代电子技术》2012年第19期123-126,共4页Modern Electronics Technique

基　　金：陕西省自然科学基础研究计划项目(2009JM1013);宝鸡文理学院重点科研基金项目(ZK10167)资助

摘　　要：分析讨论了ERP中BOM管理的特点和存在的问题,提出用数据仓库的理论和思想集成转换原始BOM数据,构建BOM数据仓库BOMDWS进行多维分析。BOM数据仓库的建立解决了数据不一致和"蜘蛛网"等问题,同时为企业的决策分析提供了完整、一致、不同粒度的综合数据。在此基础上,设计并实现了基于J2EE架构的BOM数据仓库管理系统,并介绍了系统的主要实现结果。This paper analyzes and discusses the characteristics and the problems of BOM management, and then proposes the construction of BOMDWS （BOM data warehouse） by using data warehouse theory and idea to integrate and transform the original BOM data for carrying out OLAP. The BOMDWS establishment has solved the problem of the data inconsistency and ＂spider net＂ and provides complete, consistent summary information with different granularity for the strategy analysis of enterprises at the same time. And then the BOM data warehouse management system based on J2EE architecture is designed and realized. And this paper also introduces the main implementation results of the system.

关 键 词：物料清单 企业资源计划 数据仓库 J2EE架构 多维分析 

分 类 号：TN911.734[电子电信—通信与信息系统]