钢贸公司决策支持系统的研究和实现

上海交通大学硕士学位论文钢贸公司决策支持系统的研究和实现姓名：靳斌申请学位级别：硕士专业：计算机技术指导教师：李治柱;姜良玉2006120112007182200718200718-2-‘sabusinessdirectorinresolvingtheproblemsinDecisionSupportSystem,theBItechnologyusesprofessionalknowledgeandspecialdataminingtechnologytogetkeyfactorsinsolvingtheproblemsofprofit,enterprisemanageretc.Ourresearchworkincludesfollowingaspects:1.StudyDSStheories,constructDataMining,Olap,andweresearchtheBusinessIntelligence2.ApplyBI,wedeveloptheDssbyusingMicrostrategy7i.Researchonthekeytechnologiesinsystemimplementationandfinallyrealizethebasicfunctionalitiesofthesystem.ThestudyresultofthisarticlewilldogreatbenefitsonthedesignofDSS.Itimprovestheanalyzeofbusinessdata,givesthesupporttothemanagement.KeyWordsDSSBISteelData;-6-1.1JFE200571727[1]1.11.1L1L3L4L5SCMERPL3L2-7-1.1Table1.1ITstructureoftheSteelEnterpriseEthernet/ATML1L2PLC/DCSPLCAPCL3MES1234L4ERPSAPR/3L4SCMAspenTechI2ManugisticsL4CRMSiebelSAPL4E-CommerceEsteelL5DSSSAS[1]-8-()()()()1.1Figure1.1ModelofInformation1.2Figure1.2DevelopmentofEnterpriseinformationizationBusinessIntelligenceBI-9-[2]OLAP1.22070ManagementInformationSystemMISMISDSS[12]1980SPrague[3]DSSDSSDSS1981BoneahDSSLanguagSystemLSProblemProcessSystemPPSKnowledseSystemKS[4]DSSDSSYuWenbinPetrovPlamenVStoyenAlexanderDCameronIanTTarantlllsCDKiranoudisCTGISDSSDSS-10-DSSDSSCIMSANN[5]KD[6]90DSSGDSSBSDSS[7]1.3MicroStrategy7OLAPOLAP,OLAP-11-1.4OLAPMicroStrategy-12-OLAPMicroStrategy2.1W.H.InmonITBuildingtheDataWarehouses[8]W.H.Inmon50GB50GBW.H.Inmon2.1.1[9][10]W.H.Inmon-13-Inmon••••1./[11]Inmon2.12.1Figure2.1Subject-orientedofDatawharehouse-14-/[12][13]2.[14]2.12.1MF10xymalefemale2.2-15-2.2Figure2.2IntegratedData3.[15]2.3-16-2.3Figure2.3Timevariancyofdatawharehouseandoperationaldata[16]4.2.4Figure2.4EementaryOperationofdatawharehouse-17-[17]1%2.1.21.ER[18]-18-2.ERER[19]ERERERERERERERERERERERERISERFactDimensionMeasureMeasurement-19-1999199819972.5Measurement1999Armonk111001CellPhone2.5Figure2.5LocationDimensionERSQL-20-3.[20]ER2.1.31.-21-[21]2.6Figure2.6DatawharehouseArchitectureIS-22-2.72.7Figure2.7DataMartarchitecture(2.8)-23-2.8Figure2.8Bottom-orientedstructure2.92.9Figure2.9Up-orientedstructur-24-2.22.10Figure2.10ViaragetheProjectofDatawharehouse2.10-25-[22]2.112.11igure2.11CollectofUserDemandER-26-2.12Figure2.12Flowoftheconstruction[26][23]-27-[24]2.13Figure2.13DesignphaseER-28-2.2OLAP2.2.1OLAPE.F.Codd1993OLAP:On-LineAnalyticalProcessing[25]OLAP[27]OLAPOLAP[28]Multidimensional[29][30]OLAPOLAPOLAPOLAPOLAPSliceDice(Drill-down)(Roll-up)RotateOLAPOLAPOLAPOLAPOLAP[31]OLAPOLAPOLAPE.F.Codd1993CoddOLTP[32]SQLCodd-29-OLAPOLAPOLAPOLAP2.2.2(OLTPOn-lineTransactionProcessing)IT[35]-30-OLAPOLAP2.2.3OLAPOLAP[36]DimensionLevelMemberMeasure20061$100000OLAPDrill-upDrill-downSliceDicePivotDrill-downDrill-up/(Roll-up)Drill-upDrill-down[37]2.2.4OLAPOLAP[38]OLAPOLAPOLAPOLAPOLAPRelationalOLAPROLAP[38]OLAPMultidimensionalOLAPMOLAPOLAPHybridOLAPHOLAP-31-1.ROLAPROLAP[39]SQLOLAPROLAPRDBMSOLAPSQLOLAP(cube,rollup)2.MOLAPMOLAPOLAPMOLAPOLAPPhysicalOLAPROLAPOLAPVirtualOLAP3.HOLAPMOLAPROLAP2.1,OLAPOLAPOLAPHOLAPMOLAPROLAPHOLAPHOLAPMOLAPROLAP-32-2.1OLAP[40]Table2.1Viarancyoftherolapandmolaprolapmolapolapmolapolapsqlolap(cube,rollup),rdbmstb(10~20g)sqlsql?????2.2.5(ROLAP,RelationalOLAP)-33-(MOLAP,Multi-DimensionalOLAP)(DesktopOLAP)/ROLAPMOLAP1[41](=-)(=-)2.142.14Figure2.14Datastructur(FactTable)(DimensionTable)[42]-34-SQL(tablejoinandgroupby)ROLAPSQL(Star-Schema)(2.15)[43]2.15Figure2.15Star-schemaModel(snow-flakeschema)2.16.-35-2.16Figure2.16Snow-flakeSchemaGroupby8338Groupby[44]22.17ROLAPMOLAP-36-2.17ROLAPMOLAPFigure2.17ViarancyoftheROLAPandMOLAPROLAPMOLAPMOLAPMOLAP(DataFile)x,y,z()MOLAPMOLAP(Outline)MOLAPROLAP()ROLAP12.18-37-2.18Figure2.18DefinefilestructureMOLAPMOLAPROLAPMOLAPMOLAPROLAPMOLAP2.19-38-2.19Figure2.19sparsepeace-keepingcrowdedUygurunifiesprocessingmodel(IBM)MOLAP(IndexFile)MOLAPROLAP[28]MOLAP[45](DataBlock)I/O()I/O()MOLAPROLAP/-39-ROLAPMOLAPMOLAPTBMOLAP100GBROLAPMOLAP3(What-if)ROLAPMOLAPROLAPMOLAPIBMDB2OLAPServer5%8%()OLAPOLAPDB2OLAPServer-40-/()OLAPServerROLAP(normalisedesign)002003ROLAPMOLAPMOLAPDB2OLAPServer003ITOLAP//OLAPDB2OLAPServerOLAPMinor()1250%ROLAPMOLAPITOLAP-41-2.3BIBusinessIntelligence[46]OLAPOLAPOLAPOLAPDataMiningDataWarehouseDataMart(OLAP)E.F.Codd1993OLAP12OLAPOLAP(OLTP)-42-3.1(BusinessIntelligence),,,,ERPERPCRM[47]ITITERP8-43-3.2BI(ERP,OA)OLAPSERVEROLAPWAPPDAPC3.13.1Figur