購(gòu)買設(shè)計(jì)請(qǐng)充值后下載，資源目錄下的文件所見即所得，都可以點(diǎn)開預(yù)覽，資料完整，充值下載可得到資源目錄里的所有文件?！咀ⅰ浚篸wg后綴為CAD圖紙，doc,docx為WORD文檔，原稿無水印，可編輯。具體請(qǐng)見文件預(yù)覽，有不明白之處，可咨詢QQ:12401814 畢 業(yè) 設(shè) 計(jì) 任 務(wù) 書1畢業(yè)設(shè)計(jì)課題的任務(wù)和要求： 設(shè)計(jì)任務(wù)為了解車床主軸變速箱的結(jié)構(gòu)和工作原理，使用三維CAD設(shè)計(jì)軟件完成給定型號(hào)車床主軸變速箱的三維設(shè)計(jì)，繪制二維工程圖，并實(shí)現(xiàn)車床主軸變速箱的運(yùn)動(dòng)仿真。2畢業(yè)設(shè)計(jì)課題的具體工作內(nèi)容（包括原始數(shù)據(jù)、技術(shù)要求、工作要求等）：（1）掌握三維CAD設(shè)計(jì)軟件的使用技術(shù)； （2）完成給定型號(hào)主軸變速箱的三維建模；（3）用三維設(shè)計(jì)軟件實(shí)現(xiàn)車床主軸變速箱的運(yùn)動(dòng)仿真；（4）繪出（或打印出）部分相關(guān)工程圖； （5）撰寫設(shè)計(jì)說明書： (a)設(shè)計(jì)合理，語句通順，格式規(guī)范，圖表正確，表述清晰； (b)打印成冊(cè)。畢 業(yè) 設(shè) 計(jì) 任 務(wù) 書3對(duì)畢業(yè)設(shè)計(jì)課題成果的要求包括畢業(yè)設(shè)計(jì)、圖紙、實(shí)物樣品等)：1 畢業(yè)設(shè)計(jì)開題報(bào)告一份；2 畢業(yè)設(shè)計(jì)說明書一本，要求思路清晰，語句通順，無錯(cuò)別字；3 圖紙一套，要求結(jié)構(gòu)合理，表達(dá)正確、清晰。4畢業(yè)設(shè)計(jì)課題工作進(jìn)度計(jì)劃：起 迄 日 期工 作 內(nèi) 容2016年2月29日 3月 21 日3月 22日 5月 20 日5月 20日 6月1日6月 1日 6月5日學(xué)習(xí)相關(guān)軟件，查閱資料，撰寫開題報(bào)告；熟悉開發(fā)環(huán)境，詳細(xì)設(shè)計(jì)；撰寫說明書；畢業(yè)答辯。學(xué)生所在系審查意見：同意下發(fā)任務(wù)書系主任： 2016年2 月29 日 畢業(yè)設(shè)計(jì)開題報(bào)告1結(jié)合畢業(yè)設(shè)計(jì)課題情況，根據(jù)所查閱的文獻(xiàn)資料，撰寫2000字左右的文獻(xiàn)綜述：文獻(xiàn)綜述1.1研究背景(1)車床的用途車床類機(jī)床主要用于加工各種回轉(zhuǎn)表面，如內(nèi)外圓柱表面，圓錐表面，成型回轉(zhuǎn)表面等，有些車床還能加工螺紋面。由于多數(shù)機(jī)器零件具有回轉(zhuǎn)表面。車床的通用性又較廣，因此在機(jī)械制造廠中，車床的應(yīng)用極為廣泛，在金屬切削機(jī)床中的比重最大，約占機(jī)床總臺(tái)數(shù)的20%35%.（2）車床的分類車床按其結(jié)構(gòu)和用途可分為:臥式車床和落地車床立式車床轉(zhuǎn)塔車床單軸和多軸自動(dòng)和半自動(dòng)車床仿形車床和多刀車床數(shù)控車床和車削中心各種專門化車床。（3）車床的組成部件部件有主軸箱刀架尾座進(jìn)給箱溜板箱床身卡盤底座絲杠后頂尖(4)車床主軸變速箱車床主軸箱又稱床頭箱，變速箱。由箱體、主軸、傳動(dòng)軸、軸上傳動(dòng)件、變速操縱機(jī)構(gòu)、潤(rùn)滑密封件等組成。主軸通過前段的卡盤或者花盤帶動(dòng)工件完成旋轉(zhuǎn)作主運(yùn)動(dòng)，也可以裝前頂尖通過撥盤帶動(dòng)工件旋轉(zhuǎn)（5）車床的發(fā)展歷程古代的車床是靠手拉或腳踏，通過繩索使工件旋轉(zhuǎn)，并手持刀具而進(jìn)行切削的。1797年，英國(guó)機(jī)械發(fā)明家莫茲利創(chuàng)制了用絲杠傳動(dòng)刀架的現(xiàn)代車床，并于1800年采用交換齒輪，可改變進(jìn)給速度和被加工螺紋的螺距。1817年，另一位英國(guó)人羅伯茨采用了四級(jí)帶輪和背輪機(jī)構(gòu)來改變主軸轉(zhuǎn)速。為了提高機(jī)械化自動(dòng)化程度，1845年，美國(guó)的菲奇發(fā)明轉(zhuǎn)塔車床。1848年，美國(guó)又出現(xiàn)回輪車床1873年，美國(guó)的斯潘塞制成一臺(tái)單軸自動(dòng)車床，不久他又制成三軸自動(dòng)車20世紀(jì)初出現(xiàn)了由單獨(dú)電機(jī)驅(qū)動(dòng)的帶有齒輪變速箱的車床。第一次世界大戰(zhàn)后，由于軍火、汽車和其他機(jī)械工業(yè)的需要，各種高效自動(dòng)車床和專門化車床迅速發(fā)展。為了提高小批量工件的生產(chǎn)率，40年代末，帶液壓仿形裝置的車床得到推廣，與此同時(shí)，多刀車床也得到發(fā)展。50年代中，發(fā)展了帶穿孔卡、插銷板和撥碼盤等的程序控制車床。數(shù)控技術(shù)于60年代開始用于車床，70年代后得到迅速發(fā)展。1.3車床的三維設(shè)計(jì)研究現(xiàn)狀隨著計(jì)算機(jī)圖形學(xué)、計(jì)算機(jī)硬件和軟件系統(tǒng)的飛速發(fā)展，計(jì)算機(jī)輔助繪圖技術(shù)在相關(guān)的行業(yè)里得到了日益廣泛的應(yīng)用，在我國(guó)的工程設(shè)計(jì)領(lǐng)域計(jì)算機(jī)繪圖技術(shù)的應(yīng)用已得到普及，油氣實(shí)在科研院所、現(xiàn)代化企業(yè)中，計(jì)算機(jī)輔助繪圖已經(jīng)取代了傳統(tǒng)的手工繪圖。計(jì)算機(jī)繪圖技術(shù)的普及，使廣大的工程設(shè)計(jì)人員從繁重的手工繪圖中解放出來，把更多的時(shí)間和精力投入到產(chǎn)品開發(fā)中區(qū)。利用計(jì)算機(jī)繪圖軟件進(jìn)行工程設(shè)計(jì)可以顯著地縮短企業(yè)產(chǎn)品設(shè)計(jì)周期，節(jié)省人力、物力、財(cái)力，提高設(shè)計(jì)質(zhì)量以及工作效率。在機(jī)械設(shè)計(jì)中，常用的三維軟件有Pro/E、Solidworks等。由于Solidworks功能強(qiáng)大、易學(xué)易用和技術(shù)創(chuàng)新是Solidworks的三大特點(diǎn)，使得Solidworks成為領(lǐng)先的、主流的三維CAD解決方案。Solidworks能夠提供不同的設(shè)計(jì)方案、減少設(shè)計(jì)過程中的錯(cuò)誤以及提高產(chǎn)品質(zhì)量。Solidworks不僅提供如此強(qiáng)大的功能，同時(shí)對(duì)每個(gè)工程師和設(shè)計(jì)者來說，操作簡(jiǎn)單方便、易學(xué)易用。對(duì)于熟悉微軟的Windows系統(tǒng)的用戶，基本上就可以用Solidworks來搞設(shè)計(jì)了。Solidworks獨(dú)有的拖拽功能使用戶在比較短的時(shí)間內(nèi)完成大型裝配設(shè)計(jì)。Solidwork資源管理器是同Windows資源管理器一樣的CAD文件管理器，用它可以方便地管理CAD文件。使用Solidworks，用戶能在比較短的時(shí)間內(nèi)完成更多的工作，能夠更快地將高質(zhì)量的產(chǎn)品投放市場(chǎng)。1.4總結(jié)本綜述對(duì)機(jī)床的結(jié)構(gòu)、分類，主軸變速箱等基本知識(shí)進(jìn)行了簡(jiǎn)介，指出了國(guó)產(chǎn)機(jī)床發(fā)展過程中存在的缺陷。同時(shí)，對(duì)三維設(shè)計(jì)及仿真常用的軟件SolidWorks進(jìn)行了簡(jiǎn)要的介紹。預(yù)期通過本綜述對(duì)車床主軸變速器的重要性有一個(gè)深刻的認(rèn)識(shí)。學(xué)會(huì)使用SolidWorks建立三維模型及模型庫，進(jìn)行虛擬裝配，動(dòng)畫演示，仿真運(yùn)動(dòng)分析，將三維技術(shù)融入到機(jī)械類課程當(dāng)中。參考文獻(xiàn)1曹金榜.機(jī)床主軸變速箱設(shè)計(jì)指導(dǎo)，北京機(jī)械工業(yè)出版社，19872威克機(jī)床，北京機(jī)械工業(yè)出版社，19873（德）斯推番.E.機(jī)床齒輪變速箱最佳傳動(dòng)方案，上海上?？茖W(xué)技術(shù)出版社，1965，4韓秋實(shí)械制造技術(shù)基礎(chǔ)，北京一機(jī)械工業(yè)出版社，20105劉傳紹.機(jī)械制造工藝學(xué)，北京電了工藝出版社，20056紀(jì)名剛機(jī)械設(shè)計(jì)，北京高等教育出版社，2006.7楊雪寶機(jī)械制造裝備與設(shè)計(jì)西北工業(yè)大學(xué)出版社.2010.8李國(guó)斌機(jī)械設(shè)計(jì)基礎(chǔ)機(jī)械工業(yè)出版社出版2001.9唐亞鵬.,SolidWorks模具設(shè)計(jì)高級(jí)教程.北京:人民郵電出版社,2004.10楊麗，楊勇生，李光耀.SolidWorks零件設(shè)計(jì)M.北京：清華大學(xué)出版社200211龐璐,丁俊.基于Solidworks自動(dòng)繪制漸開線齒輪模型的研究J.武漢理工大學(xué),200612高成慧,付正飛.Solidworks與AutoCAD相結(jié)合實(shí)現(xiàn)直齒圓柱齒輪的三維參數(shù)化設(shè)計(jì),2006.13王秀玲.基于Solidworks的齒輪三維造型方法研究J.機(jī)械設(shè)計(jì)與制造,2006.14鄭鵬飛.數(shù)控機(jī)床主軸變速箱的設(shè)計(jì)J.制造業(yè)自動(dòng)化，2011.15任濟(jì)生，唐道武.機(jī)械設(shè)計(jì)基礎(chǔ)M.北京：中國(guó)礦業(yè)出版社，2008.畢業(yè)設(shè)計(jì)開題報(bào)告本課題要研究或解決的問題和擬采用的研究手段（途徑）：2.1設(shè)計(jì)要求本課題名稱為某型號(hào)車床主軸變速箱三維設(shè)計(jì)與仿真，研究問題的實(shí)質(zhì)是，了解車床變速機(jī)構(gòu)的結(jié)構(gòu)和工作原理，完成某型號(hào)車床主軸變速箱的三維建模，進(jìn)行虛擬裝配，動(dòng)畫演示，仿真運(yùn)動(dòng)分析，并繪制二維工程圖。2.2設(shè)計(jì)方案（1）對(duì)車床的傳動(dòng)系統(tǒng)及傳動(dòng)方案的確定，CA6140型臥式車床主運(yùn)動(dòng)，是由主電動(dòng)機(jī)經(jīng)三角皮帶傳至主軸箱中的軸，軸上裝上一個(gè)雙向多片式摩擦離合器M1,用于控制主軸的啟動(dòng)停止和換向。軸的運(yùn)動(dòng)經(jīng)離合器M1和軸-間變速齒輪傳至，然后分兩路傳遞給主軸，如下圖變速箱的傳動(dòng)系統(tǒng)如圖所示。（2）對(duì)變速箱的齒輪進(jìn)行參數(shù)化建立 軸上的一對(duì)齒輪中，小齒的齒數(shù)為Z1=51，則與其相嚙合的大齒輪齒數(shù)為Z2=56軸上齒數(shù)為38、43 模數(shù)為 2，齒數(shù)為 39、22、30 模數(shù)為 2.5軸上齒數(shù)為 41、58、50 模數(shù)為 2.5，齒數(shù)為 20、50 、63模數(shù)為 2軸 IV 上齒數(shù)為 80 、50模數(shù)為 2，齒數(shù)為 20、51 模數(shù)為 3軸 V 上齒數(shù)為 26 模數(shù)為 5.75，齒數(shù)為 80 、50模數(shù)為 3VI 上齒數(shù)為 58 模數(shù)為 5.75，齒數(shù)為50，模數(shù)為22.3設(shè)計(jì)思路1、模型建立。完成CA6140型臥式車床主軸箱變速器的的Solidworks模型建立工作， 2、變速箱的三維實(shí)體建模，具體過程如下：（3）對(duì)軸的建模軸 I 從左至右分別為深溝球軸承 61808(2 對(duì)) 61807（6 對(duì)）軸 II 所選的軸承 從左至右分別為圓錐滾子軸承 30305 (1 對(duì)) 30304（1 對(duì)）軸 III 所選軸承 從左至右分別為 30306 (1 對(duì)) 61806（1 對(duì)） 30305（1 對(duì)）軸 IV 所選軸承從左至右分別為 30307(1 對(duì)) 30308（1 對(duì)）軸 V 所選軸承 從左至右分別為 30312 (2 對(duì))軸 VI 所選軸承從左至右分別為雙列圓柱滾子軸承 NN3015K (1 對(duì))、圓柱滾子軸承 NU218（1 個(gè)）、推力球軸承 51120/P5(1 對(duì))、雙列圓柱滾子軸承 NN3012（1 對(duì)）。（4）確定軸在箱體的位置（5）傳動(dòng)系統(tǒng)的裝配3、仿真運(yùn)動(dòng)（1）仿真運(yùn)動(dòng)的參數(shù)設(shè)置1)主軸最低轉(zhuǎn)速為10mm/s,最高轉(zhuǎn)速為1400mm/s，轉(zhuǎn)速調(diào)整范圍為 = /=142）主軸轉(zhuǎn)速數(shù)列的公比為1.123）主軸轉(zhuǎn)速級(jí)數(shù):正轉(zhuǎn)Z=24 反轉(zhuǎn)：124)電動(dòng)機(jī)的參數(shù)：功率：7.5kw 滿載轉(zhuǎn)速：1450 r/min(2)模擬仿真運(yùn)動(dòng)效果2.4進(jìn)度安排2月17日-2月23日：查閱資料2月24日-3月2日：確定畢業(yè)設(shè)計(jì)思路3月3日-3月21日：撰寫開題報(bào)告3月22日-3月27日：熟悉Solidworks環(huán)境,建立某型號(hào)車床三維模型3月28日-4月19日：進(jìn)行主軸變速箱仿真加工4月20日-5月18日：確定設(shè)計(jì)方案5月19日-6月1日：完成畢業(yè)設(shè)計(jì)說明書初稿6月2日6月5日：根據(jù)指導(dǎo)老師意見，修改論文初稿，完成終稿，準(zhǔn)備答辯畢業(yè)設(shè)計(jì)開題報(bào)告指導(dǎo)教師意見：該生設(shè)計(jì)題目為某型號(hào)車床主軸變速箱三維設(shè)計(jì)與仿真，開題之前，該生通過查閱資料，對(duì)自己要做的課題有了初步的了解。開題報(bào)告文獻(xiàn)綜述部分詳細(xì)敘述了車床的應(yīng)用背景、研究現(xiàn)狀和發(fā)展趨勢(shì)，并明確了自己的設(shè)計(jì)任務(wù)。在第二部分首先明確了設(shè)計(jì)要求，確定了主軸箱的主要參數(shù)和結(jié)構(gòu)形式，制定了課題研究方案，然后確定了研究的內(nèi)容和研究手段，并制定了詳細(xì)的設(shè)計(jì)進(jìn)程。開題報(bào)告條理清晰，格式規(guī)范，內(nèi)容詳實(shí)，制定的研究方案合理可行。同意該生開題。 指導(dǎo)教師： 2016 年 3 月 20日所在學(xué)院審查意見： 同意開題 系主任： 2016年3月 22 日 譯文標(biāo)題基于工程數(shù)據(jù)庫的起重機(jī)結(jié)構(gòu)計(jì)算機(jī)輔助設(shè)計(jì)原文標(biāo)題CAD/CAM OF CRANES STRUCTURE BASED ON ENGINEERING DATABASE作 者 Chonghua Wang譯 名王重華國(guó) 籍中國(guó)原文出處Department of Mechanical Engineering Shanghai Maritime University P.R.China e-mail spmtcshmtu.edu.cn譯文：基于工程數(shù)據(jù)庫的起重機(jī)結(jié)構(gòu)計(jì)算機(jī)輔助設(shè)計(jì)摘要根據(jù)大型復(fù)雜結(jié)構(gòu)機(jī)械CAD/CAM專業(yè)，根據(jù)起重機(jī)的結(jié)構(gòu)工程數(shù)據(jù)庫的CAD / CAM系統(tǒng)是本文提出的?；谧皂斚蛳碌膶哟谓Y(jié)構(gòu)，特征技術(shù)，裝配約束關(guān)系，自下而上的裝配工藝和向下到頂部尺寸約束關(guān)系，建立了一個(gè)三維參數(shù)化模型族的計(jì)算機(jī)輔助設(shè)計(jì)平臺(tái)，允許生成可行的配置的起重機(jī)結(jié)構(gòu)。一個(gè)總結(jié)的GUI和ANSYS的APDL圖案的背景知識(shí)，起重機(jī)的有限元模型是基于組合模式的建立。實(shí)現(xiàn)了有限元模型的同步更新和分析。在系統(tǒng)中構(gòu)建了2種工程數(shù)據(jù)庫。一個(gè)是參數(shù)化的數(shù)據(jù)庫，包含了各種參數(shù)化的零件和部件，常用于起重機(jī)結(jié)構(gòu)。另一種是針對(duì)每一個(gè)單獨(dú)的起重機(jī)而設(shè)計(jì)的，其中包括用于起重機(jī)結(jié)構(gòu)的所有部件和部件，其中參數(shù)化的變量被確定的值所代替。以后可以用來創(chuàng)建BOM，建立有限元模型，安排零件在數(shù)控切割鋼板，焊接和制造工藝裝置設(shè)計(jì)。微軟SQL服務(wù)器選擇構(gòu)建數(shù)據(jù)庫和CADCAM集成是使用MS VC+ 6和Pro/TOOLKIT實(shí)現(xiàn)。關(guān)鍵詞計(jì)算機(jī)輔助設(shè)計(jì)/凸輪，結(jié)構(gòu)，起重機(jī)，工程數(shù)據(jù)庫，三維設(shè)計(jì)1。在過去的幾十年里，國(guó)際貿(mào)易迅速增長(zhǎng)，這依賴于世界物流的運(yùn)輸鏈。深水港的能力，迅速處理和分發(fā)大量的集裝箱和貨物，這是在在物流鏈中不斷發(fā)揮關(guān)鍵作用?，F(xiàn)在世界上幾乎所有的港口都在忙著擴(kuò)張。港口起重機(jī)在最近幾年迅速增長(zhǎng)。港口起重機(jī)是非常大的，復(fù)雜的機(jī)器，越來越大，更自動(dòng)化，更高的速度，以滿足巨大的船舶和大量的負(fù)載和卸載。與一般的機(jī)器相比，它具有一個(gè)獨(dú)特的組成部分，它是一個(gè)巨大且復(fù)雜的結(jié)構(gòu)。起重機(jī)結(jié)構(gòu)的計(jì)算機(jī)輔助設(shè)計(jì)/凸輪機(jī)構(gòu)的特點(diǎn)是：起重機(jī)的結(jié)構(gòu)型式和設(shè)計(jì)參數(shù)，滿足各種不同的自然、環(huán)境和運(yùn)行條件的設(shè)計(jì)參數(shù)。結(jié)構(gòu)由幾個(gè)部件組成。每一個(gè)部件都是由焊接而成的。雖然很多零件都是矩形板，但它們的厚度可以隨構(gòu)件的變化而不斷變化，以減輕重量，同時(shí)保持足夠的強(qiáng)度。此外，有大量的結(jié)構(gòu)細(xì)節(jié)，讓組件支持外部負(fù)載。因此，該組件是非常復(fù)雜的。C）的結(jié)構(gòu)設(shè)計(jì)應(yīng)符合強(qiáng)度、穩(wěn)定性等要求，補(bǔ)償?shù)臉?biāo)準(zhǔn)和規(guī)范，累積損傷和振動(dòng)頻率等。因此有必要對(duì)結(jié)構(gòu)進(jìn)行有限元分析。由于結(jié)構(gòu)非常大，復(fù)雜，任何有限元軟件包的商業(yè)計(jì)算機(jī)輔助設(shè)計(jì)軟件是不夠的，以處理復(fù)雜結(jié)構(gòu)的起重機(jī)。起重機(jī)結(jié)構(gòu)凸輪的技術(shù)比較簡(jiǎn)單。特別是數(shù)控切割和自動(dòng)焊接在大多數(shù)工廠都有廣泛的應(yīng)用。本文提出了起重機(jī)結(jié)構(gòu)的計(jì)算機(jī)輔助設(shè)計(jì)/計(jì)算機(jī)輔助設(shè)計(jì)。它主要是基于程序的計(jì)算機(jī)與參數(shù)化三維建模技術(shù)、有限元分析、工程數(shù)據(jù)庫技術(shù)、Pro/E、ANSYS、MS Visual C+和微軟SQL Server。該系統(tǒng)包括建立起重機(jī)械三維參數(shù)化模型族的計(jì)算機(jī)輔助設(shè)計(jì)平臺(tái)，建立有限元模型，二次開發(fā)的三維參數(shù)化模型，同步更新和有限元分析，參數(shù)化和若干模型的構(gòu)造和收集信息，組件和起重機(jī)的應(yīng)用和供應(yīng)平臺(tái)。2。為了支持起重機(jī)設(shè)計(jì)的計(jì)算機(jī)輔助設(shè)計(jì)平臺(tái)，設(shè)計(jì)了起重機(jī)的三維參數(shù)化模型，為每個(gè)家庭成員提供了一種可行的起重機(jī)、部件和部件的配置，然后將它們縮放到期望的尺寸。港口集裝箱起重機(jī)計(jì)算機(jī)輔助設(shè)計(jì)模型平臺(tái)的框架，為港口集裝箱起重機(jī)提供支持功能：2.1。分解成零部件和零部件的基礎(chǔ)上的自頂向下的層次結(jié)構(gòu)的產(chǎn)品結(jié)構(gòu)，能夠方便的設(shè)計(jì)任務(wù)的開發(fā)團(tuán)隊(duì)的成員，一個(gè)起重機(jī)的設(shè)計(jì)必須以某種方式結(jié)構(gòu)化。著名的層次結(jié)構(gòu)的產(chǎn)品結(jié)構(gòu)是用于此。起重機(jī)由若干部件組成。每個(gè)組件可以包含若干子或一部分。第一種類型的組件被稱為復(fù)合組件（在下面的文本，我們只稱之為組件），第二類是一個(gè)單一的組件（我們稱之為下面的一部分）。該產(chǎn)品結(jié)構(gòu)以這種方式持續(xù)下去，直到所有的組件在層次結(jié)構(gòu)中的最低水平。因此，產(chǎn)品是結(jié)構(gòu)化的自上而下的方式，創(chuàng)造盡可能多的層次，如所需的設(shè)計(jì)師。圖1顯示了一個(gè)簡(jiǎn)化的集裝箱起重機(jī)的層次結(jié)構(gòu)。2.2。構(gòu)建了基于特征技術(shù)特征技術(shù)的CAD軟件平臺(tái)如Pro/Engineer提供的三維零件模型、SolidWorks等包括：a）草案的特點(diǎn)，基本幾何特征繪制截面拉伸，旋轉(zhuǎn)或掃描；b）附件的功能被添加到基本特征包括孔、圓角、塌角等。根據(jù)上述特征技術(shù)，生成集裝箱起重機(jī)零件的三維模型。2.3。指定組件的空間約束關(guān)系，以創(chuàng)建產(chǎn)品種類的組件和組件之間的空間關(guān)系，在產(chǎn)品族中的代表使用裝配約束關(guān)系。在計(jì)算機(jī)輔助設(shè)計(jì)軟件的裝配模塊中，如支持/工程、裝配等約束關(guān)系，如匹配、對(duì)準(zhǔn)、插入和切向等。在這里，根據(jù)起重機(jī)的層次結(jié)構(gòu)，零部件和組件之間的關(guān)系是建立使用裝配約束提供的專業(yè)/工程師。圖2表示門戶框架中的組件之間的裝配約束關(guān)系。2.4。為了使零件、零部件和起重機(jī)的設(shè)計(jì)參數(shù)發(fā)生改變時(shí)，為了使零件、部件和起重機(jī)的新的三維模型發(fā)生改變，從而建立起到頂部尺寸約束關(guān)系，從而建立零件或部件的設(shè)計(jì)參數(shù)。設(shè)計(jì)參數(shù)由設(shè)計(jì)人員根據(jù)零件或部件的結(jié)構(gòu)設(shè)計(jì)。尺寸變量，這是自動(dòng)生成時(shí)，三維模型的零件或組件，控制真正的幾何尺寸和拓?fù)潢P(guān)系的一部分或一個(gè)組件。因此，為了使設(shè)計(jì)參數(shù)發(fā)生變化時(shí)，零件、部件或吊車的精確的新模型得到改變，應(yīng)準(zhǔn)確構(gòu)造設(shè)計(jì)參數(shù)和尺寸變量之間的關(guān)系。商業(yè)計(jì)算機(jī)輔助設(shè)計(jì)軟件，如專業(yè)/工程師提供的功能，建立設(shè)計(jì)參數(shù)和設(shè)計(jì)參數(shù)和尺寸變量之間的關(guān)系。必須指出的是，每一部分都將被用來組成一個(gè)組件。所有的引用而不是對(duì)部分實(shí)體將失效，必須重新開業(yè)。因此，重要的是要設(shè)置所有的參數(shù)的模型的一部分。2.5。部件或產(chǎn)品的裝配約束關(guān)系的基礎(chǔ)上，根據(jù)起重機(jī)的層次結(jié)構(gòu)模型自下而上的方式產(chǎn)生的，一個(gè)設(shè)計(jì)師能盡快的任務(wù)已經(jīng)分配給他開始建立零件三維模型。另一方面，三維建模組件設(shè)計(jì)器所獲分配只能在其子組件和零件已創(chuàng)建啟動(dòng)。因此，實(shí)際的建?；顒?dòng)是自下而上的過程，從層次結(jié)構(gòu)的產(chǎn)品結(jié)構(gòu)的葉子開始。根據(jù)起重機(jī)的層次結(jié)構(gòu)和組件和零件之間的裝配約束關(guān)系，生成了零件的三維模型。對(duì)零件模型的參數(shù)進(jìn)行評(píng)估，并在組裝前進(jìn)行修改一個(gè)組件。如果有必要修改部分后，它已被組裝，應(yīng)刪除部分和一個(gè)新的模型的部分進(jìn)行評(píng)估，以適當(dāng)?shù)膬r(jià)值和被組裝。所有的設(shè)計(jì)參數(shù)必須在部件或組件的模型上設(shè)置。無設(shè)計(jì)參數(shù)是在系統(tǒng)中的起重機(jī)裝配模型上設(shè)置，以避免在任何參數(shù)發(fā)生改變后，在整個(gè)起重機(jī)模型再生故障。圖3顯示了基于組件和零件之間的約束關(guān)系的繁榮的三維裝配模型。圖4和圖5基于裝配約束關(guān)系的子組件和零件之間不同的門戶框架顯示3D模型。3。有限元分析中的有限元分析模型的生成，數(shù)學(xué)模型應(yīng)盡可能準(zhǔn)確地模擬真實(shí)物體、載荷和約束條件，得到可靠的結(jié)果。在整個(gè)起重機(jī)結(jié)構(gòu)上，應(yīng)進(jìn)行有限元分析。由于結(jié)構(gòu)非常大，復(fù)雜，任何有限元軟件包的商業(yè)計(jì)算機(jī)輔助設(shè)計(jì)軟件是不夠的，以滿足任務(wù)。ANSYS是選中是因?yàn)槠鋸?qiáng)大的分析功能。同樣的道理，在ANSYS中不能采用板單元。Beam188單元的建立起重機(jī)有限元模型。在ANSYS中，兩種建模模式提供了建立有限元模型，即人機(jī)交互模式也叫GUI模式和命令流輸入模式也被稱為APDL模式。雙模式也有優(yōu)點(diǎn)和缺點(diǎn)，這是在參考文獻(xiàn)中描述。一個(gè)總結(jié)的GUI和ANSYS的APDL圖案的背景知識(shí)，起重機(jī)的有限元模型是基于組合模式的建立。首先，對(duì)起重機(jī)有限元模型可以通過ANSYS的GUI模式構(gòu)建。第二，CAE分析起重機(jī)進(jìn)行相應(yīng)的日志文件也產(chǎn)生。日志文件可以通過使用ANSYS APDL參數(shù)化設(shè)計(jì)語言所提供的一些變化后，已在部分修訂，組件或起重機(jī)。該起重機(jī)包括生成模型的APDL，載荷和約束的施加，建立了有限元求解、后處理。生成的模型由參數(shù)定義、節(jié)點(diǎn)/單元/節(jié)建立有限元分析模型等新的起重機(jī)是通過運(yùn)行APDL文件構(gòu)造。實(shí)現(xiàn)了有限元模型的同步更新和分析。參見圖6和7的有限元模型和應(yīng)力分析圖的起重機(jī)結(jié)構(gòu)。4。數(shù)據(jù)庫系統(tǒng)是為了管理起重機(jī)的設(shè)計(jì)與制造的所有信息，實(shí)現(xiàn)數(shù)據(jù)共享，由計(jì)算機(jī)輔助設(shè)計(jì)/凸輪集成系統(tǒng)的各個(gè)模塊共享，使程序獨(dú)立于數(shù)據(jù)，保證數(shù)據(jù)的完整性和安全性，必須采用數(shù)據(jù)庫系統(tǒng)。在流行的數(shù)據(jù)庫管理系統(tǒng)微機(jī)如FoxPro、Visual Foxpro、SQL Server等，微軟SQL Server 2000是最后的選擇。4.1。為了GDB和深發(fā)展加快設(shè)計(jì)，提高設(shè)計(jì)質(zhì)量，減少重復(fù)工作，兩種數(shù)據(jù)庫是系統(tǒng)設(shè)計(jì)。一個(gè)被稱為通用數(shù)據(jù)庫（GDB）。其他特殊的數(shù)據(jù)庫（SDB）個(gè)人起重機(jī)。GDB是一個(gè)參數(shù)化的數(shù)據(jù)庫，包括各種參數(shù)化零件和常用的起重機(jī)結(jié)構(gòu)組成。部件和組件被存儲(chǔ)在多個(gè)分支和層次，作為一個(gè)樹結(jié)構(gòu)。雖然有可能是大量的矩形板的一個(gè)組成部分，例如，在繁榮，在梁，只有一個(gè)參數(shù)化的矩形板在每一個(gè)分支，以減少冗余。GDB可以被所有設(shè)計(jì)師的公司參觀。當(dāng)一個(gè)設(shè)計(jì)師給設(shè)計(jì)的一個(gè)組成部分，他可以先搜索gdb的相應(yīng)部門利用現(xiàn)有的參數(shù)化零部件和組件的三維模型構(gòu)建。同時(shí)，信息的零件和部件的使用記錄在SDB。他可以修改在GDB的零部件如果他們稍有不同，從什么是需要的。他甚至可以創(chuàng)建一個(gè)新的參數(shù)化零件和組件并將它們保存到GDB的機(jī)關(guān)批準(zhǔn)。SDB是專為每一個(gè)個(gè)體的起重機(jī)和包含所有零部件用于起重機(jī)結(jié)構(gòu)。它們也存儲(chǔ)在一個(gè)樹結(jié)構(gòu)中。不同于GDB，每一部分都有相應(yīng)的記錄，在深發(fā)展。參數(shù)化變量被確定值替換。隨著這些，代碼，名稱，存儲(chǔ)位置，位置，材料，重量，重心，制造等參數(shù)的參數(shù)。一些數(shù)據(jù)，例如重量的一部分，計(jì)算的一部分已被縮放。SDB可以用來創(chuàng)建BOM，建立有限元模型，安排零件在數(shù)控切割鋼板，焊接和制造工藝裝置設(shè)計(jì)。4.2。數(shù)據(jù)庫結(jié)構(gòu)與數(shù)據(jù)庫的使用，一些一般性的問題將被解決：數(shù)據(jù)完整性：在一個(gè)文件系統(tǒng)中，設(shè)計(jì)師誰保存的文件的變化，然后刪除由設(shè)計(jì)師誰保存的文件之后。但同時(shí)，采用數(shù)據(jù)庫的交易機(jī)制，在同一時(shí)間，一個(gè)計(jì)算機(jī)輔助設(shè)計(jì)模型不能同時(shí)進(jìn)行修改。直接關(guān)系：模型的數(shù)據(jù)實(shí)體的直接關(guān)系，三維模型之間的技術(shù)依賴關(guān)系可以很容易地發(fā)現(xiàn)。直接關(guān)系給設(shè)計(jì)者一個(gè)提示，在模型的改變之后，模型也必須改變。中心數(shù)據(jù)管理：數(shù)據(jù)中心庫提供備份和版本控制的幾個(gè)優(yōu)點(diǎn)。數(shù)據(jù)聚類：數(shù)據(jù)的聚類速度的數(shù)據(jù)訪問，因?yàn)槊總€(gè)設(shè)計(jì)師可以得到所需的信息，在他的本地PC。這是非常重要的分布式和協(xié)同設(shè)計(jì)項(xiàng)目。我們已經(jīng)使用了實(shí)體關(guān)系（二）模型，這是一個(gè)流行的高層次的概念數(shù)據(jù)模型，設(shè)計(jì)數(shù)據(jù)庫。這種模式及其變化經(jīng)常被用于數(shù)據(jù)庫應(yīng)用程序的概念設(shè)計(jì)，和許多數(shù)據(jù)庫設(shè)計(jì)工具采用其概念。二型模型描述數(shù)據(jù)的實(shí)體，關(guān)系和屬性。二型代表是一個(gè)實(shí)體，它是現(xiàn)實(shí)世界中的一個(gè)獨(dú)立存在的基本對(duì)象。每個(gè)實(shí)體都有屬性，即描述它的特定屬性。一個(gè)特定的實(shí)體將有一個(gè)值的每個(gè)屬性。描述每個(gè)實(shí)體的屬性值成為存儲(chǔ)在數(shù)據(jù)庫中的數(shù)據(jù)的一個(gè)重要部分。一個(gè)關(guān)系型R在n個(gè)實(shí)體類型E1，E2恩定義的關(guān)聯(lián)或關(guān)系集從這些類型的實(shí)體之間的。實(shí)體類型和實(shí)體集的關(guān)系類型及其對(duì)應(yīng)關(guān)系設(shè)置統(tǒng)稱同名的R.根據(jù)起重機(jī)的層次結(jié)構(gòu)，數(shù)據(jù)庫具有實(shí)體。每一部分，組件和起重機(jī)可以被表示為一個(gè)實(shí)體，它具有設(shè)計(jì)參數(shù)描述的屬性。在起重機(jī)產(chǎn)品零部件之間的空間關(guān)系表示為關(guān)系集R的數(shù)據(jù)庫采用微軟SQL Server和組件對(duì)象模型（COM）。5。CADCAM集成的基于Visual C+和SQL Server數(shù)據(jù)庫管理系統(tǒng)作為管理工程數(shù)據(jù)庫和Pro/ENGINEER用于建立三維模型，采用Visual C+作為編程語言構(gòu)建計(jì)算機(jī)輔助設(shè)計(jì)/凸輪的整體系統(tǒng)。第一個(gè)原因是Visual C+是一個(gè)可以訪問SQL數(shù)據(jù)庫語言。其次，當(dāng)我們?cè)O(shè)置GDB必須訪問數(shù)據(jù)庫以及訪問的三維模型，利用Pro/TOOLKIT，這是第二利用Pro/ENGINEER提供的軟件包。當(dāng)我們處理的是深發(fā)展，我們也需要訪問數(shù)據(jù)庫和參數(shù)化模型的同時(shí)，做一些修改。Visual C+是強(qiáng)大的編譯程序能訪問Pro/Engineer和SQL Server 2000的同時(shí)，實(shí)現(xiàn)它們之間的數(shù)據(jù)通信。第三、Visual C+是一種面向?qū)ο蟮木幊誊浖性S多優(yōu)點(diǎn)。6。本文介紹了基于工程數(shù)據(jù)庫的集裝箱起重機(jī)結(jié)構(gòu)計(jì)算機(jī)輔助設(shè)計(jì)/凸輪一體化系統(tǒng)的設(shè)計(jì)。基于自上而下的層次化的產(chǎn)品結(jié)構(gòu)、特征技術(shù)、裝配約束關(guān)系，利用Pro/ENGINEER提供的自底向上的裝配工藝和尺寸關(guān)系到頂部，一個(gè)三維參數(shù)化模型的CAD平臺(tái)的建立是為了讓家庭的起重機(jī)的可行的配置生成。一個(gè)總結(jié)的GUI和ANSYS軟件APDL圖案的背景知識(shí)，基于復(fù)合模式建立了該橋的有限元模型。實(shí)現(xiàn)了有限元模型的同步更新和分析。利用微軟SQL Server 2000，兩種數(shù)據(jù)庫是系統(tǒng)與CAD/CAM集成系統(tǒng)的各個(gè)模塊進(jìn)行設(shè)計(jì)。數(shù)據(jù)共享整個(gè)系統(tǒng)。以Visual C+的幫助下，實(shí)現(xiàn)了CADCAM的集成開發(fā)方法。該系統(tǒng)可以大大提高港口集裝箱起重機(jī)結(jié)構(gòu)設(shè)計(jì)效率和開發(fā)凸輪機(jī)械結(jié)構(gòu)復(fù)雜的大型結(jié)構(gòu)的應(yīng)用提供一個(gè)平臺(tái)。致謝本文受上海市重點(diǎn)學(xué)科建設(shè)項(xiàng)目，資助號(hào)：T0601。引用Chandrupatla, T., and Belegundu, A., (1991), Introduction to Finite Elements in Engineering, Prentice Hall. Claesson, A., Johannesson, H., and Gedell, S., (2001), Platform Product Development: Product Model a System Structure Composed of Configurable Components, Proc. 2001 ASME DETC/CIE Conference, Pittsburgh, ASME, New York, ASME Paper No. DETC2001/DTM-21714 Conner, C. G., De Kroon, J. P., and Mistree, F., (1999), A Product Variety Tradeoff Evaluation Method for a Family of Cordless Drill Transmissions, Proc. 1999 ASME DETC/CIE Conference, Las Vegas, ASME, New York, ASME Paper No. DETC99/DAC-8625. Martin, M. V., and Ishii, K., (2002), Design for Variety: Developing Standardized and Modularized Product Platform Architectures, Res. Eng. Des., 13(4),pp. 213235. Meyer, M. H., and Utterback, J. M., (1993), The Product Family and the Dynamics of Core Capability, Sloan Manage. Rev., 34(3), pp. 2947. Nayak, R. U., Chen, W., and Simpson, T. W., (2002), A Variation-Based Method for Product Family Design, Eng. Optimiz., 34(1), pp. 6581. Peak, R. S., (2003), Characterizing Fine-Grained Associatively Gaps: A Preliminary Study of CADCAE Model Inter-operability, Proc. 2003 ASME DETC/CIE Conference, Chicago, ASME Paper number CIE48232. Simpson, T. W., Maier, J. R. A., and Mistree, F., (2001), Product Platform Design: Method and Application, Res. Eng. Des., 13(1), pp. 222. Siddique, Z., and Rosen, D. W., (1999), Product Platform Design: A Graph Grammar Approach, Proc. 1999 ASME DETC/CIE Conference, Las Vegas, ASME, New York, ASME Paper No. DETC99/DTM-8762. Siddique, Z., and Rosen, D. W., (2001), On Discrete Design Spaces for the Configuration Design of Product Families , AI EDAM., 15(2), pp. 91108. Steffen, Dennis, Graham and Gary, (2004), Inside Pro/ENGINEER Wildfire, Thomson/Delmar Learning. VRML Consortium, (1997), The Virtual Reality Modeling Language: International Standard ISO/IEC DIS 14772-1. 原文：LathesCAD/CAM OF CRANES STRUCTURE BASED ON ENGINEERING DATABASEABSTRACT According to the specialties of CAD/CAM for largescale complex structures of machinery, a CAD/CAM system based on engineering database for cranes structures is proposed in this paper. Based on the top-down hierarchical product structure, feature technology, assembly constraint relationship, bottom-up assembly process and down-to-top dimension constraint relationship, a CAD platform of 3D parametric model family is built to allow generation of feasible configurations of crane structures. With a sum up of background knowledge of GUI and APDL patterns of ANSYS, the finite element model of the crane is set up based on composite pattern. Synchronous updating and analysis of FEA model are realized. Two kinds of engineering databases are constructed in the system. One is a parameterized database and contains all kinds of parameterized parts and components common used in crane structures. Another is designed for every individual crane and contains all parts and components used in crane structure, where parameterized variables are replaced by definite values. The later can be used to create BOM, to build FEM model, to arrange parts in the steel sheet for numerical control cutting and to design technological apparatus for welding and manufacture. Microsoft SQL Server is selected to construct the databases and the CAD/CAM integration is achieved using MS VC+6.0 and Pro/TOOLKIT. KEYWORDS CAD/CAM, Structure, Crane, Engineering database, 3D design 1. INTRODUCTION The international trades which increase rapidly in the last few decades rely on the transportation chains of world logistics. The abilities of the deepwater ports to swiftly handle and distribute the large quantity of containers and goods which are surging in continuously play a key role in the logistics chains. Almost all ports in the world are busy expanding nowadays. The port cranes increase rapidly all over the world in the recent years. The port cranes are very large and complex machines and becoming larger, more automatic and with higher speeds to meet the huge ships and the great quantity of load and unload. Comparing with normal machines, it has a unique component that is the huge and complicated structure. The characters of CAD/CAM for cranes structure are: a) Cranes structure has various types and a lot of design parameters to meet the different natural, environmental and operating conditions of every harbor. b) The structure is consisted of several components. Every component is formed by welding numerous parts. Although a lot of parts are rectangle plates, their thickness may vary continually along the component to reduce the weight while keeping enough strength. In addition, there are lots of construct details to let the component support external loads. So the components are very complicated. c) The design of the structure should conform to the requirements about strength, stability, bucking, cumulative damage and vibration frequency etc. of the Standards and Specifications. So it is necessary to do finite element analysis on the structure. As the structure is very large and complex, any FEA package of commercial CAD software is insufficient to handle the complex structures of crane. d) The techniques of CAM for crane structure are comparatively simple. Especially numerical control cutting and automatic welding are widely used in most factories. An integrated CAD/CAM for the cranes structure is proposed in this paper. It is mainly based on the technologies of parametric 3D modeling, finite element analysis, engineering database technique, Pro/ENGINEER, ANSYS, MS Visual C+ and Microsoft SQL Server. The system includes building CAD platform of 3D parametric model family for crane, setting up FEA model, the second exploiting of 3D parametric model, the synchronous updating and analysis of FEA, construction and collection information of parametric and certain models of parts, components and cranes and supply a platform to develop the application of CAM. 2. CAD PLATFORM OF 3D PARAMETRIC MODEL FAMILY FOR CRANE In order to support the designing of crane family, CAD representations for product platform is developed to allow generation of feasible configurations of cranes, components and parts for each family member and then scaling them to the desired size. The framework of CAD model platform for port container crane has to provide support functions listed as follows: 2.1. Decompose crane into components and parts based on top-down hierarchical product structure To be able to facilitate design tasks to the members of a development team, a crane to be designed has to be structured in some way. The well-known hierarchical product structure is used for this. A crane consists of a number of components. Each component can either consist of a number of subcomponents or be a part. The first type of component is called a compound component (in following text, we only call it as component), the second type a single component (we call it as part below). The product structuring continues recursively in this way, until all components at the lowest level in the hierarchy are parts. So the product is structured in a top-down way, creating as many levels as desired by the designers. Figure 1 shows a simplified hierarchical product structure of a container crane. 2.2. Construct 3D part model based on feature technology Feature technology provided by CAD software platform such as Pro/ENGINEER, Solidworks etc. includes: a)Draft features which are fundamental geometry characters produced by drawing cross sections and stretching, rotating or scanning them; b)Attachment features which are added to the fundamental characters include hole, round corner, collapse corner and so on. According to the feature technology describes above, the 3D models of the parts of the container crane are generated. 2.3. Specify spatial constraint relationships of components to create product variety The spatial relationships among the components and parts in the product family are represented using assembly constraint relationship. In the assembly module of CAD software such as Pro/ENGINEER, constraint relationships in assembling, for example, matching, aligning, inserting and tangential etc. are provided. Here, based on the hierarchical structure of crane, relationships among parts and components are built using the assembly constraints provide by Pro/ENGINEER. Figure 2 represents the assembly constraint relationships among the parts of portal frame. 2.4. Establishment of down to top size constraint relationship In order to regenerate the new 3D model of parts, components and crane when the values of design parameters are changed, a down to top size constraint relationships between size variables and design parameters in a part or component should be built. Design parameters are established by designers according to the structure of part or component. Size variables, which are generated automatically when 3D models of parts or components are built, control the real geometrical size and topological relationship of a part or a component. Therefore, in order to regenerated the accurate new model of a part, a component or crane when the values of design parameters are changed, the relationship between design parameters and size variables should be constructed accurately. Commercial CAD software such as Pro/ENGINEER has provided function to set up design parameters and build relationships between design parameters and size variables. It must be pointed out that every part would be used to compose a component. All the references which are not on the entity of the part would be invalidated then and must be setting up again. So it is important to setting all the references of parameters on the model of the part. 2.5. Generation of component or product assembly model based on constraint relationships in bottomup way Based on the hierarchical structure of the crane, a designer can start building 3D model of a part as soon as the task has been assigned to him. On the other hand, 3D modeling of a component by a designer to whom it was assigned can only start just after its subcomponents and parts have been created. So the actual modeling activity is bottom-up process, starting at the leaves of the hierarchical product structure. According to the hierarchical product structure of the crane and assembly constraint relationships among components and parts, 3D models of a component desired are generated. The parameters on the model of a part should be evaluated and can be modified before it is assembled to a component. If it is necessary to amend the part after it has been assembled, the part should be deleted and a new model of the part is evaluated to the proper values and to be assembled. All design parameters must be setting on the models for parts or components. No design parameter is setting on the assembling model of the crane in the system to avoid failure in regenerating the model of whole crane after any parameter has changed. Figure 3 shows the 3D assembly model of the boom based on constraint relationships among subcomponents and parts. Figure 4 and 5 show 3D models of different portal frames based on assembly constraint relationships among subcomponents and parts.3. GENERATION OF FEA MODEL FOR THE CRANE In finite element analysis, the mathematical model shall simulate the real object, loads and constraints as accurately as possible to get the reliable results. The FEA should usually be carried out on the whole crane structure. As the structures are very large and complex, any FEA package of commercial CAD software is insufficient to fulfill the task. The ANSYS is selected because of its powerful structural analysis functions. As the same reason, the plate elements in ANSYS could not be adopted. The beam188 elements are used to build the FEA model of the crane. In ANSYS, two modeling patterns are provided to build the FEA model, i.e. the human-machine interactive pattern also called GUI pattern and the command stream flow input pattern also known as APDL pattern. Two patterns have also advantages and shortcomings which are described in reference literature. With a sum up of background knowledge of GUI and APDL patterns of ANSYS, the FEA model of the crane is built based on composite pattern. First, FEA model of the crane can be built through ANSYS GUI pattern. Second, CAE analyses of the crane are carried out and corresponding log file is also generated. The log file can be amended by using parametric design language APDL provide by ANSYS after some changes have been made on the parts, components or crane. The APDL of the crane including generation of model, imposing of load and constraint, finite unit solution and post treatment is built. Generation of model consists of parameter definition, node/unit/section establishment etc. A new FEA model of the crane is constructed by running the APDL file. Synchronous updating and analysis of FEA model are realized. See Figure 6 and 7 for the FEA model and stress analysis chart of a crane structure.4. DATABASE SYSTEM In order to manage all the information about design and manufacture of crane, achieve the data to be shared by every module of CAD/CAM integration system, keep the programs independent from the data and guarantee the data integrality and security, the database system must be used. Among the popular database management systems for microcomputer such as FoxPro, Visual FoxPro, SQL Server and so on, Microsoft SQL Server 2000 is final selected. 4.1. GDB and SDB In order to speed up design, improve design quality and reduce repeat work, two kinds of databases are designed in the system. One is called general database (GDB). The others are special databases (SDB) for individual cranes. The GDB is a parameterized database and contains all kinds of parameterized parts and components common used in crane structures. The parts and components are stored in many branches and levels as a tree structure. Although there may be lots of rectangular plates in a component, for example, in the boom, in the girder,. There is only one parameterized rectangular plate in every branch to reduce redundancy. The GDB can be visited by all designers of the company. As soon as a designer is assigned to design a component, he can first search the corresponding branch of GDB to make use of the exis