Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Computer Engineering》 2006-01
Add to Favorite Get Latest Update

Research of Database Design and Algorithm of Pharmacy BOM

ZHANG Cuili,ZHANG Shensheng,LI Lei(CIT Lab,Department of Computer Science & Engineering,Shanghai Jiaotong University,Shanghai 200030)  
The Bill of Materials(BOM) plays a very important role in ERP system.The BOM used in pharmacy has its own features beyond the general ones.Based on analyzing its characteristic,this thesis introduces the sound design of database system about pharmacy BOM and efficient algorithms of calculating materials’ low level code,disassembling products and disassembling tasks.The algorithms are implemented as store procedures.
【Fund】: 浙江省重大科技攻关计划资助项目(2003C11009);; 上海市科委科技攻关计划资助项目(03DZ19320)
【CateGory Index】: TP311.13
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 2 Hits
1 YANG Shan-lin,ZHUANG Xue-xian(Department of Manage,Hefei University of Technology,Hefei,Anhui 330009,China);Application of MySQL Stored Procedure in BOM[J];Computer and Information Technology;2007-06
2 XU Yan-bin, YU Ding-wen, ZHANG Jian-fu (Department of Precision Instruments & Mechanology,Tsinghua University,Beijing 100084,China);Research of the material requirement model and algorithm in pharmaceutical Industry[J];Machinery Design & Manufacture;2008-02
【Citations】
Chinese Journal Full-text Database 1 Hits
1 JIAO Wen bin, GONG Jun, WANG Ding wei (School of Information Science & Engineering, Institute of System Engineering, Northeastern University, Shenyang 110004, China);Algorithm of BOM Level Code Based on Store Procedure[J];Basic Automation;2003-01
【Co-citations】
Chinese Journal Full-text Database 10 Hits
1 Guo Lei(College of Economy and Management,North China University of Technology Beijing 100041);Research on the Inventory Management of the Raw Material in Moderate and Small Manufacturing Enterprises[J];Journal of Beijing University of Civil Engineering and Architecture;2008-01
2 DING Hui-ping(Economic and Financial Institute,Xi'an Jiaotong University,Xi'an 710061,China);RESEARCH ON WEB-BASED MATERIAL REQUIREMENT PLANNING INTEGRATED APPLICATION[J];Journal of Beijing Technology and Business University(Natural Science Edition);2006-01
3 YE Hong-zhao,SUN Yi(Zhejiang Institute of Mechanical & Electrical,Hangzhou 310053,China);Research and Application of MRP Algorithm Based on Double-layers Separative BOM[J];Group Technology & Production Modernization;2006-04
4 DING Dan-chen (School of Software,Southeast University,Nanjing 210096,China);Research and Implementation of Manufacturing MRP System[J];Group Technology & Production Modernization;2008-02
5 WANG Jun,MA Ke,YANG Cheng-tao(Xi'an Sci-tech Engineering College,Xi'an 710048,China);My Tentative View on China Enterprise Resource Planning and the Execution thereof[J];Textile Accessories;2006-03
6 Li Yan Hu XiaoLi Huang Jingsong (Jingdezhen Ceramic Institute, Jingdezhen 333001,Jiangxi);The Discussion of ERP[J];Computer & Telecommunication;2007-11
7 Wu Zheng-jia,Wang Wen,Zhou Jin(College of Mechanical & Material Engineering,China Three Gorges Univ.,Yi chang 443002,China);Application of BP Neural Network to Sale Forecast for Make-to-Stock Enterprise[J];Industrial Engineering Journal;2010-01
8 LIANG Liang , PU Xu-jin,TANG Lin-bin ( Business School , University of Science and Technology of China , Hefei 230026, China);Study on the Policies of Several MRP Systems Corresponding in the Environment of SCM[J];Policy-making Reference;2003-06
9 ZHANG Yuan,CAI Zongyan(School of Mechanical Engineering,Chang'an University,Xi'an 710064,China);Research on Structure Design and Algorithm of BOM for ERP System[J];Machine Tool & Hydraulics;2008-01
10 ZHANG Wen-jian, LIU Pei-yue (Electric Power North China University, Baoding 071003, China);Advanced Production Pattern of Manufacture Enterprise[J];Development & Innovation of Machinery & Electrical Products;2004-01
【Co-references】
Chinese Journal Full-text Database 5 Hits
1 Dai Debao Chen Rongqiu College of Management, HUST, Wuhan 430074, China.;Improvement of the Arithmetic for Material Requirement Planning[J];Journal of Huazhong University of Science and Technology;2001-02
2 Yu Ruilin Wu Shunxiang (Department of Automation,Xiamen University,Xiamen 361005);A Kind of Improved Algorithm for the BOM Expandedness and LLC Calculation[J];Computer Engineering and Applications;2005-27
3 Wang Jian Shen Hong (Department of Computer Science and Engineering,Xi'an Institute of Technology Xi'an 710032);Research on Structure of Network BOM in ERP System[J];Computer & Digital Engineering;2005-07
4 ;The System Analysis of an Pharmaceutical Enterprises' Material Requirement Plan System[J];;1999-01
5 Ren,Rongsheng Xu,Jianliang(Computer Department,College of Information,Ocean University of China,Qingdao 266071,China);The Modeling and algorith Of algorithm of BOM In Manufacture Enterprise[J];;2006-27
【Secondary Citations】
Chinese Journal Full-text Database 2 Hits
1 Zhang Xuehong; Wu Tao ;Hu Linping(Aeronautic Compting Technique Research Institute, Xi'an 710068);An Automatic Generation Algorithm on Product Hierarchy Structure in BOM[J];AERONAUTICAL COMPUTER TECHNIQUE;1998-03
2 Wu Wuze; Chen Rongqiu(Central China University of Technology,Wuhan 430074);A Way to Caculate Level Code Based On Virtual Linked List[J];COMPUTER ENGINEERING AND APPLICATIONS;1999-04
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved