分布式远程故障诊断系统的研制

重庆大学硕士学位论文分布式远程故障诊断系统的研制姓名：唐邵军申请学位级别：硕士专业：机械电子工程指导教师：谢志江200505011InternetWebInternet[1][2][3]::,::(RS-232TCP/IP)2InternetInlandQuantumBently1.2Internet[4][5][6][7][8][9][10][11]1.2.1Internet/Intranet/Extranet/C/SC/S1.11.1C/SFig1.1Two-levelstructurebasedC/SSQL3//B/S1.21.2B/SFig1.2Three-levelstructurebasedB/S1.2.21988(RemoteDiagnosis)(ConsultationofSpecialists)(InformationService)(OlineExamination)(RemoteStudying)()19949SysOptics1995154CTXSQL419971InternetBoeingFordSegateIntelSunTestedMIMOSASMFPBentlyNI1.2.310JieWu(PE)PEPEPE2.2()PE(PE)(/)()()()51.3a),b)Fig1.3a)Physicaldistributedsystemstructure,Logicaldistributedsystemstructure()DCE()OSF()DCE(threadpackage)(RPC)CORBA()OMGDCOM1)2)()3)4)5)6)PEPEPEPEa)b)67)312FFTFourierWigner3:DMDS(DistributedMonitoringDiagnosisSystem)7InternetIRD(InternetbasedRemoteDiagnosis)B/SBSRDES(Browser/ServerbasedRemoteDiagnosticsExpertSystem)1.2.4901.4Fig1.4theprocessofdevicediagnosis8InternetInternetInternetInternetInternet1.31.3.1200220039501064/6/9L0L1L2L3ERPMISInternet1.3.210PLCDCS,InternetInternetInternetB/SB/SJava112Intranet2.1C/S[5][6][19]2.1.1C/S/2.1SQLC/SSQLServerOracle,Sybase2.1/Fig2.1Client/Serverstructuremodel12(Modem)2.1.2C/SC/S(PE)C/S1n2.2C/SFig2.2Structureofremotefaultdiagnosissystembasedtwo-levelC/S13/C/S/Internet2.2B/S[12][13][20][21]2.2.1B/SB/S/InternetWebC/SOracleSybaseDB2MicrosoftSQLServerBrowser/ServerWebCGI(CommonGatewayInterface)(ApplicationProgramInterface)ASP(ActiveServerPage)JSPJDBCJavaappletEJBCGICGICGISQLHTMLAPIAPIWebISAPI(InternetServerAPI)NSAPI(NavigateServerAPI),CGIJSPSunWebADOJDBCJavaInternetBrowser/ServerURLHTMLWEBWEBHTML142.2.2B/SInternetWebInternetInternet2.3[6][18][19][20][21][22][23][24][25][26][27][28][29]4B/SB/S15CDMS2.3.1CDMS:(Intranet).Fig2.3Framestructureofdeviceremotefaultdiagnosis(Internet)(Internet)(Intranet)16Windows20002.4Fig2.4thefunctiondiagramofsoftware172.3.22.3.32.5.5diagramofdataflow18A/DA/D2.6Fig2.6flowchartofdatacollecting19/IE/2.7Fig2.7flowchartofdatacollectingJsp/ServletJavaBean202.8Fig2.8flowchartofpartsoftwareondiagnosiscenter2.3.4WebWebASPJSPPHPWebHTMLWebERP21.NET.NETWindowsDNA.NET.NETFrameworkCOM+CommonLanguageRuntimeCLR.NETVisualStudio.NETHTMLVisualStudio.NETCOM+CLR.NETASP.NETADO.NET.NET.NETJ2EEJ2EESunJavaJava23Java2MicroJava2PlatformMicroEditionJ2MEJava2Java2PlatformStandardEditionJ2SEJava2Java2PlatformEnterpriseEditionJ2EESunJ2EE.NETSunJava.NETJ2EE1)2)223)2.4233,IE3.1[9][23][30][31][32]SQLServer3.1.1MSSQLServer2070IBMSanJoseIBM370SystemR1982IBMSystemRSQL/DSIngresINGRESINGRESDB2OracleSybaseSQLServerSQLServerMicrosoftSQLServer/SQLServerSQLServerSQLServer24SQLServerJDBCJDBCJDBCJDBCJDBCAPIJDBC3.1.2SQLServer2000SQLServer2000JavaJDBCAPIJDBC3.1JDBCFig3.1processofJDBCaccessingdatabase25lPRIMARYKEYlFOREIGNKEYlUINQUElCHECKlDEFAULTlNULL.Figure3.2therelationamongtablesINSTEADOFAFTERTSQLINSERTUPDATEDE