肆谴肆勹
 
斯橐崦  | ㈣仪茄构臻  | 幻朽寸勾学  | ∶昧∫谩乓  | 霖逝粤浞  | 嗲绾和渺  | 馀⊥宜醚  | 霖逝粤馀  | 假樗  | 守⒗揖  | 我乓  | 
峥韫霖逝粤  | 柰鸵嗣押  | 嗲乓判肆掖  | づ院窃凑馔
ら顾
艘×栅婴楣伺衣笛 室烈枚ぱ韫撮锹 comma (,)
斯橐伺选 >> 视猛Б橥临 >> ㈣仪氛韫枰使悒
驹辆焖归夜臻  |  疏с碎嗑阻凸
づ学㈤土倥 (Data Warehouse)
づ学㈤土倥 (Data Warehouse)

..萌.疵.嗳蒙熬Г  列旁守敲贸
settapong_m@hotmail.com
幻楔印昧㈣仪匪颐 ⊥Ш循∫谩艇费句仿
∶昧∫谩铀勾崤楔汛拭盲抛韫で伊墩桡肆 酪裸甸こ小妹痢颐≡ā颐夥盲凉窑玲髓И业 (》.)


 


           ∫勉㈤土倥嗷绻啶米柰Я淄视ぱ埂颐笛词怨悒⑼Г臁 淞枨枰ㄐ嗷绻嗑阻汀颐脓坟狗咬肛谩渊 ∫们咬峒恭夜愎艇れ∶酪っ寻崤星咬峒埂怕胤胳愎坟⊥Г臁绵咀柰闼槭伊颐兜秃 獾椤押∫绵慌砧鹿峄脓吐枰谴嗝缜⑼澡п谴砰土崤肖勹幄瑙⒀ ┬寡楣$鸵ā盆仪浯榍枰∫昧闸橥临帕摇酚闼榱这汀沂崤辛摘崖嗨棺亭勹幄瑙愎 眯囱核怪瑙 岬璺氰宜摇镣с狗咬∨押⊙ ∫昧闸橥临浓庸枪烈♂佃⒁础颐ㄑ础颐氛栲荤姑泻 $ㄐ酚闼榱栅且谅罔摇愎∫绵㈤叶支嗑阻凸恿毅幻锈陋轨 崤新学甸艇嗍章よ毅ㄨ衣ㄓ骨沽艘纫陪埂颐唷绾醚∩尧橥临培伺枰寡楣淝殁绰 淞瑷余荤 雇〃摇拐樗摇琳∫霉英橥临帕仪脏っ倚遂吐枰Ъ源九掖鸵è小柰闼猷≡醇培收滤衣 浯 瑙鸵è朽≡础颐寿收路砧淞柰舀幻朽猎工枰浯 嗒韫 で伊荚淳乓淬埂颐笛词怨悒嗑阻亭且亮谚工Б艇翟 ∫绵收骡汀沂芬Ц孛≡ㄤ 嗷绻甸 嗑靡些泄验广孤丐氛杓匍好运颐琳で伊甸艇∫勉㈤土倥嗑阻汀颐笛词怨悒寡楣 ∫猫汛眯汉㈤土倥室檬灌啡嗑阻凸余使廷橥临欧砧琳へ长枰崤屑枰埂颐∨谚埂猛 崤榍帷杓匍好运颐嗑阻豌愎∫玫汛试广ㄣ碎费沟柰嗨地∫贸焱妈咬猎 幻惺苑冈酪 ㄖо荤故澡Х砧ㄓ嗷绻吐枰澡 囱Ч验埂颐拭橐Г叛Б橥临 (Data Warehouse) ㄖо≡储珠灌咀柰嗷绻氛栲$好呛们立橥临攀婴循崤楔余荤龚摇崴盆У枰 瑙嗷绻幻锈陋轨佃汀颐笛词怨悒⑼Ъ匍貉Г押貉 崤屑匍好运颐 

           愎疏枪⑼А艇费 獯滤叛 颐崤榍 づ学㈤土倥 (Data Warehouse) 嗷绻疏枪斯骤Б艇眯汉室檬灌啡 (Management Information Systems; MIS) ⑼А艇费 瑙蹲颓枰嗷绻⒇练醚韭旆砧室烈枚褂烈悛榛眯饴熹撮烈×衣了胰遗 嗒韫 褂烈锹们好橇 ぱ瘁隆 窃啶靡兴 ㈤土倥/室檬灌啡 ㄒ“夜㈤土倥愎斯枨搂夜佃咬 嗑阻褪瑙闼槊泻骸颐ㄑ础颐で伊觅 (Knowledge Management systems) 愎∫檬瞄咬艇れで伊觅殂碎⊙和Г臁 嗣淄锹使押使毓㈤土倥闼椤押眯汉∫玫汛试广 (Decision Support System; DSS) 闼椤押∫玫汛试广á艇假楹学ぱ汉循 嗷绻甸 氛栲绥逛撮吐枰о荤姑倩该昧ぷ ∫霉恿毅嗑阻汀颐且А怕胤胳愎∫玫秃獾槔崖へ·伊 驼》验学室烈枚韭摇贸烀倩岷豪崖へ·伊氛瑷朽≡储珠广雇挂さ 吐枰т谩绲伊 ∫梅砧 Data Warehouse ㄐ酚б逛撮狄练砧∨枰卿情浯榇账米弯凌寡楣 $甸艇唷源ㄒ 颐们好橇㈤土倥氛瑜煤猛捍橐 坟×缘 崤肖敲唷绾㈤土倥愎痛盏氛杪仪挂灌菊搂就 ㄖЖ蟹鱼碎∫镁乱∶踌崃韫掠 寡韫$ぷ ⊥Х丫甸艇琳∫猫汛斯枨搂夜嗯纭 酚б灌┚倚∫妹呛们 ぱ瘁隆㈤土倥 崤惺瞄咬㈤土倥 嗑阻凸恿毅疏愎眯汉 崤朽荤辜匍幻惺夜б龚摇坟 斯枨 嗑阻屯庸锹で伊市辞°碎⊙核硅锹佃咬 褂嗤尧橥临攀颐使喾攘毅疏愎眯汉 岬瓒橐淞枇铡颐ㄑ础颐囱А盆仪 $嗍磷凸⊙骸颐拭橐橥霖 岬桎凌琳斯学首歪判好贸颐选伸


“ ě得兴寡∴柿颓枰 吐枰拭橐橥霖 费椐 氛 淞枇账寡淄崤泻妹骋醚∩ ”
..嗳蒙熬Г 列旁守敲贸


峁扦源唷砧虑⊙氦叛Б橥临
           Data Warehouse 肆衣吨 耙耿橥临泞挂淬谁琚艇艇れ∶嗣淄斯枨搂夜斯骤ф 瑙唷绾们好橇㈤土倥ㄒ“夜㈤土倥眯汉б够眯ㄓ茄 嗣淄嗝章⊥铡吐枰枰 Operational database 崤邪夜㈤土倥妥韫酪鹿汀艇れ∶ 嗣淄嗝章∏枰 External database 獯垄橥临欧砧顿〃汛唷绾愎づ学㈤土倥寡楣 琳茄刀鼗眯失れ愎∫霉恿毅б 崤辛张选沙孝艇∫猫汛唷绾岬〉枰т花摇㈤土倥愎耙耿橥临琶泻骇夜妥韫    ∫寐橐垄橥临浓摇耙耿橥临呕〉   啖橐浠淝殂 Data Warehouse  琳㈤痛账乓峦妈咬 嗒韫 酚闼橥Г臁盟米袜ㄩ尧艇㈤土倥  琳馔∫输撮屯♂汉觅会汉∫绵$孩橥临陪肆桡碎嗨烈惺痢押∫绵谜隆悛榱摇略瑙⒅楣愎б灌┚倚撮夜  崤蟹鱼碎嗨烈惺铀醚骸颐褂浠悛楠枨裸埂颐笛词怨悒 嗣淄悛殂恭夜窃啶靡兴 雇〃摇寡楣眯汉 Data Warehouse  卵橇嗤尧橥临欧砧悛橥沦桡够穴ㄘ貉灌㈤摇押㈤土倥愎痛盏嗷绻耙耿橥临培凑虑⊙ 室烈枚嗝章°б逛撮ㄒ⊥怨嗟兔爨渴岷 ∶铱浴浯殁绰得 (GUI) 久橥潦铀醚骸颐ㄑ础颐㈤土倥崤泄英橥临欧砧浯殇磺脏っ倚遂 ㈤痛胀铡㈤汀绀淄 眯汉 Data Warehouse 酚闼榧匍悛榉砧嗷绻假楹学ぱ汉循眯囱菏侑 嗣淄啜橐斯橐氛璺谚卿皇伊颐多㈤叶支崤朽谜隆悛榘夜㈤土倥浯榇榍碌亚嗤 獯落凌甸艇鸵妊陇且联枨锣伺淄ㄒ∴ㄩ宜归曳砧芬о筏乖⊥铡佃弯



觅会蚀写押⑼Б橥临


           ㄒ∶倩崾揣眯囱孩艇㈤土倥 獯屡哟押ㄒ“夜浠寿杪痛室拎伺砧铝 ㄐ嗨绻浯榍枰 眯囱孩橥临琶写押耙构验灌荤耿橥临徘压佃颓压 (Transaction) 氛桎撮ㄒ 颐唷绾们好橇ㄒ》亍疏枪⑼Г臁梅砧嗷绻斯枨搂夜眯囱夯貉翟∫ (Operation) 嗑阻头印颐ㄑ疵泻亨荤顾燎此临 闼槭伊颐多谜隆悛殇撮ц衣 瑙獯路谚卿秽靡嗝章∏枰 ∫猫汛唷绾淝猷荤姑倩岷 “耙耿橥临 (Database)” 伺学ㄒ〖枰埂眯呵埂颐崧♂滦 窃啶靡兴 拭鼗 崤榍ㄐ褂浠唷绾淝殂姑泻孩橥临欧砧寿Б珠 寡韫ぷ Data Warehouse  獯垄橥临陪 Data Warehouse 拐槎淄氰亦荤耿橥临欧砧琳眯饴煦灌А怕胤胳 愎芬Ц孛≡ǘ淄氰亦荤姑泻壕组拱夜氛瑜吐使押使毓眯汉 “肛谩渊脱ī迷滦 (Business Intelligent System)” 瑙嗷绻㈤土倥氛枋伊颐丢枨裸碎假楹迷艘妹写押∨咬崤忻写押寿伊颐豆恿毅嗑阻汀颐且А怕胤胳 室烈枚锹愎∫镁乱∶踌识夜∫贸煦雇挂さ嗑阻汀颐且п脊∫勉访丫乱∶浯橥妈咬琳幻惺苑冈酪 瑙愎撮夜で伊裂韫ぇ$褂烈悛猷咀柰∫们咬∨仑犯煦埂颐低衡甸姥陇亍ひ 驼》验学室烈枚韭摇贸烀倩岷豪崖へ·伊氛瑷朽≡储珠广雇挂さ 吐枰т谩绲伊 ∫梅砧 Data Warehouse ㄐ酚б逛撮狄练砧∨枰卿情浯榇账米弯凌寡楣 $甸艇唷源ㄒ 颐们好橇㈤土倥氛瑜煤猛捍橐 坟×缘 崤肖敲唷绾㈤土倥愎痛盏氛杪仪挂灌菊搂就 ㄖЖ蟹鱼碎∫镁乱∶踌崃韫掠 

           堕尧橥临陪 Data Warehouse 顿【巡挂愎嗒鸳窃啶靡兴灬判恃оっ倚遂烈、珠 $室烈枚褂浠悛殂姑写押∫们咬仑犯纫实渺愎眯囱杭匍好运颐眯囱菏侑 (Executives) 浯殂狗砧守

酚淞甸艇悛槊泻 Data Warehouse
           艇れ∶佃咬 愎谎è睾压疏枪闼ㄐ琳∫门Х毓脓崦т涣摇⊙好泻悍砧嗝章∏枰 “眯汉耙耿橥临呕眯ㄓ茄 (Operational System)”  眯汉㈤土倥氛枨枰拐楱辛账归曳砧伺选愎∫妹呛们玲判ㄑ脆$孩橥临培鸵淝 淞枨枰ㄐ嗷绻㈤土倥⑼Ш丐づ摇 ㈤土倥刨·橐 ㈤土倥∫芒衣 ㈤土倥借衣贺い ㈤土倥唷砧虑⊙氦Г叛А绲伊 獯路砧眯汉嗨盆夜臻琳∫门Х毓浠烈 囱Ч验够迷烈尝橥临欧砧了胰遗$嗯露淄浯榍枰嗷绻访丫蚂试贯判访丫乱∶吐枰怪瑙⑼Г臁  ㄖЖ余荤沟橥Я铡颐ㄑ础颐氛栲肆倚柿嗑阻凸余鸵访丫蚂试灌伺枰拐榱毅闼猷≡椿眯饴焓侑守 愎艇れ∶伺衣崴瑙 浯楣英橥临培伺枰拐榱要枨裸埂颐笛词怨悒獯禄眯仑〉煦嗷绻眯汉∫玫汛试广 “Decision Support System (DSS)”  獯鹿余鸵眯汉 Data Warehouse  烈锹嗑阻豌碎假楹迷艘檬伊颐多谜隆悛棰橥临欧砧甸艇∫娩撮吐枰谴嗝缜崤辛栈眯试犯岳揖烈、珠 獯垄橥临培Ш迷艘霉臻ㄐ室烈枚锹糯谎曳砧唷源ㄒ 颐悛棰橥临浓摇耙耿橥临呕貉翟∫ (operational database) 瑙嗷绻∫绵$孩橥临陪姑泻恒姑倩岷呵压佃颓压 (Transaction system) ㄖт凌吐勹愎觅会汉氛栲荤够眯饴斓柰假楹迷艘 瑙獯路谚卿换循艘氛杈亨磷柰甸艇∫绵谜隆㈤土倥嗑阻酮枨裸埂颐笛词怨悒浯獒¤

           - ∫绵谜隆㈤土倥ㄒ“夜㈤土倥化院训浴颐 瑙琳⒐掖闼 酚闼榛眯试犯岳揖⑼泻号磁п判酚б逛撮遗
           - ㈤土倥氛韫余使土彰倩岷亨凑虑 淞枋伊颐多慌砧鹿峄脓浯榈伊で伊甸艇∫芒艇假楹迷艘
           - 淞枋伊颐端窑拥秃愎嗒鸳韭摇贸熹撮
           - 淞璧秃使艇∫冕蚀Ъ欧砧韩橥逛撮凑喾枰氛瑜敲
           - ㈤土倥顿〃汛唷绾吐勹狄涟夜㈤土倥⑼泻骇夜佃咬 瑙乱♂¤∫绵谜隆悛獒判⒁搐且潦蚜狙垢煦灌Ю颐≡

で伊岬〉枰兴氰咬眯汉氛杓枰埂颐窃啶靡兴灬判眯汉化院训鸳夜费枨浠
                眯汉  Data Warehouse  寡楣嗝章′撮氰亦荤姑泻喊夜㈤土倥 (Database) 氛杓枰埂颐窃啶靡兴灬砰 寂叛靖旆砧浯楱卸佟褂烈锹愎∫玫汛试广ㄤ撮 愎⒊蟹砧眯汉化院训鸳夜费枨浠  ㄐ嗷绻嗑章泻喊夜㈤土倥氛柰汀岷毫亦咀柰锹陀骨陇且潦写恰愎б够眯ㄓ茄灌疯夜验贯怠佃咬獯率蚤灌А押眯汉 Data Warehouse  瑙ㄐ褂㈤土倥烈艰夜∫们脏っ倚遂¤凸 瑙屯♂汉烈闼棰橥临培伺枰寡楣锹假殂愎∫玫汛试广ㄤ撮费狗  淞枨枰ㄐ獯隆颐褂㈤土倥烈窃啶靡兴 拭鼗崤朽使袜荤姑衣б

           搜倾á艇眯汉耙耿橥临呕貉翟б狗谚卿还验 ㄐ使悒嗑章А颐醚孩橥临培㈤沂勹耙耿橥临  ね麓籴陪碎㈤土倥琳で伊费沟柰嗨地∫贸爨柿 獯麓籴陪碎室烈枚嗝章°浯榇榍陇且撩谴嗝缜 顿〉橥  崤辛栈眯试犯岳揖  疏枪㈤土倥氛杓枰埂颐窃啶靡兴灬砰  ㄐ嗷绻㈤土倥氛枋广ㄣ躬枨о桥毅脆桥宜怪瑙嗷绻ㄘ 喾枰寡楣  ∫们脏っ倚遂㈤土倥寡楣 疏枪闼ㄐ吐勹愎觅会汉⑼А颐嗷谜潞喾章  嗣淄淞琛玎荤埂颐韭衣伊艘觅会汉⑼ (Pattern) ⑼Б橥临 嗑阻途乱乱了裔骨夤榱氛瑷朽≡吹柰浠愎凸窑 嗒韫  窃啶靡兴烀倩岷亨说亍颐踌で伊淞枋Ш愎 3 ㄑ茄椽衣岽估窑愕 獯隆颐嗷谜潞喾章亨说亍颐踌氛栲≡储珠广骨压斯骤 ⑼Х亍婊涨枰琳觅会汉喋疽兴米弯凌 瑙堕亦荤埂颐褂㈤土倥愎痛盏烈促麻凸伺学 $鸵è蟹鱼碎嗨绻灸翟∶昧⑼Ъ匍¤亭且龄凌失 嗷耪杪贯慌т煌妈咬涿

           で伊岬〉枰铡吐枰怪瑙氛枇艇嗨绻浯楠汛⑼艇眯汉$ぷ 眯汉耙耿橥临呕貉翟б构验 ㄐ嗷绻㈤土倥氛桎撮ㄒ 渊∶昧鸳愎岬枧星压  囱Ч验耿橥临诺亚斯骤 ㄖо慌砧鹿峄脓浠嗝阻吐 崤卸淄浯榍枰嗷绻㈤土倥氛桎凌兑敲 疏枪㈤土倥ㄒ∶泻呵脏っ倚遂寡楣 ㄐ蹲弯撮氰亦荤耿橥临欧砧よ凸㈤咬乖瑙  嗑靡朽荤埂颐窃啶靡兴旆砧ㄘ淬川卮斯骤Б艇嗲乓 嗒韫 貉狗帧⑼Б橥临诺凸喾砧搂ぷ耿艇嗔阻颓夜拐 嗷绻甸  ㈤土倥氛柰沦桡拱夜㈤土倥岷 窃啶靡兴旃验龚型沦瑜Х砧兑敲 崤楔朽荤埂颐嗑澡立橥临陪肆栲㈤伊亦米柰   狄撩新朽桥曳砧∮斯 

笛峭妈咬⑼泻 Data Warehouse 氛杌眯屎で伊视嗝绋
佃弯还臻ㄐ嗷绻笛峭妈咬ㄓ骨顾怪瑙⑼А颐褂眯汉 Data Warehouse 浠幻新亍奠悛榉砧嗝章′撮氰一眯屎で伊视嗝绋 

           • 眯汉ㄑ础颐源试工橐 (Categories Management)锹闼楦孛≡à橐慌铡啖橐悒灸翟∶昧∫勉ㄨ衣⑼佟ら伊摇 ⒅楣崤蟹靡呵枰刨·橐琳化浴悦月摇押饣免联谚耿艇倒吐枰т 
           • 眯汉窃啶靡兴臁颐 “Claim” 嗣淄∫猛橐苑冈⑼Ц孛≡ɑ眯⊙故丌酪  锹闼楹迷裳筏呛へ沥枰悛楱枰垄艇刨·橐浯榇闸珠 
           • 眯汉で氦亓∫梅亘迷滇判で氦亓よ毅ㄨ衣⑼Ц孛≡ɑ眯⊙故丌酪 
           • 眯汉 Supplier Management 嗣淄眯汉ㄑ础颐 Supplier  锹闼橥Г臁绵伺枰寡楣室烈枚幻朽猎工掖∫贸 崤星咬峒故铀醚和挂さ浯榇铡氰 
           • 眯汉∫绵г 瑙琳艇れ∶费椐伺衣褂浠悛橥妈咬∏橐Б且 酚闼橥Г臁绵伺枰拐槭伊颐痘眯嗔怨ひ础颐踌 崤星咬峒故铀醚和挂さ浯榇铡氰 
           • 眯汉ㄑ础颐よ毅好浴颐 瑙好陨逊夥盲凉窑凉愉汇  酚闼楹迷裳粪伺枰寡楣室烈枚∮斯赐训靡よ液迷∫ 氛璺印愉娩撮寿卮 愎⒊朽凑虑⊙埂玎荤雇训靡氛瑷侑悒刨·橐烈》砧守创榍 淞枨枰ㄐ嗷绻よ液迷∫免访妊痉爨づ阻凸氛桠访妊痉 芬т∨嗣淄夥萌丫缝洪夜$狄 
           • 眯汉幻星训耘佟ら 眯汉酚挂陇且恋橥А颐崤忻泻骸颐蹬掖⒐掖ㄘ爬窑氛枇浙愎好陨逊好浴颐首柰室 
           • 眯汉ㄑ脆$氦枰好浴颐 眯汉ㄑ础颐啶么缘  崤忻泻骸颐蹬掖⒐掖ㄘ爬窑氛枇浙愎识液压∫绵г 

           斯骤с姑泻 Data Warehouse 氛杌眯屎で伊视嗝绋烈》砧守脆绥龚朽荤埂颐褂烈幻新亍奠悛椤押肛谩渊ら一耪 嗑靡忻泻 Data Warehouse  酚闼猷ㄩ尧艇室烈枚拭橐泻好衣б狗砧粗о┚倚㈤土倥氛璧橥А颐屯×舀摇啶米柰о$亨г逛撮 (Point-of-Sales) 崤泄英橥临殴验沽沂瞄咬崤蟹词秃饣免联谚沟枰 锹愎∫么倬牡浴妹痢颐橥 (嗒韫 ⑼Ш咬吐枰佟ら伊选ㄐ橥べ琛压 吐枰о 嗍组袜榈⊙亨工浞嗣淄猛о烽摇押∶朽浑叶淄 嗷绻甸) 嗣淄拭橐Ш迷∫冕判 寂缘姥潮煦肆   堕窑爻∮叛с眯汉 Data Warehouse 吐勹盆小 ひ础颐踌淝殇撮嗯虑枰 淞瑾橐$嗝缜啖舀械橥Ч用泻 囱А盆仪嗑阻酮枨裸埂颐且п脊∫玫乓脆咀柰闼榈莽⊙氦且恋橥А颐⑼佟ら曳砧寿瘁判拭橐Г且龄撮嗷谜潞寿卮

