基于ERP的胜利油田综合业务信息系统的研究与开发

上海交通大学硕士学位论文基于ERP的胜利油田综合业务信息系统的研究与开发姓名：陈建江申请学位级别：硕士专业：计算机技术指导教师：郑东;王剑南20030901ERP1ERP2ERP3ABSTRACTERP,EnterpriseResourcePlanning,isaconceptofManagement+IT,itisnotonlyasoftwaresystem,butalsoacomprehensivemanagementsystemwhichintegratestheorganizationmodel,enterprisestandard,informationtechnologyandimplementationmethodasawholebody.ThispaperanalyzesandstudiesERPtheoryandrelationshipbetweenERPandSupplyChain,BusinessProcessReengineer.ThedivisionoflaborandcooperationintheSupplyChainrealizetheconstantincreaseofthewholeSupplyChainvaluewiththecapitalstream,goodsstreamandinformationstream.ThecombinationofERPandBPRisacertaintrend,bythewayofthoroughlyreconsideringandredesigningtheBusinessProcesstomaximizethefunctionintegrationofthetechnologyandmanagementwithadvancedmanufacturetechnology,informationtechnologyaswellasthemodernizedmanagementmeans.Undertheguidanceoftheabovetheory,theIntegratedBusinessInformationSystemofShengLioilfieldbasedonERPwasdesignedanddeveloped.AccordingtotheoverallplanningofSinopecERP'ssystemconstruction,thesystemrealizestheintegratedapplicationandmanagementinthecomputernetworkenvironmentoftheoilfieldenterprisebusiness,achievesthesharedapplicationoftheintegratedinformationresourceandthedifferentbusinessneedsoftheoilfieldenterprise,providesthetechnicalmeansfortheheadquartersupervisingtheoperationofproductionandtheinformationsupportforGM’spolicydecision.Theconstructionofthesystemisdividedintothreeleveltasks:Thebureaulevelintegratedbusinessinformationsystem,Thefactorylevelintegratedbusinessinformationsystemandthebasiclevelintegratedbusinessapplication,inaddition,forthespecialdatabase,wedevelopWellLoggingDatabaseandApplicationSystem“.AsforthedesignofShengLioilfieldERP,itismainlybasedonthecomparisontotheSAPmodules,ontheoperationlayerdefinestheschemethatistheparallel,thechange,thesubstitutionandtheincreaseofallkindsofsoftware.FinallyonERP4managementlayer,itcloselycombinesallinformationresourcesbythewayofR3inordertoachievetheresourceshareandmaketheapplicationefficiencyofeachlinkofthebusinessresourcesimproved.Inthepaper,thedesignofthedatacenteroftheoperationisapracticalapplication,expoundstheapplicationeffectoftheIntegratedBusinessInformationSystem.Thesystemextensivelycollectsthedataofthedevelopmentofoilfield,theoil&gasexploration,thedrillingengineering,thepetroleumengineering,thepublicengineering,therefineryproduction,thecommunityserviceandthebusinessadministration.ItbuildsreasonabledatabasesystemandusesthepopularBrowser/ServerandOracle’sdatabasetechnologyatpresenttodescribethesystembymethodofdiagramandcharacters.Itrealizeseffectivelyandextensivelythecompleteshareandthefullapplicationoftheinformationintheproductionofoilfield,suppliesthescientificbasisforGM’spolicydecisionJ2EE'stechnologyhasbeenutilizedinthedesignofoperationdatacentersystem.Inthepaper,JSPtechnologyintheJ2EE'smodelhasbeenstudied,severaltypicalprogrammingmodelshavebeendetailanalyzed.Theapplicationmodelutilizedisderivedfromthemulti-layerapplicationmodelbasedonWeb,andthemodelusedintheoperationdatacentersystemisgivenout.AnotherimportanttechnologyinJ2EE'smodelisEJB,ItisastandardarchitecturalstructureintheenterpriseapplicationsystemthatJavalanguageuseittodevelopthedistributedandtheObjectOrientsystem.EJBcontainermaintainsthedatabaseconnectionpool,thisconnectionpoolistransparenttotheEJBcomponents,thecomponentislinkedtothedatabasenotbytheabsolutenameofit,butbythelogicalname,itcanrealizesthesameconnectionusedbymanycomponents.ThefinalpartofthispapergivesasummerizationofthepaperandthefutureERPdevelopment.KEYWORDERPSupplyChainBusinessProcessReengineerIntegratedBusinessInformationSystemOperationDataCenterDesignmodelofprogramEJBERP71ERP8ERP9SupplyChainManagementERP10ERP11ERP12ERP13ERP14ERP15ERP16ERP172ERP18ERP19llllERP20llllllllllERP21llllERP22llllllllllERP23lllllERP24ERP25ERP262-5ERP27ERP28ERP292-10ERP30ERP31ERP32lllllüüüüüüüERP33ERP34ERP35llllERP36ERP37ERP38ERP39ERP40lllllllERP41lERP42ERP43ERP44ERP45ERP46ERP473ERP48ERP49ERP50ERP51ERP525ERP53ERP54ERP55ERP56ERP57ERP58ERP59ERP60ERP61ERP62ERP63ERP64ERP65ERP66ERP67ERP68llERP69ERP7012ERP71123ERP72WebWebASP(ApplicationServiceProvider)WebInternetInternet4-7WebWebHTML/InternetWebWebHttpHTMLAppletAetiVaXScriptWebASPJSPCOIServletHTTPHTTPERP73WebWebWebWebWebInternetHTMLWebVBScriptJavaScriptDCOMHTMLActiveXAppletWebWebWebWebWebFormCGIServletASP[ActiveServerPage]JSPWebWeb4-8Web4-74-8HTMLASPJSPWebWebJavaWebJavaWebAppletRMIJavaBeansEJBServletJSP4-9JavaWebInternetWebWEBHTTPERP74lJSPJavaASPlServletJSPCGIlJavaBeansCOMlEJBWebWebWebWeb1/Web/ASP(ApplicationServiceProvider)InternetWebDNAJavaASP(ApplicationServiceProvider)ASPJSPSQL4-10JSP/ASPDataSQLERP75SQL4-84-9JSP/ASPSQLTableSQL2MVCMVC4-12View:WebJSP/ASPDataSQLTableClassViewControllerModelERP76Controller:ModelviewModelModelModelModel:ModelJavaJavaSerializableCaseCADWebWebMVCWebWeb4-13ViewControllerModelJSP/ASPDataSQLERP773Java4-14JSPServletJavaBeanJDBC4-13JSPJSPHTMLHTMLJSPAppletHTMLJavaScriptJavaScriptJSPHTMLIC(InteractionController)ICServletICJSPHTTPHTTPHTTPICJSPICModelComman