汽车模具高速切削工艺参数数据库系统的设计

华中科技大学硕士学位论文汽车模具高速切削工艺参数数据库系统的设计姓名：宫爱红申请学位级别：硕士专业：机械设计及理论指导教师：陈和平20060425ICAMUGCBRIIAbstractThehigh-speedmachiningtechnologyalluresmostmanufacturersforitsgreatincreasesinmaterialremovalrate,machiningaccuracy,surfacequality,anddecreasinginmachiningcost.Thus,theHSMtechnologycanincreasetheprofitabilityandcompetitivenessofamachineshop.Itisveryimperativetodevelophigh-speedcuttingdatabasetoprovideappropriatecuttingparametersforthemanufacturingindustry.UntilnowthereareshortofHSMparametersusedinpractice,andAutoDieHigh-speedCuttingDatabaseSystemsarehardlyusedtoo.Andthesituationssuchasinfluenceprocessingqualityandprocessefficiencyofthepartandleadingtothecutteriswornandtorngenerallyexistbecauseofcuttingthecraftparametertochooseimproperly,therunningoffofalargenumberofinstancedataandexperiencedatahascausedthewastingseriouslyofresourcesagain.Themaingoalofthispaperistostructureadatabasesystemofcraftparameterofautodiehigh-speedmachining.ThemouldmanufacturingcompanyhaveaccumulatedHSMcases,cuttingparametersandexperiencecombiningcutter,workpiece,latheandenterprise'sownactualconditionsinproducingactually.Byutilizingdatachosenfromtheaboveresources,notonlycansavealargeamountofmaterialresources,financialresourcesbutalsocansuperviseproductionpracticesatahighspeedinordertoimprovetheefficiencyofprocessing,reducethecutterexpenses,obtainhighereconomicbenefits.Inthisdissertation,Firstofall,thesystematicstructureofahigh-speedcraftdatabaseofmouldcutshasbeendeveloped.ItisbasedonMicrosoftSQLServer2000asadatabasemanagementsystem.Secondly,UGinterfacesareprovidedbyprogrammingwithVC++,inthiswayuserscantransferdatainUGdirectly.Usersdonotneedtoswitchoveramongtheprocedures,socanimproveprogrammingefficiency;ThirdlyCase-BasedReasoningasaproblem-solvingapproachoftheartificialintelligencetosolveanewproblembyusingthesolutionsoftheoldproblemsispresented.CBRisalsoanincrementalandsustainedlearningapproach.Itenablesthesystemlearnfromstoringnewcaseandexperience.Therearemanymatterstoin-depthresearch,forexampleresearchofthecaseofrewriting,optimizingofHSMparametersandperfectionofsystemandsoon.KeywordsHigh-speedmachiningDatabasesystemCase-basedreasoningUnigarphics____111.112345678UGCAM2CAM1.21.2.120[1-2]80[3][4-5][6-7][8-11][3]1958~1960[3]1979()4(AMRP)[5][12]1979~1988(TechnicalUniversityDarmstadt)3(PTW)41[13]1980HKToenshoft[14]AGatto[15]TDMarusich[16]GMKimTOzelSJayaram[17-19][20]CNC[20][21-22]10,000~15,000r/min4[23]1.2.2[24][25]5[26,27][28][29]RGFentonMVRiberioSVWong[30-32]1988NAIMDS[24]1991KAIMDS[33]1417242CrMo20CrNiMo20NiMo[34][35][36-38]6[22][39]1.2.3CBRCBRCase-BasedReasoning[40]CBR1997CBR[41]7[42]CBR1.2.4UG[43-45]8UG/OpenAPIMFCUGMFCVC++MFCUG/OpenMFC[46]1VCMFCAppWizard(dll)2RegularDLLusingsharedMFCDLL34UGlibugopenint.liblibufun.lib51.3CBRCBRCAMUGCBR9CBRCBRMFCUGVisualC++MFCVisualC++UGUGMFC1022.12.22.11CAMCAMCBR231CAMCAM2CBRCBR34112.312MicrosoftSQLServer2000UGCBR2.213CBR2.41433.1[47][48]3.1DBMS153.2[49]3.2.1YN3.2163.2.217mnmmmmn183.2.34.2E-RDBMSE-RR(JCID,JCXH,JCMC,SCCS,SKXT,ZZGL,ZZNJ,GZTCC,GZXCX,GZXCY,GZXCZ,GZXCA,GZXCB,GZXCC,ZZZS,JJSDX,JJSDY,JJSDZ,JJSDA,JJSDB,JJSDC,DGJGX,DGJGY,DGJGZ,ZZJG,ZZCZD,DKRL,JXTDJD,JXTDYD,CFDWJDX,CFDWJDY,CFDWJDZ,ZXCD,LQPTS,LQFS/LL,BZ,LIBRF,nRF)IDIDIDGZXCIDID73NF2NF3NF19F’=[ABCCAJCIDBACGZXCIDDR={R1R2Rk}Ri3NFi=12k[59]F’C=)(FFiRip=3FN3FN()1JC(JCID,JCXH,JCMC,SCCS,SKXT,GZTCCZZGL,ZZNJ,ZZZS,ZZCZD,DKRLLIBRF,nRF,BZ)GZXC(GZXCID,JCID,GZTCC,GZXCX,GZXCY,GZXCZ,GZXCA,GZXCB,GZXCC)JJSD(JJSDID,JCID,JJSDX,JJSDY,JJSDZ,JJSDA,JJSDB,JJSDC)DGJG(DGJGID,JCID,DGJGX,DGJGY,DGJGZ,ZZJG)DWJD(DWJD,JCID,CFDWJDX,CFDWJDY,CFDWJDZ,ZXCD)LQ(LQID,JCID,LQPTS,LQFS/LL)JXTD(JXTDID,JCID,JXTDJD,JXTDYD)2DJ(DJMC,DJLX,SCCS,ZJ,GZCD,JGXS,CLPH,CLLB,CS,BBZJ,DTZJ,JBZJ,DGZJ,DPXH,DCJG,DCXS,RQJ,QJ,HJ,BZ,LIBRF,nRF)320GJ(CLPH,CLMC,RCLZT,CLYD,CLQD,TXML,PSB,MD,BRR,XZXS,RDL,BZ,LIBRF,nRF)4QXY(QXYPH,QXYMC,SCCS,QXYCF,BZ)5QXCS(QXID,JCID,DJMC,CLPH,JGFF,YHMB,ZZZS,JJSD,QXSD,QXKD,XSD,BZ,LIBRF)6CBRCBR(SLBH,JCID,DJMC,QXIDZZLHLJH,CX,MJH,ZJLX,CLLX,CLYD,LJBMLX,JGGX,JDYQ,DZBJ,ZDFS,LQFS,JGFS,SLSCRQ,ZJFWRQ,PJID,SYCS,IMAGEZJ(ZZLH,ZJH,ZJMCMJMJH,MJMCLJ(LJH,LJMC)PJ(PJID,JGXL,JGZL,DJSM,ZHPD)CXSIM(CX1CX2SIM)ZJSIMZJLX1,ZJLX2,SIMMJSIMMJLX1,MJLX2,SIMLJSIMLJLX1,LJLX2,SIMCLSIMCLLX1,CLLX2,SIMBMSIMLJBMLX1,LJBMLX2,SIMGXSIMJGGX1,JGGX2,SIMJDSIMJDYQ1,JDYQ2,SIMQZ(Wcx,Wzjlx,Wmjlx,Wljlx,Wcllx,Wclyd,Wljbmlx,Wjggx,Wjdyq)7CAMCAM(XMBH,KHID,ZZLH,MJH,LJH,CLPH,CLYD,JGBM,JGGX,BMJD,YQWCRQ,SJWCRQ,BCS,CXH,PART,SKCX,JCID,DJMC,,QXID,DZBJ,ZDFS,LQFS,JGFS,PJID)21KH(KHIDKHMCZJ(ZZLH,ZJH,ZJMCMJMJH,MJMCLJ(LJH,LJMC)PJ(PJID,JGXL,JGZL,DJSM,ZHPD)8JGK(JGMLX,JGFF)DGK(GJCLLX,DJCLPH,DJCLLX,TJJB,YXXS)QXK(QXYLMC,XYYZ,IMAGE)JYK(BH,DJCLLX,GJCLPH,DJCLPH,QXYL,JG,YY)9USERUSER,ROLE,PASS3.3.4[48]22JC(JCID,JCXH,JCMC,SCCS,SKXT,GZTCCZZGL,ZZNJ,ZZZS,ZZCZD,DKRLLIBRF,nRF,BZ)GZXC(GZXCID,JCID,GZTCC,GZXCX,GZXCY,GZXCZ,GZXCA,GZXCB,GZXCC)JJSD(JJSDID,JCID,JJSDX,JJSDY,JJSDZ,JJSDA,JJSDB,JJSDC)DGJG(DGJGID,JCID,DGJGX,DGJGY,DGJGZ,ZZJG)DWJD(DWJD,JCID,CFDWJDX,CFDWJDY,CFDWJDZ,ZXCD)LQ(LQID,JCID,LQPTS,LQFS/LL)JXTD(JXTDID,JCID,JXTDJD,JXTDYD)3.3MicrosoftSQLSer