Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Mechanical Science and Technology for Aerospace Engineering》 2009-10
Add to Favorite Get Latest Update

Design and Implementation of Data Warehouse for Workshop Assistant Decision-making

Zhang Cuilin1,Wang Rui2,Sun Qiang3,Wang Junqiang3(1Department of Economy and Management,Xi′an Aerotechnical College,Xi′an 710077;2Software Technology Institute,Dalian Jiaotong University,Dalian 116028;3Key Laboratory of Contemporary Design and Integrated Manufacturing Technology(Northwestern Polytechnical University),Ministry of Education,Xi′an 710072)  
First,the function model of workshop assisted decision-making data warehouse(DW) is analyzed based on the requirements of the workshop decision level.Then,the dimension models of four data marts(DM) for manufacturing process,tools,materials and semi-finished products are established.Finally,the online analytical processing(OLAP) method based on BOM(bill of materials) tree is presented.The finished data warehouse has been successfully used in a workshop decision support system,which shows that the design of the workshop assistant decision-making data warehouse is feasible and effective.
【Fund】: 国家自然科学基金项目(50705077);; 陕西省自然科学基础研究计划项目(2009JQ9002)资助
【CateGory Index】: TP311.13
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【Co-citations】
Chinese Journal Full-text Database 1 Hits
1 ZONG Lian-song(Dean's Office of Xihua University,Chengdu 610039 China),PAN Hua,et al.;Design of Management Information System Based on Component Technology[J];Journal of Xihua University(Natural Science Edition);2006-04
【Co-references】
Chinese Journal Full-text Database 3 Hits
1 YIN Wen1,2 (1.Post-doctoral Work Station,Shengli Oil Field,SINOPEC;Dongying 257002,China;2.Shandong Dongying Vocation College,Dongying 257091,China);A Study and Application of Data Mining Technology to the Decision Support of Oilfield Production[J];Shandong Science;2009-01
2 Cui Chuanzhi. Eastern China Petroleum University,;THE DEVELOPMENT OF RESERVOIR PERFORMANCE ANALYSIS SOFTWARE[J];Computer Applications of Petroleum;2003-02
3 FENG Mei-rong1,WANG Zong-yan2(1.Technology Exchange Center of Taiyuan,Taiyuan 030009,China;2.North University of China,Taiyuan 030051,China);The Application Research of Data Warehouse in Governmental Decision Support System[J];Journal of Taiyuan University of Technology;2008-05
【Secondary Citations】
Chinese Journal Full-text Database 1 Hits
1 ZHU Tian-xiang; LI Li; XU Zhan-wen(College of Information Science and Engineering, Shenyang Polytechnic University, Shenyang 110023, China);Technology for mining ciassification-characteristic rules[J];JOURNAL OF SHENYANG POLYTECHNIC UNIVERSITY;1999-06
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved