上海交通大学硕士学位论文基于数据仓库的区级统计业务流程优化研究——以上海市闵行区为例姓名:郭卫民申请学位级别:硕士专业:公共管理指导教师:谢海光20050601IV1V12003(2)23VITHERESEARCHOFOPTIMIZINGOFSTATISTICALWORKFLOWBASEONDATAWAREHOUSETakeMinhangDistrictShanghaiCityForExampleABSTRACTThemanagementsystemofthecurrentstatisticalworkflowofourcountrywascreatedundertheplannedeconomy.Ithasworkedverywellatthattimeandmadebigcontributiontothedevelopmentofsocietyandeconomy.TheBiggestcharacteristicofthatsystemistocombinestatisticalworkflowandconstructorganizationaccordingtoindustry.Itissimilarfromthenationalbureauofstatisticstocountybureauofstatistics.WiththeStatisticalBureauofMinhangDistrictisanexample,thewholestatisticalworkflowismadeupofsomeindependenceindustrystatisticalworkflow.Everyindustrystatisticalworkflowrespectivelycarryoutsameprocesssteps.ThesestepsincludeDesigningrulerandmethod,Collectingdata,SendingDatatosuperiorstatisticalbureau,Analyzingandforecasting.Thiskindofstatisticalworkfloworganizinghas8disadvantages.Thefirstisthewholeefficiencyislowly,difficulttoincrease.Thesecondisthedataisdifficulttoshareandcan'tguaranteedataconsistent.Thethirdisthereportcategoryistoomany,mistakesoccurfrequently.Theforthisanalyzingbasedonstatisticaldataisnotenough,viewpointnotprofound.Thefifthisthecategoryofreportistoomany,mistakesoccurfrequently.Thesixthisthesystemflexibilityisnotenough,anditisunresponsive.Theseventhisthebasicinformationofunitisdisordered,theintegralitycan’tbeensured.Theeighthisthedatasecuritycan’tbeensured,thedatacan'tbesavedoveralongperiodoftime.Oneofthemeasuresofovercomingthesedisadvantagesistomakeuseofthedatawarehousetechniquetoreformthestatisticalworkflow.Themainideasarelistedbelow.Wereformthecurrentstatisticalworkflowwiththetechniqueofdatawarehouse,inotherwords,webreaktheworkmodelwhichorganizeallofstatisticalworkaccordingtoindustryandcreatethenewworkflowaccordingtodataprocessflow.Creatingdatawarehouseasthecenterofallworkflowsurrounding,ensuringconsistencyofalldata,sharingVIIdatawitheveryworkflow.Implementnewmethodofgatheringdata,whichgatherdatafromInternet.Changestructureofstatisticsystem,createDataCenter,DesignCenter,DataCollectCenter,ProcessCenter,AnalysisCenter,IssuanceCenter.Accordingtheseideasabove,theStatisticalBureauofMinhangDistricthasmadesomeprogressondataconcentrativemanagement,collectingdataonInternet,developingapplicationbasedondatawarehouse,issuedataonInternet.KEYWORDS:statistic,workflow,optimize,datawarehouseIIIII,1.11.1.1statistics171.1.2ESIA(BusinessProcessReengineering)CustomerCompetitionChange2,,BPR“”,“”,“”,“”“”,,,,,·,,,,,BPR,,,,,3901.1.32()20045780“”WilliamH.Inmon“”4Web1.2,1.2.15194910195283,,,19941354WilliamH.Inmon,20014345200261992MPSSNA“”“”GDDSSDDS1.2.2“”“”1.3 1.3.161.3.26,20041~27~871-11.3.31.3.41-21-21.4Internet71.4.11-21.4.21.4.37200331.4.4Excel6882004241.4.79,,,,,10,2.1A09WilliamH.Inmon,200112110200348112-1A1122-2A11120001212200027132-376766676131999372.2DBF14(GENSYS)GENSYSGENSYS1215SAS2550200092005(“TheFederalGovernmentwillprovideallservicesofthefederaladministrationelectronicallyby2005”)EDR20051420036,2-42-42.3“”Internet152-5152002212.42-62.516Internet2-71619992182-717181719991121820059StatisticsFromAtoZ192.6,,,,2-82-52-9192002152-62-7,2-42-102.724123 202.821202003(2)1121ChristopherM.King20032332001200320043.1XMLInternetInternetABInternetInternetInternet3.22003113.322Internet1992GDPInternetIntranetInternetInternet1992INTRANET/3.43-13-1WebOracle222004(3)423OracleMicrosoftExcelODBCOracleInternetODBCOracle3.52001(http://tj.shmh.gov.cn)3-223JohnAdolphPalinskiOracle9iDeveloper:DevelopingWebApplicationwithFormsBuilder20042413-23-33-3“”[1],()[M],,,1996[2],[M].,,2001[3]DonaldJBowersox.LogisticalManagement:TheIntegratedSupplyChainProcess[M].NewYork,McGraw-Hill,1998[4].[M].,,2001[5].E..[M].,,2001[6],..,,2001[7].[M].,,2001[8].[M].,,2001[9],.[M].,,2003[10]()..[M],,,2002[11],[M],,,2004[12]..[M],,2000[13].[M].,,2001[14].[M].,,1998[15].[M].,,1996[16].[A].,,2002[17].[A].,,2001[18].[A].,,2002[19],.[A].,,2003[20].[A].,,2005[21],.[M].:,1994[22]WilliamH.Inmon.[M].,,2001[23]W.H.Inmon.BuildingtheDataWarehouse(ThirdEdition)[M].JohnWiley&Sons,2002[24]RalphKimballMargyRoss.TheDataWarehouseToolkit(SecondEdition)[M].JohnWiley&Sons,2004[25]GeorgeM.Marakas.[M].:,2004[26]RogerSPressman.SoftwareEngineering:APractitioner’sApproach[M].,,1999[27].[M].,,2004[28],..,,2003[29]MichaelJCorey.Oracle8[M].,,1998[30].[M].,,2000[31]JeffreyDUllman,JenniferWidow.AFirstCourseinDatabaseSystem[M].,,1999[32],.[M].,,1995[33].[M].,,1999[34].[M].,,1999[35],.[M].,,1988[36].[N].,1997[37].[M].,,1997[38].[M].,,2004[39].BICM[J].,,2004(3):26[40].[J].,,2004(3):26[41],.[J].2003(2):11[42].[J].,2003(2):11[43].[J].,2004(5):26[44].[M].,,2005[45].()[M].,,2004[46]JohnAdolphPalinski.Oracle9iDeveloper:DevelopingWebApplicationwithFormsBuilder[M].,,2004[47]ChristopherM.King;CurtisE.Dalton;T.ErtemOsmanoglu..,,2003[48]CarltonR.Davis.IPSec:VPN.,,2002[1]204552基于数据仓库的区级统计业务流程优化研究——以上海市闵行区为例作者:郭卫民学位授予单位:上海交通大学相似文献(10条)1.学位论文夏登文数字海洋基础数据及业务流程建模方法及相关技术研究2006随着国家进一步加强海洋开发,在海洋工作中,为了发展海洋经济、保护海洋环境、维护海洋权益、合理开发海洋资源,迫切要求开展数字海洋信息系统的建设工作