悚玫橥А颐㈤土倥锹嗨抛
 
           • 假榉砧甸艇∫芒橥临弄枨隆颐笛词怨悒   瑙嗷绻㈤土倥氛桎撮ㄒ∶泻  Data Warehouse 寡楣 $ぷ豌っ $狄零 艇れ∶氛璧橥А颐㈤土倥嗑澡拎翟拎咀柰闼楹迷∫门佟ら曳砧凑∏枰 瑙嗷绻浠浯榇学佃弯还臻 
           • 假殂磷豌肆 嗣淄假殂该昧匆 (假楂骤У橥А颐悛棰橥临培荤工醚椐っ仪 崤械橥А颐㈤土倥氛枨脏っ倚遂淝椤柰贯砰 嗒韫 贺い乓∶氛柰沦桡咕组狗砧化院训浴颐 (Remote users) 
           • 寡∏脏っ倚遂 (假楂骤У橥с㈤土倥坟∏压  嗑阻突醚恒碎费埂押嗨地∫贸灬佃判茄 岬栲⒁嗨盆夜验逛凌琳で伊觅 就氛瑷惺瞄咬饣冕∶撩衣б耿珠勾榍碌灌艇) 
           • 假殂眯囱亨杪仟噎 (假榉砧啖章光幻帷昧⒅楣撮锹倒嗤о咀柰拭橐倩岷骸颐嗝章°㈤土倥 (Query) ⒅楣岷亨┚倚斯橐獯峦胰崖㈤土倥氛桎撮ㄒ∶泻 (Data warehouse) 
           • 眯汉 Data Warehouse 嗷绻眯汉氛璺缨夜释Ё夜愎嗲乓啻章恰压 ぷ艇夜崦∴荤姑泻悍砧闼榧匍悛槭伊颐 视们ㄡ判嗝章°㈤土倥氛枇胀沦桎撮吐枰т凌ㄓ⊙  室烈枚拭橐倩岷骸颐嗝章〈佗橥临泞珠逛撮狄零ㄡ判啜倚胖∨т汇耿橥临配撮得液 喾枰氛璧橥А颐  崤秀耿承啻章恰压$卵о荤姑泻悍砧们好橇㈤土倥啖橐眯汉  ㈤土倥氛枨枰$ㄐ嗷绻㈤土倥氛璧莽⊙核亚㈤头砧使悒吐勹 (Subject-Oriented) 嗷绻㈤土倥氛杳橇⊙灌荤躬卮 猎悛琚橥临培凑杪 嗷绻㈤土倥唷绾市柿狄痢颐嗷耪杪贯慌т 狄拎桥 崤小玎荤耿橥临欧砧ぇ笛谴榍  囱Ч验埂颐拭橐泻 Data Warehouse ㄖЖ余荤沟橥Щ眯⊥捍榍率砧⒀楣低 囱У柰浠拐 

           1. ∫谩叛韫∶艇㈤土倥拭橐о荤光拎磁崤忻呛们哩摇眯汉化院训鸳夜 
           2. 峄脓㈤土倥丛酣摇眯汉化院训浴颐 浠嗷绻㈤土倥氛杓匍悛槭广 
           3. 嗉箩久栳判ㄑ础颐⊙氦且拎慌砧鹿峄脓氛栲≡础押㈤土倥 
           4. 闼楹迷∫绵㈤毅㈤土倥

识一训隆妹立艇稤ata Warehouse
           识一训隆妹 琳で伊肆衣ぷ ∨罔立艇‘ 嗣淄 猡莽拭橐Ж庸枪斯骤 氛栲荤埂猛菏铀醚骸颐屯♂汉眯汉猡莽拭橐Ь组拱夜氛瑷余荤故铀醚骸颐拭橐泻 Data Warehouse ⒅楣烈恃∶泻核怪瑙$甸艇幻小秃撮锹 峋诺客渺 (烈得耙灌筏夤馀抡化院训浴颐氛桡) ⑼泻悍砧ㄐ酚∫绵柰恋柰耙耿橥临陪姑泻 LAN 嗷绻甸 愎撮夜⑼颐齑崆渺 眯汉 Data Warehouse 室烈枚 ㄐ吐勹汗伺衣  峋诺棵兔炝浯 嗒韫 鸵è朽荤灌凉嗫昧 眯汉氛桡伺衣饣绵喃兔旆缨夜久橥 ⊙ 嗣淄鸵è 嗷绻 Client/Server $浯 仑に叛 拐榫巡挂∫芒艇峋诺客渺痢缌蔗骨夤榱ㄐ啶抛柰孤橐篓摇眯汉嗔灌棵烈嗷绻∫梅缨夜岷核乓骡幻喃枢渺⒐夜⊙ (Parallel processing) 烈、珠 嗑靡歇枨裸碎眯汉酚б逛撮嗝缜⒅楣伺衣喾枰笛 獯路谚卿会砰嵌橐眯汉⑼Г爻琳⒐掖淞桡谁枇摇寡  眯汉 Client/Server $ㄐ嗷绻芬о抛汀氛杌眯寺汛崤朽肆倚柿氛枋卮 

           视嗣押猡莽拭橐Б艇识液训隆妹立艇㈤土倥寡楣$嗷绻驼∈枨狗砧琳で伊视ぱ 嗑靡楔朽荤咕粤眷啖章呛汀嗝仪枰 ㈤土倥⑼о靡ㄐ琳吩确咬∫娩伺嗣淄啶抛韫氛桎煌妈咬涿酪裸姑泻酣惺伊颐豆恿毅幻锈陋轨浯猷菊搂愦 视嗣押眯汉 Data Warehouse 寡楣 识一训隆妹立艇㈤土倥伺选$ㄐ嗷绻㈤土倥氛柰枰逛撮吐枰о凑虑  獯锣鸵烈悛殂姑泻邯枨 ∫玫汛试广  獯裸姑倩岷汗臻  ㈤土倥$ㄐ顿·汛嗯淄×舀摇耙耿橥临呕〉运米屯舀ㄐ淇澎佃咬 崤榍$ㄐ褂烈幻押峄脓闼橥沦桡姑倩岷悍砧嗨烈惺痢柰龚楔汛唷绾啖橐寿  Warehouse 佃弯

疏枪幻小秃⑼ Data Warehouse
眯汉 Data Warehouse 淞桡眯汉视嗝绋觅环砧橥烈帷小盆艇$悛椐夜浯榉压氛 ㄓ嗷绻甸艇琳∫猛汀岷 ⒅楣嗑阻头印颐艘で伊甸艇∫梅砧岱楱迷Б艇艇れ∶ 獯铝账叛·源 囱Ч臻
           • 驹ㄒ贸亦っ阻艇磷头砧嗨烈惺拎咀柰锹屯♂汉耙耿橥临泞艇 Data Warehouse  崤锈幻帷昧氛瑷蟹铀归曳砧唷绾们好橇㈤土倥ㄒ∶泻夯貉翟б顾米歪伺瑙㈤土倥妥韫  
           • 疏枪氛璺铀归曳砧嗷绻 Directory ⑼Б橥临  嗑阻屯庸锹で伊市辞♂¤假榇籴琶泻核米图匍悛榉谚卿 闼猷㈤毅ǘ支㈤土倥岬枧械亚崤肖且了烈垄艇裂 
           • 笛前夜㈤土倥⑼ Data Warehouse 嗤 
           • 疏枪氛璺铀归曳砧 Data Acquisition 瑙$ぷ偷亚氛璺 斯橐氛璐押ㄑ 唷绾们好橇㈤土倥 醚∩窑且炼佟甸艇 馔孤橐 嗣淄峄脓㈤土倥ㄒ♂伺瑙㈤土倥妥韫闼橥沦 愎觅会汉氛栲肆倚柿¤凸ㄐ唷绾啖橐寿 Data Warehouse 佃弯 
           • 疏枪氛璺铀归曳砧 Data Management 视嗣押ㄑ础颐 崤肖呛へ痢颐化院训鸳夜⑼ Data Warehouse 
           • 疏枪氛璺铀归曳砧啖橐吨Б橥临 ㄐ嗷绻疏枪氛桡碎好浴颐帷杓匍悛榉砧琳咀楣烈芬Ц孛≡  闼槭伊颐躲裂灌荤灌っ阻艇磷酮枨隆颐笛词怨悒浯   瑙峁韫凸氰业橥А颐啶米柰Я淄笛枪臻嗑阻酮枨锣⒁啖橐吨п判窃啶靡兴膦橥临 
           • 疏枪氛璺铀归曳砧馔孤橐垄橥临培荤故枨狗砧酚斯橐氛 export ㈤土倥酪裸  Data Warehouse  屯∈勹酪鹿汀鸵è朽咀柰ㄐ馔孤橐落皇勹眯汉 Data Warehouse  眯汉妥韫 Data Mart 嗣淄眯汉妥韫 费枨浠



∫绵づ阻凸氛琚艇㈤土倥愎づ学㈤土倥               
㈤土倥氛 ㄐㄑ脆$豪衣愎づ Б橥临帕铡颐啶抛 柰狗砧⑼Б橥临 (information flow) 5 幻朽婪囱Ч臻
           •  Inflow ぷ汀颐褂㈤土倥ㄒ“夜㈤土倥妥韫啖橐寿瑜叛Б橥临欧验耙耿橥临爬衣愎崤欣衣雇⊥Г臁 獯裸耿验构臻鸵铡颐嗷耪杪贯慌рっ瞄咬㈤土倥 ∫梅 de-normalize∫门核米袜驹枇吭糯 嗑阻豌碎㈤土 欧验链吐勹愎喙组退曳砧使悒啻章恰压 愎⒀楣低构臻鸵ㄣ啶米柰Я淄氛栲谜隆氰 data warehouse tool
           • Upflow 嗔阻廷橥临欧砧嗝业橥А颐吐勹愎づ学㈤土倥崤榍愎阂Г醚椐鸵ǖ橥Я铡颐嗑澡 へ长枰闼椤押㈤土倥撮锹嗑阻豌碎㈤土倥吐勹愎觅会汉氛栲荤够眯饴炝摇氛枋卮 佃汀颐褂啶米柰Я淄烈悛 瑙浯獒¤∫猫汛∨罔立橥临潘窑 曳咬识缘苑砧韩橥 ㄑ储橥临陪碎 吐勹愎觅会汉嗣淄喾拎九盗业冒夜
           • Downflow 嗷绻⒀楣低耿艇∫没醚夯秘о慌砧鹿峄脓㈤土倥氛栲¤ 崤袖凌吐勹愎喙组退曳砧艇れ∶使悒屯′花摇づ学㈤土倥⑼Г臁
           • Outflow 嗷绻⒀楣氛杓匍悛猷谜隆悛棰橥临陪工叛Б橥临偶枰灌っ阻艇磷偷枰ф 獯隆颐嗝章°鸵锗菊搂⑼嗝章∴荤工醚椐っ仪嗷绻幻楔臃亍茄/啻淄 嗣淄崃椤眯费瑙甸艇∫冕汉费狗
           • Metafolw ㈤土倥氛瑷汛唷绾愎づ学㈤土倥ㄐ顿》英橥临配情驼—卮斯骤 嗷绻崴盆Х砧烈⑼Б橥临殴验 嗣淄崃椤眯费瑙氛柰沦琚艇㈤土倥寡楣愎づ学㈤土倥崤孝橥临磐阻狗砧唷砧虑㈤艇

∫猫汛崤小颐好运颐 Data Warehouse
           ∫猫汛∫ Data Warehouse $ㄐ嗝澡链榍隆颐狙补颐泻孩珠沽亦收隆柰 啶米柰Я淄视嗣押锹狙补 Data Warehouse $ㄐ嗷绻笛欠砧锹拭橐п判醚∩彝怨嗟兔爨渴眯饲枰泻悍砧悛椐夜弧翟⊙好泻 Data Warehouse 康灬敲焓铀醚壕巡挂眯汉 Data Warehouse $ㄐ醚骇夜脱公押凸愎∫檬瞄咬 驮灌低渺嗫 獯隆颐拭橐р幻帷昧嗑阻 拭橐 ㄑ础颐 崤写籴琶选梢驮灌低渺嗫殊绰脱碘沽训 驮灌低渺嗫史砧氰夜臻 嗔阻艇夜∫妹呛们玲判峄脓㈤土倥酚嗍苗ㄡ砰 $で猫辛账归曳砧吐枰Ч橥麓学佃弯还臻 峄脓㈤土倥 , Mapping ㈤土倥, 幻押觅会汉㈤土倥, び骨长枰闼凌, 幻押猡莽拭橐 Key ⑼Б橥临, 拭鼗㈤土倥

∫勉б 窃啶靡兴灬判⑼靡搂夜
           谎è睾压啶米柰о¤ $琳嗑澡立珠灌米柰 瑙们龄欢支饣冕∶辆恰 Spreadsheet 吐枰 Lutus 1-2-3 崤 Microsoft Access, 眯汉耙耿橥临藕灌っ阻艇啻省旆突 崤锈幻帷昧氛璺铀归曳砧嗷绻 Front End 视嗣押啖橐吨Б橥临培 Business Objects, Impromptu, 1Q/Objects 崤 Forest & Tree 嗷绻甸 啶米柰Я淄厩」臻酚闼猷靡室烈枚啖橐悛椐夜㈤土倥愎 Ware House 浯殁绰淞璧橥匍猡莽拭橐Ю衣愎⑼Я压嗯 嗣淄淞杳匍 窃刚∫绵谜隆悛 SQL 嗯隆玟撮 厩×压卵伊颐多ㄒ信帧啖橐浠愎㈤土倥 嗣淄$突徽橥汀烈唷绾淝殂 Spread Sheet 嗑阻 ㄐ嗤伊仪脏っ倚遂佃弯 啶米柰 Workstation 费枨浠室烈枚啖橐悛椐夜嗣淄窃啶靡兴熹撮吐枰允眯费椐㈤土倥氛栲荤姑衣 判嗤章此米廷橥临攀秘皇伊颐多㈤毅浯榉砧眯囱汗臻嗯锣っ阻艇磷

试瑙氛瑜敲驹ㄒ贸摇柰故瞄咬づ学㈤土倥
           喙阻艇ㄒ 颐脓坟故瞄咬づ学㈤土倥⒅楣烈悛猷咀柰使押使毓∫梅缨夜⑼Г臁霉验龚余荤沟橥Я栅枰悛 ㄨ衣愎∫门Х毓了胰遗 费椐拐槭伊颐肚汛屯×亦荤沟亚唰怨浯 嗒韫 よ毅ㄨ衣撮夜我渺瘁敲 康灬敲 崤锈っ瞄咬咀楣耙雇阻 氛瑷余荤沟橥с 疏枪よ毅ㄨ衣氛桎凌嗷绻笛青г 岬枇栅且潦婴循吐枰Я摇浯獒¤ ∮叛п莽б狗砧ㄐ嗍章浠⑼Х醚韭摇煤丐づ⑼Г臁冕判嗲乓氛桡浠⊙骸颐狙补 囱Ч验 嗔阻屯Г臁玫汛试广ㄊ瞄咬づ学㈤土倥⒅楣崤榍 で猫谢眯屎で伊视嗝绋撮锹 费椐拐 Poe 浯猷使 “8 幻小颐氛瑜敲闼椁且潦广” 獯铝彰衣判嗤章创学拐

           • で昧栅且联汛啜广灌婚宜烈旅枨立艇∫檬瞄咬眯汉拐棰艇す愎艇れ∶ 嗨磷凸∫玫秃び兑燎枰酚淞 へ扯支ぴ川惺瞄咬づ学㈤土倥 瑙び低孩艇艇れ∶氛瑷袖撮 ぷ袜婚宜烈路砧甸艇∫ 獯陇敲ㄐ啖章灌婚宜烈鹿臻屯×亦荤古衣叛∩踌脱∩梅砧脆ü 嗑阻豌碎氛辆巡挂浯猷㈤毅ㄠ婚宜烈旅枨痢压
           • 酚で伊啖橐悒识一训隆妹立艇眯汉 嗑阻豌碎氛辆巡挂啖橐悒得А压 愎氛韫臻肆衣吨 blueprint ⑼泻
           • 喾も光怕辗砧悛椁敲吐勹愎窃恃路砧嗨烈惺 费椐撮夜⑼У亚唰怨崤肖且谅摇ц衣愎∫绵谜鹿觅 费椐拐樗烈旅橇费椐 我渺瘁敲 康 崆渺 崤朽っ淄㈣ 衣 鸵ǖ橥Я铡颐反释横判街⊥好痢柰埂颐悛椐夜鸳
           • 氛辆巡挂甸艇琳窃恃路讶轨嗒鸳呵°埂颐酚б 喙阻艇ㄒ》樟狙补伊选烈ㄒ∈枨恭夜撮夜喾も光怕帐颐使喾柔佃愎喙组艇夜鸳驷砰 假殂嗷绻疏枪⒀亨づ阻凸 囱Ч验龚支ㄓ嗷绻吐枰澡Х砧ㄐ闼榧匍悛猷㈤伊颐枨练缨夜撮锹笛椐岬璧楣猡莽∫
           • 甸艇裂韫悒浯榍枰氛辆巡挂啖橐悒嗷绻吐枰Т斩支で伊岬〉枰А压眯饲枰О夜㈤土倥化院训浴颐崤邪夜㈤土倥使押使毓∫玫汛试广
           • ㄑ淬碎琳∫媒帧秃昧獯陇敲嗷绻∫媒帧秃昧¤凸嗝澡菱っА颐 獯锣┚倚吐枰澡А颐街⊥好拎≌杪恰押啶米柰Я淄氛柰Г臁猫秀愎∫镁巡挂 费椐拐橥舀嗷绻∫媒帧秃昧ㄒ『迷裳芳匍⒁
           • で盟液丐乓∶氛枇栈眯屎∫贸煦埂颐狙补窑叛Б橥临培咀柰酚斯橐氛杌绻假楱汛∫免っА颐嗣淄堕毅雇Г臁娩凌啶铝栈眯屎∫贸爨怕 鸵è橐Х砧幻帧梢氛枇栅且拎杪仟噎崤辛栈眯屎∫贸齑橐 拐殁绰喋疽辛要枨路樟狙 补
           • 饣冕∶练砧ㄐ悛楣余使廷橥临陪工叛Б橥临诺橥伊颐多谜鹿觅殇撮ц衣崤屑匍悛槭伊颐躲б逛撮吐枰Я栈眯试犯岳揖

拭鼗
           づ学㈤土倥嗷绻∫妹呛们立橥临浓摇耙耿橥临泞艇眯汉б够貉翟б够眯ㄓ茄耿艇艇れ∶ 崤榍褂烈峄脓㈤土倥闼橥沦桡姑倩岷悍砧嗨烈惺零埂颐唷绾崤惺写恰愎∫勉б 崤榍ㄖЧ英橥临殴验灌㈤忆秽$恒工叛Б橥临 (Data Warehouse) ∫镁巡挂嗣淄拭橐Г叛Б橥临帕毅愎艇れ∶ㄐ甸艇琳∫镁渊颐骋吨Г旎眯⊥悍砧ㄓ嗷绻愎∫檬瞄咬闼猷肆倚柿撮锹 费椐拐猷咀柰闼猷≡搐且沥亻沥枰愎∫门Х毓崤朽≡椿眯饴焓侑守吹柰艇れ∶ 吨п灵氰亦筏夤馀抡づ学㈤土倥 ㄐ闼榛眯试犯岳揖愎∫勉㈤土倥吐枰Я摇$狄 岬枋澡Х砧甸艇び怪Ф支撮锹ぷ头醚韭摇梅砧艇れ∶ㄐ甸艇坟枇喾脓浠愎∫镁巡挂眯汉 琳费椐氛枋伊颐肚汛嗷绻笛青г逛撮崤蟹砧淞枋伊颐兜栅枰屯×亦荤沟亚唰怨浯 雇〃摇拐 谎毅姑兴氰咬∫镁巡挂氛柰舀ㄐ唷源⒅楣ü艇れ∶淞枋伊颐定芯巡挂眯汉拐楱故余苗 崤泄恿毅б逛撮 唷源∫门Х毓氛枋侪嗷盆 囱Ч验龚支甸艇琳∫们咬峒工呛へ玲判ㄑ础颐闼槊秃ね  ∫镁乱乱潦瞄咬眯汉 Data Warehouse 岷亨电撩倩岷汗验灌荤恭夜氛璜押凸 で绵迷枇甸狗拥伊⒀楣低勾学佃弯还臻嗑阻弯凌闼猷≡搐且拎收杪с埂颐脓坟沽摇寡


           • 嗝澡恋楣猡莽∫么榍垄挂捶砧淞桡谁枇摇寡 岬栲荤光っА颐氛璺橐芬箩判嗷绻幻锈陋轨 崤秀嗲乓淞枇摇寡 幻辛页 90 茄灌荤沟楣 
           • 酚で伊啖橐悒⊙夯循艘⑼Г臁梅砧へ尘乱乱哩嗅¢ 悛猷桥摇押假殂烈 嗑阻亭楣艘氰尧橥临磐袖梅砧嗷绻氛璧橥А颐 
           • ∮斯储橥临欧验链闼椁煤崤惺梁倜踌氛枋卮岬柰妈颐橇嗤尧橥临欧验链氛枇锗㈤忆 闼猷抛汀嗤亦┚倚㈤土倥氛瑜掖氰舀朽荤够眯饴斓柰で伊¢仪斯橐⑼Г臁 
           • 韭衣伊翟吹柰⊙杭匍嗒砧虑咬啶米廷枰裸狗亍⒀楣低耿艇∫镁巡挂 嗑阻颓脏っ倚遂愎幻朽寸雇妈咬 嗒韫 岷勾烨愿氛栲菊搂就佃汀颐悛椐夜 Warehouse 崤小颐ㄑ础颐首柰室绵咀柰伺铡嗯砧搂谎窑廷谴 嗷绻甸 
           • ∮斯脆っ阻艇磷头亍源氛瑷余荤故铀醚骸颐拭橐 促崤醚∩裔判で氦亓 Data Warehouse 
           • ㄑ础颐秃昧闼椤押假殂 淞栲菊搂岬琛颐秃昧∫勉眯汉喾枰寡楣 岬杪学们龄欢支で伊啖橐悒眯汉室檬灌啡 
           • び怪Ф支嗝阻艇で伊顿〉橥Б艇㈤土倥闼猷苗欠砧守 韭衣伊艘谎窑且良源九掖愎㈤土倥崴盆У楣┖押㈤土倥 嗑阻通兴仪愿蔗¢谎掖学∨枰

¤凸氛琚橥临欧砧荚淳乓川卸佟们拎㈤忆汇 Data Warehouse 
           獯滤叛 颐崤榍 眯汉 Data Warehouse 嗷绻疏枪斯骤Б艇眯汉室檬灌啡 (MIS) ⑼А艇费 瑙嗷绻啶米柰Я淄锹愎∫煤倜骋∫ (Integration) 崤星脏っ倚遂/恃оっ倚遂 (Analysis and Synthesis) ㈤土倥坟∈枨广姑写押化院训浴颐ㄒ》亍斯枨 (斯枨裸春橐Б珠埂押∫谩铀勾嗒鸳仑犯纫实渺崤新胤盖愿闸艇⊥Х丫) 崤卸橐∫煤倜骋∫么学∨枰腔眯屎で伊视嗝绋 嗝摇绋朽绥埂颐低菏雇Б枰鞘颐/室檬灌啡ㄒ 昧借衣嗍挂冈∫檬勹假楹学ぱ汉循眯囱菏侑吐枰Я栈眯试犯岳揖 獯铝辗验Г且撩谴嗝缜 顿〉橥 崤新学室烈枚嗍雇㈤途渊颐骋嗑阻汀颐笛词怨悒浯橥妈咬琳伺选∫冕判嗨地寂 褂浠寿琛颐嗷绻⊥Х丫氛瑾噎┡掖佃弯

嗤∈颐烷咬驮
Arun Sen and Varghese S. Jacob, Industrial Strength Data Warehousing, Communications of the ACM, September 1998, Volume 41, Number 9,p.29-31
Charles bontempo and George Zagelow, The IBM Data Warehouse Architecture, Communications of the ACM, September 1998, Volume 41, Number 9, p.38-48
Mary Ann Richardson,Data Warehousing:Overview,Managing Information Technology,May 1996. On the Internet:
http://www.datapor.com
Stephen R. Gardner,Building the Data Warehouse,Communications of the ACM, September 1998,Volume 41, Number 9, p.52-60.
http://datawarehouse.ittoolbox.com/
http://en.wikipedia.org/wiki/Data_warehouse
www.oracle.com/technology/products/warehouse/
www.bmc.com/products/documents/93/22/9322/9322.pdf
www.statsoft.com/products/ brochures/pdf/datawarehouse.pdf
www2.sas.com/proceedings/sugi22/DATAWARE/PAPER116.PDF
www.educause.edu/ir/library/pdf/eqm0349.pdf
www.nectec.or.th/courseware/ pdf-documents/articles/it-reform-gov.pdf
www.asu.edu/data_admin/ data_warehouse-WUG%20Meetings.html
www.educause.edu/ir/library/powerpoint/CMR0159.pps
www.santafe.cc.fl.us/~faeds/Presentations/
www.tpa.or.th/newtpa/consult/it/it
www.nectec.or.th/courseware/ pdf-documents/articles/it-reform-gov.pdf
www.nitc.go.th/cio/cio_training/peter_walker.pdf



悍で伊氛瑜爻鸵ā优学ら顾:-
     
     
      喙组退曳砧唷砧虑㈤艇 :-
    びら:
    DB function failed with error number 2006
    MySQL server has gone away SQL=SELECT cn.id, cn.contentName FROM info_maincontent AS cn WHERE cn.id in ('','0000') and cn.published = '1' Order by FIELD (cn.id, '','0000') LIMIT 0, 50
    20 脱勾押㈣仪午偷炫枰守
    DB function failed with error number 2006
    MySQL server has gone away SQL=SELECT cn.id, cn.contentName FROM info_maincontent AS cn WHERE cn.id in ('','0000') and cn.published = '1' Order by FIELD (cn.id, '','0000') LIMIT 0, 50
    视寡、枰橇厥旁龄仿饩实
    室煤循嗲绾浍奠 Muslimthaipost.com
    SubDomain 斯橐伺选