|
|||||
|
|
| 面向流程企业数据仓库的设计与应用 | |
| 引用本文： | 闫伟,童祯恭,廖西亮.面向流程企业数据仓库的设计与应用[J].计算机集成制造系统,2006,12(6):899-904. |
| 作者姓名： | 闫伟 童祯恭 廖西亮 |
| 作者单位： | 1. 山东大学,机械工程学院,山东,济南,250061;同济大学,CIMS研究中心,上海,200092 2. 华东交通大学,土木建筑学院,江西,南昌,330013 3. 山东大学,机械工程学院,山东,济南,250061 |
| 基金项目： | 国家863/CIMS主题资助项目（2002AA412410）. |
| 摘 要： | 建立了应用于某流程企业的数据仓库。首先分析了数据的不同来源，设计了基于此数据源的数据清洗工具，提出数据清洗时遇到的技术问题和解决方案，并着重分析了罩盖技术检查重复数据的过程。采用数据仓库-实体联系概念模型设计了生产费用、油气生产、干气和副产品库存为主题的数据仓库，并用商业智能插件实现了联机分析处理对数据仓库的查询。采用了基于主成分分析和拉格朗日公式的支持向量机方法建立了此公司各产品产量的分析预测模型，实现了用干气预测原料气和副产品的功能，获得了良好的经济效益。 |
| 关 键 词： | 数据仓库 数据清洗工具 罩盖技术 数据仓库-实体联系概念模型 支持向量机方法 |
| 文章编号： | 1006-5911（2006）06-0899-06 |
| 收稿时间： | 2005-03-10 |
| 修稿时间： | 2005-12-05 |
Design & application of data warehouse oriented to process industry |
|
| YAN Wei,TONG Zhen-gong,LIAO Xi-liang.Design & application of data warehouse oriented to process industry[J].Computer Integrated Manufacturing Systems,2006,12(6):899-904. | |
| Authors: | YAN Wei TONG Zhen-gong LIAO Xi-liang |
| Affiliation: | 1. Sch. of Mechanical Eng. , Shandong Univ. , Jinan 250061, China; 2. CIMS Cent. , Tongji Univ. , Shanghai 20092, China; 3. Sch. of Civil Eng. , East China Jiaotong Univ. , Nanchang 330013, China |
| Abstract: | A Data Warehouse(DW) was built in a process industry.Firstly,different sources of data were analyzed and the Extraction Transformation Loading(ETL) tool for DW was designed.Then,the technical problems and solutions encountered in the process of data cleaning were proposed.The Canopy methods to clean reduplicate data were studied in detail.DW with the subject of production cost,output of oil and gas,storage of gas and byproducts were designed by Data Warehouse-Entity Relationship(DWER) model and inquired with On-Line Analytical Processing(OLAP) by Business Intelligence(BI) beans.Finally,the model to predict outputs between products was built by Principal components analysis Lagrange Support Vector Machine(PLSVM) method.As a result,the output of raw gas and byproducts could be predicted by gas. |
| Keywords: | data warehouse extraction transformation loading tool canopy methods data warehouse- entity relationship model support vector machine method |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |