基于數(shù)據(jù)倉(cāng)庫(kù)的電力營(yíng)銷輔助決策支持系統(tǒng)的研究與實(shí)現(xiàn).pdf

1、華北電力大學(xué)碩士學(xué)位論文摘要本文在深入研究了決策支持理論的基礎(chǔ)上，結(jié)合數(shù)據(jù)倉(cāng)庫(kù)、數(shù)據(jù)挖掘和聯(lián)機(jī)分析處理技術(shù)，設(shè)計(jì)并實(shí)現(xiàn)了電力營(yíng)銷決策支持系統(tǒng)。電力營(yíng)銷決策屬于半結(jié)構(gòu)化的決策范疇，缺乏程序化的工作方式，因此構(gòu)建一個(gè)能夠?yàn)殡娏I(yíng)銷決策提供支持的系統(tǒng)具有重要意義。本文在對(duì)電力營(yíng)銷業(yè)務(wù)仔細(xì)分析后確定營(yíng)銷分析主題，并根據(jù)主題設(shè)計(jì)了數(shù)據(jù)倉(cāng)庫(kù)結(jié)構(gòu)和系統(tǒng)整體框架。系統(tǒng)采用基于JZEE規(guī)范的三層體系結(jié)構(gòu)和BS開發(fā)模式，使用了開源的Mondrian作為OL

2、AP服務(wù)器實(shí)現(xiàn)對(duì)電力指標(biāo)的綜合分析，并利用JSP標(biāo)簽庫(kù)JPivot將查詢結(jié)果做了良好的展示。此外，系統(tǒng)實(shí)現(xiàn)了一元線性回歸預(yù)測(cè)算法、粒子群優(yōu)化神經(jīng)網(wǎng)絡(luò)算法、k一中心聚類算法作為模型庫(kù)，實(shí)現(xiàn)售電量預(yù)測(cè)、用電負(fù)荷預(yù)測(cè)、用電客戶細(xì)分功能，達(dá)到了提供決策支持的目的。關(guān)鍵詞:電力營(yíng)銷，決策支持，數(shù)據(jù)倉(cāng)庫(kù)onthebasisofin一dePthstudyingofthetheoryofDecisionSuPPort，byusingtheDataWar

3、ehouse，DataMiningandOn一LineAnalytiealProcessing，thePaPerdesignsandimPlementsthePowerMarketingDecisionSuPPortSystem.Deeision一MakingofMarketingbelongstosemi一structurecategorylackingofnormalformtobefollowed，50buildingDeeisi

4、on一MakingSuPPortSystem15veryimPortant.AfterearefullyanalysisofthePowerMarketingBusiness，thePaPerdeterminesthemarketinganalysisthemeanddesignsthestruetureoftheDataW自rehouseandSystemoverallFramework.ThesystembasesonJZEEsta

5、ndardofthree一tierarehitectureandB5develoPmentmode，usingMondrianwhieh15theOPen一SoureeserverforOLAPtoaehievetheanalysisofelectrietarget，anddisPlayingtheresultbyJPivot.Inaddition，thesystemimPlementsUnaryLineRegressionPredic

6、tAlgorithm，NeuralnetworkforeeastingmodelbasedonPSOAlgorithmandk一eenterClusterAlgorithmastheModelstorehouse.Byusingthesealgorithms，thesystemimPlementsforecastingofelectrieitysalesamount，PowerloadanddividingofeustomertosuP

7、PlythesuPPortfordeeision.ZhengYongjing(ComPuterSeienceTeehnology)DireetedbyassoeiateProf.ZhaoJiantaoKEYWORDS:Powermarketing，deeisionsuPPortsystem，datawarehouse華北電力大學(xué)碩士學(xué)位論文4.1.1營(yíng)銷主題分析模塊....................................

8、..................................……354.1.2指標(biāo)預(yù)測(cè)模塊..............................................................................……404.1.3指標(biāo)監(jiān)控模塊..............................................................................

9、……414.1.4后臺(tái)管理子系統(tǒng)..........................................................................……414.2Mondrian數(shù)據(jù)倉(cāng)庫(kù)映射文件的實(shí)現(xiàn).....................................................……42第五章總結(jié)..........................................

10、.............................................................……44參考文獻(xiàn).............................................................................................................……46，致謝...................................