基于4GL实现ERP与其他系统信息集成的研究与应用

上海交通大学硕士学位论文基于4GL实现ERP与其他系统信息集成的研究与应用姓名：朱敏申请学位级别：硕士专业：软件工程指导教师：蔡鸿明;PierreCorvaisier200912014GLERPI4GLERP(EnterpriseResourcePlanning)ERP)4GL(Fourth-generationLanguage)4GL4GL4GL4GLERPMES4GLERP1ERP4GL2.ERP4GL4GLERPERP3SageX3ERP4GLSageX3ERPSageX3ERP4GL4SageX3ERP4GLERPMES5.ERPMESERP4GLERPII6.ERP,4GLMES4GLERPIIIRESEARCHANDAPPLICATIONOFINFORMATIONINTEGRATIONBETWEENERPANDOTHERSYSTEMBY4GLABSTRACTEnterpriseResourcePlanning(AbbreviatedERP)realizedthemanagementofsupplychain,focusesontheintegrationofenterprisebusinessprocedure,improvestherunningefficiencybysynchronizationofalltheresourcesofenterprise.Fourth-GenerationLanguage(Abbreviated4GL),it’sdifferentwith3GL.Themainfeatureisuserfriendly,evenifanon-professionalprogrammerwithoutanytraining,hecanalsowriteprogramwith4GL.It’sadeclarative,interactive,nonproceduralprogramminglanguage.4GLhashighefficiencyprogrammingcode,intelligentdefaulttentative,databaseandapplicationgenerator.Enterpriseinformationintegration,realizedatasharingwithindifferentapplicationofenterprise,realizedataexchangewithindifferentdataformatandstoragetype.It’saproceduretoanalysis,correctandcombineinformationresourcefromdifferentsource,formandcontent,thengeneratevaluableinformationwithuniformdataformat.Informationintegrationisveryimportanttooptimizeenterprisebusinessprocedure,improverunningenterpriseefficiency,reduceenterpriserunningcost,andimproveenterprisecompetitivepower.Thispaper,throughaninformationintegrationprojectbetweenERPandMESinMORET,hasresearchedthetechnologytorealizetheinformationintegrationbetweenERPandothersystemby4GL.Itincludesseveralcontentsasbelow:1.ResearchedandintroducedthebasicconceptanddevelopmentofERP,thedevelopmentofprogramminglanguage,thebasicconceptanddevelopmentof4GL,thebasicconceptanddevelopmentofenterpriseinformationintegration,researchedandintroducedthestatusofresearchonenterpriseinformationintegrationathomeandabroad,researchedandanalysisthefeatureandshortageofcurrentintegrationtechnology,andsubmittedthepointtobeimprovedandoptimized.2.BaseonthetheoryofERPand4GL,accordingtotheexperience,submittedaframemodeltorealizetheinformationintegrationofERPandothersystemby4GL,andintroducedhowthemodelsolvetheusualproblemforinterfacebetweenERPandothersystemsabouthighcostofdevelopmentandimplementation,difficultyofmaintenanceandmanagement.3.IntroducedtheSageX3ERPsystemandits4GLdevelopmenttools,andsummarizedtheapplicationofinterfacedevelopmentby4GLinSageX3ERPbaseontheexperience.4.Accordingtotheframemodelofintegration,designedandrealizedtheinformationintegrationofERPandMESbySageX3ERPand4GLtechnologyforMORET,appliedandprovedthisframemodelbyinstance.5.Introducedtheeffectofenterpriseinformation4GLERPIVintegrationbaseonthisframemodel,analysisandcomparedthestatusofbusinessprocedurebeforeandafterimplementtheinformationintegrationofERPandMES,summarizedthevaluablechangetoMORETafterimplementtheadvancedtechnologyofenterpriseinformationintegration,including:theinformationflowinthemanufactureprocedurebecamemorefluent,moretimely,moreexact;thehighervisibilityofusageofenterpriseresourceinthemanufactureprocedure;improvedthetraceabilityandcontrollabilityofproductionmanagement;bringsupporttodecisionofadjustmentandoptimizationforenterprisebusinessprocedureandmanagement.6.Throughtheinstance,approvedthereasonabilityoftechnologyandapplicationvalueinreality,summarizedthefeatureoftheframemodelofintegration,founddisadvantageofit,bottomforthefutureresearchontheory.KeywordsERP,4GL,INFORMATIONINTEGRATION,INTERFACE,MES4GLERP4GLERP4GLERP111.1EnterpriseResourcePlanning,ERPERPERP1.2.MESSFCERP/MES/SFC3.ERP4.ERP5.ERP6.ERPPDMCADCAM7.ERP-InternetERP[1][2][3]ERP1.ERP2.3.[4]1.24GLERP21.2.1ERP20(1)PDMEDIDSSERP(2)OLTPOLAP(3)ERPClient/ServerWebInternet/Intranet(4)[5]ERP20ERP863CIMS1998CIMSTQCSE863/CIMS[6]2090SDRCMetaphaseEDSImanIBMPM[7]ERP4GLERP3ERPERPERPERP[8]ERP[9]4CPCAD/CAE/CAPP/CAM/PDMERPERP4CPInternetInternetInternetSCMCRM[10]ERPERPERPERPERP[11]4GLERP4Internet[12][13]4GLERP4GL1.2.2ERPCRMSCMDRPMESERPWrapper/MediatorWrapper/MediatorWrapper/MediatorMediatedschemaWrapperMediatorWrapper/MediatorWebServicesWebServiceWebService4GLERP5[14]ERPAPICSERPTEIGGERPERPIIERP1SCM2SCM34APS5678[15]ACIDCIEAI[16][17]4GL4GLIT[18]4GL4GL[19][20]1.34GLERP64GLERPERP1.4ERP4GL4GLERPERPSageX3ERP4GLSageX3ERPSageX3ERP4GL4GLERPMES4GLERP722.1ERPERPERP2.1.1SupplyChain“”“”80Logistics“logistics”90“logistics”“”“logistics”“”“”ERP4GLERP82.1.2ERPERP1234567ERP2.1.3ERPERPEnterpriseResourcesPlanning“”1GarterGroupInc.MRPIIManufacturingResourcesPlanning“”SupplyChain2/4GLERP32-1ERPFig.2-1ERPConceptHierarchy4GLERP9ERP2-1“ERP”“”ERP“”“”“”“”“”ERP“”“”“”ITERP“”MRPIIMRPITMRPII“”“”“”“”ERPMRPII“”“”2.1.4ERPITERP//ERP4GLERP10[21]2.24GL4GL(FourthGenerationLanguage)4GLSQLMODULA2SMALLTALK804GL“”“”4GLCOBOLPL/14GLLINCNOMADIDEALFOCUSNATURAL4GL4GLPowerBuilderDelphiINFORMOX-4GL(FourthGenerationLanguage,4GL)4GL804GL“”“”19854GL4GL4GL4GL904GLOracleInformix4GLSQLWindowsPowerBuilder4GLERP11“”4GL2.2.1(1)41GL2GLFORTRANALGOLBASICLISP3GLPASCALALGOL68FORTRAN774GLSQLMODULA2SMALLTALK804GL“”“”4GLCOBOLPL/14G