昆明理工大學(xué)數(shù)據(jù)挖掘上級(jí)報(bào)告實(shí)驗(yàn)三

1、X- -昆明理工大學(xué)信息工程與自動(dòng)化學(xué)院學(xué)生實(shí)驗(yàn)報(bào)告（20132014學(xué)年第1學(xué)期）課程名稱：數(shù)據(jù)倉庫與數(shù)據(jù)挖掘開課實(shí)驗(yàn)室：信自4452013年11月10日年級(jí)、專業(yè)、班學(xué)號(hào)姓名善良的學(xué)長(zhǎng)成績(jī)實(shí)驗(yàn)項(xiàng)目名稱數(shù)據(jù)挖掘?qū)嵺`指導(dǎo)教師周海河教該同學(xué)是否了解實(shí)驗(yàn)原理:A.了解口B.基本了解口C.不了解口師該同學(xué)的實(shí)驗(yàn)?zāi)芰Γ篈.強(qiáng)口B.中等C.差該同學(xué)的實(shí)驗(yàn)是否達(dá)到要求：A.達(dá)到口B.基本達(dá)到口C.未達(dá)到口評(píng)實(shí)驗(yàn)報(bào)告是否規(guī)范：A.規(guī)范口B.基本規(guī)范口C.不規(guī)范口實(shí)驗(yàn)過程是否詳細(xì)記錄：A.詳細(xì)口B.一般C.沒有口語教師簽名：年月日實(shí)驗(yàn)?zāi)康募皟?nèi)容用2-3種方法比較流失的情況，比較其優(yōu)劣二、實(shí)驗(yàn)內(nèi)容以SQLSer

2、ver為系統(tǒng)平臺(tái)，建立數(shù)據(jù)挖掘。三、所用儀器、材料（設(shè)備名稱、型號(hào)、規(guī)格等或使用軟件）windows操作系統(tǒng)PC機(jī)一臺(tái)；SQLSERVER2008。四、實(shí)驗(yàn)方法、步驟（或：程序代碼或操作過程）1、數(shù)據(jù)的導(dǎo)入日ijTESTANALYSIS田口數(shù)擔(dān)庫關(guān)罷囹日口表田口案統(tǒng)表田3加.事實(shí)表訂單分析二曲維表訂單產(chǎn)品數(shù)晝田二I曲維表訂單伽盲田二I加6維表發(fā)貨時(shí)間田二tdbci,維表雇員田S曲口.維表客戶:二洱耒亙=二:壬-1田3曲6維表年齡田二Mbci，維表時(shí)間JMbci,維表性SQ田JMbm維麥運(yùn)貨商rJIL.-士4+iQrh+rFlSQLQueryl.sqlloUS(lb-PClb(52)*|SELE

3、CT*FROMdbD.交山201207荃II二結(jié)果由消息B_MONTHBSERVIDBACCTIDBCUSTIDBPRODUCTNAMEBSTATEBSTATEDATEBZWSCBOFFERNAMEBOFFERPRESENTB_OFFER12D12071S0357653766359576768615105移動(dòng)語音2HA200911083416252690022012071B0358424762358303764123499移動(dòng)語音2HA20120310341623501163177016267432012071S035S5137460551768709223移動(dòng)語音2HA20111107341

4、624508627020162372342012071S035BB30764666067GB71475S移動(dòng)語音2HA201001073416243396270201G2372352012071S035B8447466O67G8714S31移動(dòng)語音2HA201001073416243996270201623723620120776fi4BAQ6.768714876萍加吾音，-2HA20100107.341624399627020162372372012D?2.文:p新建項(xiàng)肄-Analysisservices16245086270201623723S2012071S035B8G376466067

5、6010003163移動(dòng)語音2HA2010120134162439962702016237239201207180359064510304774760100663383移動(dòng)語音2HA2012062634162483900102012071S035934762138146763930475移動(dòng)語音2HA201112083416252690011201207解9密761145597_76871320S2HA201011073416245106270200122012D?1.1選擇數(shù)據(jù)源噺建數(shù)據(jù)源2HA2010110734162451062702001320120718035973576101644

6、0761016261移動(dòng)語音2HA200M91934162526900142012071S037101S76101234176BS05173移動(dòng)語音2HA200910103378S0016270201623723152012071S037104776101234176B805247移動(dòng)語音2HA20091010337880016270201623723162012071B037107576101234176SS05326移動(dòng)語音2HA20091010337880D16270201623723172012071S037110676101234176BS054S3移動(dòng)語音2HA2009101Q33

7、78S0016270201623723182012071B037118176101234176BS05562移動(dòng)語音2HA20091010337880D116233731623723192012071S037119776101234176BS06172移動(dòng)語音2HA2009101Q3378S0016270201623723202012071S037119S7610123417GB80G193移動(dòng)語音2HA20091010337S80016270201G23723212012071S0371227764285405767377717移動(dòng)語音2HA2009101133162527000222012

8、07180371381766&66821768808188移動(dòng)語音2HA201102213316252701631243023理理L-pUW141976656722176BS08558移動(dòng)語音2HA2012061933162S8351622S9502、建;項(xiàng)目1420761024468荷024098移動(dòng)語音2HA2010110733162527016312420nr3、建立數(shù)據(jù)源4、建立數(shù)據(jù)源視圖5、建立挖掘結(jié)構(gòu)- - -6、分析吃塔丨mH丨）-卷文山勿1沏翦毎走掘匕勻列BACCTIDAGEJBBILLIW&BOSEhBCHA1OIflOIiECIETIDBISCLBISGKISEDISLXIStSKtKH0MaHTHOFFEREASEOFFEROFFERFHDNlPHONEFKESEN7MODELTTFE8.I0BIKB_SERV_IDB*CCI.IDB_CST_IDBJROBVCT_SWEB_STA7EbZstaiejateBZTSCB.OrFEKFKESEtrrp|仕頑能醉谿ti赫i國冊(cè)G叔宣五、實(shí)驗(yàn)結(jié)果、分析和結(jié)論（誤差分析與數(shù)據(jù)處理、成果總結(jié)等。其中，繪制曲線圖時(shí)必須用計(jì)算紙或程序運(yùn)行結(jié)果、改進(jìn)、收獲）這次上機(jī)我們主要是運(yùn)用兩種比較成熟的算法進(jìn)行對(duì)來時(shí)所給的數(shù)據(jù)進(jìn)行數(shù)據(jù)挖掘，數(shù)據(jù)挖掘是目前人工智能和數(shù)據(jù)庫領(lǐng)域研究的熱點(diǎn)問題，所謂數(shù)據(jù)挖掘是指從數(shù)據(jù)庫的