数据仓库在邮政量收系统中的应用问题研究

华中科技大学硕士学位论文数据仓库在邮政量收系统中的应用问题研究姓名：罗科迈申请学位级别：硕士专业：工商管理指导教师：徐贤浩20061024I21IIAbstractThe21S`centuryisacenturyofinformation.Theapplicationofinformationtechnologyhasbecomeanessentialcomponentforthesurvivalanddevelopmentofenterprises.Thisstudyaimstohelptheenterprisesunderstandthecurrentinformatizationtrendandtomasterthemethodsofinformationtechnologyapplication.IhopethiswillbeofsomesignificancefortheinformationtechnologyapplicationinthepostalenterprisesinChina.Firstly,thisthesishasdiscussedthesurveyanddevelopmentofinformationtechnologyofdatawarehouseapplicationinChina'spostalmeteringsystemandhasanalyzeditscharacteristicsandfunctions.Secondly,ithasanalyzedtheproblemsandcausesofthelowlevelofinformationtechnologyapplicationinChina'spostalenterprises.Thirdly,DuetothefactthatChinaPostisalargescaleenterprisewithhighlycomplicatedoperationanditsdatawarehouseisdifficulttoconstruct,afeasibledatawarehouseconstructingsolutionisproposed.Lastly,ithasproposedsomesuggestionsandproceduralstepsforsuchapplication,andhaspredictedtheperspectivesoftheapplication.Thisstudyhasappliedinvestigationmethod,comparisonmethod,dataanalysisandstatisticsmethodandcasemethodinordertohelpthereadersbetterunderstandthewholearticle.TheprimaryachievementofthisstudyisthatithasproposedsomesuggestionsandapplicationmethodsontheinformationtechnologyapplicationinChina'senterprises.TheconclusionofthisarticleisthatinformationtechnologyapplicationinChina'senterprisesshouldbeledbytheinnovativeconcept,basedonhumanandinformationtechnology.Inparticular,weshouldattachmoreimportancetothepracticability,applicabilityandtimeefficiencyandtomaximizingtheconcentratedintegrationofinternalandexternalresourcesbasedontheactualconditionsofeveryindividualenterprise.Throughtheinnovationofinformationtechnology,wewillbeabletobringalongtheinnovationofenterprisemanagement,toconvertinformationtechnologyintoproductiveforcesandtoachievebenefits,tobringthemagnifyingandvalue--addingfunctionsofinformationtechnologyintheChina'senterprisemanagementintofullplayandtobuildupthecompetitiveedgeoftheenterprises.Keyword:InformationtechnologyInformationmanagementsystemDatawarehousePostalmeteringsystem□_____□“√”111.1MISIMSMISMISMIS[1][2][3]2FoxproSybaseoracle1.2MIS--ManagementInformationSystem[4]MISMIS[5]80“”WilliamH.Inmon[6]OLAPOLAP[7](OLAP)E.F.Codd1993OLAP12OLAPOLAP(OLTP)[8]OLTPon-linetransactionprocessingOLAPOn-LineAnalyticalProcessingOLTP3OLAPOLAP,[9]OLAP,“”,“”,(dimension)OLAP[10]OLAP[11][12]OLAP12……nSliceDiceDrill-downRoll-upPivot[13]OLAPMOLAPROLAPMOLAPROLAPOLAPOLAP[14]“”(BillInmon,BuildingtheDataWarehouse)4IBMAlmadenAT&T[15]“WHIPS(WarehousingInformationProjectatStanford)”IBMAlmadenQuest”AT&T(Materializedview)OLAP[16]1.3“”;::5622.1“”“”“”312338“”752.21998123017678“”“”“”200586.2162118142813821177ATM227200589%36588806122674922005----EMS“”“”212542162“”2006,,“”92.32.3.12001711EMS22.3.2“”1“”101234220Kg61430%429.830.82122.3.3111271233.1[20]1OAMIS260043.520[21]ATMIPX.25IP13MISMISMIS2191100100231430152005431277200587554UPU1118311185670006317000715ESB“”“”“”3.213120116ATM9288833.3[21]17[22]1998200512B/Sinternet18210Terradata2001123200581210251223123ERP3.419[23]1;12;231118520451118563.59021MISMISMISMISMIS“”2244.14.1.1W.H.Inmon“”[24][25][26]4.1.2W.H.Inmon[27]123[28]23510309044.1.3OLAP24/[29]OLAP4.1.44-1DBAE-R1~5254.2B/Sinternet[30]2104-1261(DW)(OLAP)(DM);OLAP;AI()OLAI2312724242()OLAPODS//(ETL)—ODS();()ODSOLAPOLAPWEBOLAPODSDW283434-34(//)OLAPOLAP29OLAP9:///(ETL)ETL//4.312303ETLETLETL45B/SWebOLAP6OLAPOLAPOLAPCPUOLAP7318114.44.4.1:1SybasePowerDesigner;2BMDB2;31ETL;4HyperionAnalyzerHyperionPerformanceSuite;5OLAPserverEssbase.()ETLTB/S()324.4.2ETLETL[31]ETLETLETL444-4ETL3ETL33(34):.[32].[33]1/./4.4.3[34][34]334----.level::OLAPServerCube[35]DWCube4.4.4OLAPStrutsEJBBo,HyperionHyperionAnalyzerHyperionPerformanceSuiteStrutsOLAP:.;3514.53103103691.7%89.5%92.2%93%92.4%“6”“”361233755.1[36]MISMISMIS[37]MISDSSIPCOAOAIntranetMISIntranetIntranetMISMISCSClient/Server——/InternetMISBSBrowser/Server——/BSCSMISBSMIS[38]InternetMISMIS38InternetInternetMISMISInternetInternetMIS[39]“(snow-flake)”“”“”[40]?“”“”??DSSOLTP.OLAPOLTPDSSOLAPCache:[41]39;“”;AB()[42]40“NCRTeradata(SOA)”NCRTeradata·SOATeradataSOASOA415.25.2.1MISMIS12342;4[43]5.2.2[44]1;2434490[45]4520061046[1],.——MIS.,200017(12):122-124[2]....2002[3]ChaudhuriS,DayalU.AnoverviewofdatawarehousingandOLAPtechnology.SIGMODRecord,1997,26(1):65-74[4],,..().2004(03):15-16[5]..:,2003[6]WilliamH.Inmon.(3).:,2003[7]GeorgeM.Marakas.—..:,2004[8],,.MIS.(),2004,(06):111-113[9],...2006,(26):54-55[10]..().2006,(2):18-19[11]Royal,Weld.DoDatabasesReallyWork.Sales&MarketingManagement,2005,(9):66-74[12]Kling,Julia.OLAPGainsFunsamongdataHungryfirm.Computerworld.2001,(1):43[13]Cafasso,Rosemary.OLAP:whoneedsit?.Computerworld,1995,(3):12-15[14]..,2005,(2):48-49[15]..,2006,(1):22-23[16],.OLAP.,2005,(2):77-81.[17],..,2002.15(2):41-4547[18]LouAgosta...:,2000[19]..,2006,(5):16-18[20],..,2006,(2):15-16[21]Stephenhag,MaeveCummings.ManagementInformationSystemsfortheInformationAge.,2000[22],,.ETL.,2002,38(24):2