一个企业管理信息系统的设计与优化

华中科技大学硕士学位论文一个企业管理信息系统的设计与优化姓名：孙宁申请学位级别：硕士专业：软件工程指导教师：覃中平20051028IInternet/Intranet(MIS)/(Client/ServerC/S)MIS/(Browse/ServerB/S)MISB/SC/SB/SMISB/SB/SC/SB/SB/SB/SServer(PC)OS(MicrosoftWindowsServer2003)Database(MicrosoftSQLServer2000)WebServer(InternetInformationServer6.0)B/S(ActiveServerPagesASP)(ComponentObjectModelCOM)C/SVBVC//IIAbstractWiththerapiddevelopmentofInternet/Intranet,thewayofdesigninganddevelopinginformationsystemofenterpriseshaschangedalot.ThetraditionalwayofMIS(ManagementInformationSystem)development,whichisbasedontheClient/Server(C/S)architecture,hasbeenreplacedgraduallybythedevelopmentofMISthatbasedontheBrowse/Server(B/S)architecture.AlthoughB/Sarchitecturehasbeenwidelyusednow,theC/SarchitecturehasmuchmoreadvantagesthantheB/Sarchitectureinsomespecialapplications.WithacaseofdesigninganddevelopingasmallMIS,whichisdevelopedfortheutilizationofinformationonourcompany,wecomparedthetwoarchitecturesinthispaper.Inthedesignmentofthissystem,withtheresultsofcomparingabovetwoarchitecturesandtheircontextofapplying,wedividedthewholesystemintofivearchitecture-independentsubsystems:ane-commercesubsystemwithB/Sarchitecture,astoragemanagementsubsystemwithB/Sarchitecture,aworkflow-observingsubsystemwithC/Sarchitecture,asalesandservicescontrollingsubsystemwithB/Sarchitecture,andanemployee-trainingsubsystemwithB/Sarchitecture.AndinthepartofdevelopmentwiththeB/Sarchitecture,itdiscusseshowtogetasatisfyingperformancewithalowcost.Webringforwardsomeapproachesofperformanceenhancementintheaspectsofhardwareconfigurationandsoftwaredesignandsoftwarecoding,andthenwevalidatethemthroughsomedatafromtheexperimentsandtests.Theserver’sconfigurationcontainsthefollowing:Server(PC),OS(MicrosoftWindowsServer2003),Database(MicrosoftSQLServer2000)andWebServer(InternetInformationServer6).ThesubsystemsbasedonB/SarchitecturearemainlydevelopedwiththeASP(ActiveServerPages)andCOM(ComponentObjectModel)technology,andtheothersubsystemsbasedonC/SarchitecturearemainlydevelopedwithVB&VC.KeywordsManagementInformationSystemB/SArchitectureC/SArchitectureQueryOptimization111.1Internet/Intranet/WebB/S(Brower/Server)WebInternetWeb[1]10%2.9%70%50%[2]PCERP2C/SB/S2004MISC/SB/SC/SB/SC/SB/SC/SB/SWebASPJSPPHPASPActiveXServerPageWebWebASPWeb[3]JSPJavaServerPageJSPJavaJavaHTTPServletURLJavaBeanJSPJavaServletServletJSPJavaServletJavaJSPPHPPersonalHomePagePHPScriptPHP43PHPPHPlib“”script“”PHPPHPASPJSPJSPJSPPHPPHPPHPPHPASPJSPASPMicrosoftWindowsdCOM/DCOMActiveXDCOMTranscationServerJSPSUNJavaJavaClassEJBEJB/CORBAApplicationServer1.2MISB/SC/SMISMISB/SERPB/SC/SERP4B/SB/SC/SB/SB/SB/S522.1ASPASPWebHTMLActiveXWebWebASPActiveXASPWebASP.aspHTMLASPASPWebWebASPASPWebServerASP.aspHTML.aspASPMicrosoftVisualInterDevMicrosoftFrontPage[4][5]ASPWebServerASPHTMLVBScriptJavaScriptASPActiveXActiveXServerComponentsAutomation(ActiveXServerComponents)ComponentASPActiveXServerComponentsADODBFileSystemObjectVBVCASP.aspHTML6ASP.asp[6]2.2C/SB/SMIS//[7]1/C/S80/(2-1)///[8]2-1/2B/SInternet/Intranet90/(2-2)/Internet/IntranetInternet/Intranet//ClientServer7///Web[9][10]Database2-2()/(2-3)()/BrowseServer8[11]2-33C/SC/SC/SC/S/ClientMiddlewareServer9Internet/WebInternet//WebTCP/IPHTTP(Browser)(Webserver)(Database)C/SB/SB/SB/SC/S2.343DBMS10DBMSSQLSQLSQL/SQLSQL[12]2.4WebASPC/SB/S1133.1153-13-1ERP12Internet2C/SInternetB/SB/S3.213-212PC1333-23-33-314123423-43-4115234567893-53-5161Internet23()4533-63-61172PCPCPC343-73-71OEM23OEM418543.3C/SB/SB/SMIS[13-16]1I/OI/ORAIDI/OI/OI/O1I/OI/OI/Oλλ−+++−==cdelaytransizerpms.avgTimeSpeed/BlockSpeed/5.0Time1111serverTimesystemTime(3.1)TimesystemI/OλI/OTimes.avgSpeedrpmBlocksizeSpeedtranTimecdelay193.1I/O5400RPM7200RPM10000RPM15000RPM10000RPM]I/OI/OI/OI/OI/OIDE/UltraATASCSISCSII/OIDE/ATA3-13-1IDE/ATASCSIIDE/UltraATASCSI()16816()100MHz80MHz(Ultra3Ultra160)160MHz(Ultra4Ultra320)1200MB/s320MB/sIDEI/OI/O2M8M8M2WebI/OWebI/OWebI/O20B/SMISI/OI/OWebI/O7200RPM2MIDE3WebI/OI/OI/OI/OWebI/Oλλ−+−==netsizedelaysserverSpeedPTimeTimesystemsTime/11..11(3.2)λλ−+−==netsizedelayrserverSpeedPTimeTimesystemrTime/11..11(3.3)Times.systemI/OTimer.systemI/OλTimes.delayTimer.delayPsizeSpeednet3.23.3WebI/OI/OCPUCPUI/OCPU4WebI/OWebI/OWebI/OI/O2[17]B/SOracleMYSQLIBMDB2SQLServerAccess21OracleSQLServerDB2WindowsNTServerMicrosoftSQLSERVER2000IBMDB2ORACLE9iMicrosoftSQLSERVER20001SQLServerWindowsNT2000Windows9xSQLServerSQLServer234SQLServer7.056InternetSQLServer2000SQLServer2000SQLServer3[18][19]1I/OWindowsNTServerSQLserver20004-8G2G2MicrosoftSQLServer20001.5Microsoft3SQLServermaxservermemory1.52233.42344.14-14-1WebCPUIntelP42.4GHzIntelP42.0GHzDDR2GDDR1G120GB8MBCache10000RPM80GB2MBCache7200RPMDVDCDROMMSWindows2003MSWindows2000Server\WebMSSQLServer2000MSIIS6.04.24.2.1[20]CPUI/O112423[21]234.2.2[22]1WHERE2/3FROM4235672589=WHEREBETWEENLIKEWHEREINORWNERENOT!=WHERE[23]4.2.3SQL[24]SQLSQL[25]4.2.4SQL()[26]check264.34.3.1SELECTSQL[27]SQL1234SQL[28]512(groupbyorderby)3274564.3.2DBMS[29]DBMS[30]12sort_basedmerge_scan[31]314285FALSETRUEDBMS4.3.31I/OCPUWebI/O+CPU+WebTCD=C0+D*C1DC0C1[32]21WebADORecordsetPageSizePag