发表于 2009-1-5 19:48
| 
濡備綍涓 DB2 Cube Views 鏋勫缓鍏冩暟鎹ˉ
鍙戝竷: 2008-7-01 13:53 | 浣滆: admin | 鏌ョ湅: 8娆
濡備綍涓 DB2 Cube Views 鏋勫缓鍏冩暟鎹ˉ
鐑 鑽
銆愬瓧浣擄細灏 澶с
濡備綍涓 DB2 Cube Views 鏋勫缓鍏冩暟鎹ˉ
浣滆咃細锛 鏂囩珷鏉ユ簮锛氾紞 鐐瑰嚮鏁帮細1890 鏇存柊鏃堕棿锛2006-4-22 
John Poelman
DB2 Cube Views Development, IBM 纭呰胺瀹為獙瀹
2003 骞 10 鏈 DB2 鐨 DB2 Cube Views 鍔熻兘閫氳繃鍏变韩鍏崇郴鏁版嵁搴撳拰鍟嗕笟鏅鸿兘搴旂敤绋嬪簭涔嬮棿鐨勫缁村厓鏁版嵁锛屼娇鍟嗕笟鏅鸿兘搴旂敤绋嬪簭涓庢暟鎹粨搴撶殑闆嗘垚鍙樺緱鏇村姞瀹规槗銆備簡瑙ｅ浣曚娇鍟嗕笟鏅鸿兘搴旂敤绋嬪簭鎴栧伐鍏疯兘澶熷埄鐢ㄨ繖涓寮哄ぇ鐨勬柊鍔熻兘銆
鏈枃閫傜敤瀵硅薄
鏈枃鐨勯傜敤瀵硅薄鏄偅浜涘笇鏈涢氳繃浣跨敤 DB2 Cube Views 搴旂敤绋嬪簭缂栫▼鎺ュ彛锛圓PI锛変互渚垮湪 IBM® DB2® Universal Database™ V8锛圲DB锛変笂寮鍙戞垨闆嗘垚 OLAP 搴旂敤绋嬪簭鐨勬妧鏈粡鐞嗗拰鎶鏈汉鍛樸傝淇℃伅灏ゅ叾閫傜敤浜庨偅浜涙瀯寤虹粍浠朵互鍦 DB2 Cube Views 鍜屽叾瀹冨伐鍏锋垨鍏冩暟鎹祫婧愬簱涔嬮棿浜ゆ崲鍏冩暟鎹殑寮鍙戜汉鍛樸備负绠鍗曡捣瑙侊紝鎴戜滑灏嗕氦鎹㈠厓鏁版嵁鐨勮蒋浠剁О涓“鍏冩暟鎹ˉ”鎴栬呭氨鏄“妗”銆
鍏峰鍏崇郴鏁版嵁搴撱佷粨搴撳拰 OLAP 姒傚康鏂归潰鐨勮儗鏅煡璇嗗皢鏈夊姪浜庡鏈枃鐨勭悊瑙ｃ
绠浠
鍏徃鍜岀敤鎴风洰鍓嶆棩鐩婇渶瑕佸叿鏈夊垎鏋愬ぇ鍨嬫暟鎹泦浠ュ強鑳藉娣卞叆璁块棶鍜屾姤鍛婃洿璇︾粏鏁版嵁鐨勮兘鍔涖傝薄 DB2 UDB 涔嬬被楂樺彲浼哥缉鎬х殑鏁版嵁搴撴湇鍔″櫒鍦ㄥ悜浼佷笟浜や粯 OLAP 瑙ｅ喅鏂规涓捣鐫鏃ョ泭閲嶈鐨勪綔鐢ㄣ傞氳繃 DB2 Cube Views锛孌B2 UDB 鎻愪緵浜嗕竴涓敋鑷虫洿鍋ュ．鐨勫熀纭缁撴瀯锛岃繖绉嶅熀纭缁撴瀯鍙互鍦ㄧ瀵圭浠撳簱鍜屽晢涓氭櫤鑳介儴缃蹭腑璧峰埌“閲嶅ぇ鏀拺”浣滅敤銆
瀵逛簬璁稿 OLAP 宸ュ叿鍜屽簲鐢ㄧ▼搴忚岃█锛屼笌 DB2 Cube Views 鐨勯泦鎴愰渶瑕佹瀯寤哄厓鏁版嵁妗ャ傝繖浜涙ˉ鍙互閫氳繃浣跨敤 DB2 Cube Views 鐨勫熀浜 XML 鐨勫瓨鍌ㄨ繃绋嬫帴鍙ｆ潵璇诲彇鎴栧垱寤哄厓鏁版嵁銆傛垜浠皢鍦ㄦ湰鏂囦腑璁ㄨ濡備綍浣跨敤杩欎釜鎺ュ彛鏉ユ瀯寤烘ˉ銆
DB2 Cube Views 鐨勬杩
IBM DB2 Cube Views 鏄 DB2 閫氱敤鏁版嵁搴撶殑闄勫姞鍔熻兘閮ㄤ欢锛屽畠澧炲己浜 DB2 UDB锛屼娇 DB2 UDB 浣滀负寮鍙戝拰閮ㄧ讲鍟嗕笟鏅鸿兘浜у搧鍜屽簲鐢ㄧ▼搴忕殑骞冲彴銆傜壒鍒湴锛孌B2 Cube Views 鏈夊姪浜庡姞閫熶綅浜 DB2 UDB 涓婄殑 OLAP 瑙ｅ喅鏂规鍜屽簲鐢ㄧ▼搴忕殑寮鍙戝拰绠＄悊銆
DB2 Cube Views 鍔熻兘閮ㄤ欢鏄浣曞仛鍒拌繖涓鐐瑰憿锛熼鍏堬紝瀹冨厑璁 DB2 UDB 鏀寔 OLAP銆傚鏋滄病鏈夊缁存暟鎹鍥撅紝鍏崇郴鏁版嵁搴撳浜庝笉鐔熸倝鏁版嵁搴撶粨鏋勫拰鍐呭鐨勪汉鏉ヨ浼间箮鏄竴缁勪护浜虹敓鐣忕殑甯︽湁涓浜涘垪鐨勮〃銆侱B2 Cube Views 鍏冩暟鎹娇鎮ㄨ兘澶熸洿瀹屾暣鍦拌褰 DB2 鏁版嵁搴撲腑鐨勫簳灞傜粨鏋勩
閫氬父锛屼粨搴撴垨鏁版嵁闆嗗競鏄壒鍒负缁村垎鏋愯璁＄殑銆傚湪杩欑鎯呭喌涓嬶紝鏁版嵁搴撻氬父鐢辫缁勭粐涓轰竴涓垨澶氫釜鏄熷瀷锛堟垨闆姳鍨嬶級妯″紡鐨勮〃缁勬垚銆傜畝鍗曠殑鏄熷瀷妯″紡鍖呭惈涓涓簨瀹炶〃锛屼簨瀹炶〃鍛ㄥ洿鏈変竴浜涚淮琛ㄣ備緥濡傦紝浜嬪疄琛ㄥ彲浠ヨ褰曞叕鍙稿悇涓骇鍝佸拰鍒嗗簵姣忔棩閿鍞暟鎹傜淮琛紙鎴栬鏄 PRODUCTS 鍜 STORES 琛級鍙兘鍖呭惈鏈夊叧鍚勪釜浜у搧鍜屽垎搴楃殑璇︾粏淇℃伅锛屽苟涓斾笌浜嬪疄琛ㄧ浉杩炴帴銆
鍏冩暟鎹璞
DB2 Cube Views 鍏冩暟鎹挨鍏舵搮闀挎崟鑾锋槦鍨嬫垨闆姳鍨嬫ā寮忎腑鍥烘湁鐨勭粨鏋勶紙璇峰弬闃 鍥 1锛夈傝鍏冩暟鎹氳繃涓缁勫厓鏁版嵁瀵硅薄鎻愪緵鍏崇郴鏁版嵁鐨“绌洪棿瑙嗗浘”銆傚厓鏁版嵁瀵硅薄琚垝鍒嗕负澶氬眰锛屼粠绠鍗曞璞★紙濡 Attribute锛岀畝鍗曠殑 Attribute 瀵硅〃鍒楀缓妯★級鍒版洿澶嶆潅鐨勫璞★紙濡 Join銆丠ierarchy銆丏imension 鍜 Cube Model锛夈傚畬鏁村畾涔夌殑澶氱淮鏁版嵁妯″瀷瀵硅薄閫氬父绗﹀悎鏄熷瀷锛堟垨闆姳鍨嬶級妯″紡锛屽苟瀵逛竴缁勫叿鏈夊叕鍏辩淮鏁扮殑搴﹂噺寤烘ā銆傜劧鍚庯紝澶氱淮鏁版嵁妯″瀷灏卞皝瑁呭叾瀹 DB2 Cube Views 鍏冩暟鎹璞★紙濡 Dimension 鍜 Measure锛夛紝杩欎竴鐐归兘涓嶅鎬
鍥 1. 寮曠敤鍏崇郴鏄熷瀷妯″紡鐨 DB2 Cube Views 澶氱淮鏁版嵁妯″瀷
绠鑰岃█涔嬶紝DB2 Cube Views 鍏冩暟鎹娇鎮ㄨ兘澶熸崟鑾 DB2 鏁版嵁搴撶殑澶氱淮缁撴瀯鍜岃璁°傚湪 IBM DB2 Cube Views Setup and User's Guide 鐨勭 2 绔犱腑璇︾粏鎻忚堪浜嗗厓鏁版嵁瀵硅薄銆
DB2 Cube Views 鍏冩暟鎹櫎浜嗕娇 DB2 鏀寔 OLAP 澶栵紝鑷冲皯杩樻湁涓ょ浣跨敤鏂规硶锛 DB2 Cube Views 鍔熻兘閮ㄤ欢鍒╃敤鍏冩暟鎹潵浼樺寲鍛戒腑 DB2 鏁版嵁搴撶殑 SQL 鏌ヨ銆 浣嶄簬 DB2 UDB 涔嬩笂鐨勪骇鍝佸拰搴旂敤绋嬪簭鍙互浣跨敤鍏冩暟鎹
璁╂垜浠畝瑕佸湴璁ㄨ涓涓嬭繖涓ょ鐢ㄦ硶銆
灏 DB2 Cube Views 鍏冩暟鎹敤浜庝紭鍖
DB2 Cube Views 閫氳繃鍒涘缓鍚堥傜殑瀹炰緥鍖栫殑鏌ヨ琛紙materialized query table锛孧QT锛夋潵鍔犻 SQL 鏌ヨ锛岃繖浜 MQT 涓繚瀛樹簡棰勫厛鑱氶泦鐨勬暟鎹侻QT 涔熺О涓猴紙鑷姩锛夋眹鎬昏〃銆傚鏋滃彲浠ワ紝DB2 浼樺寲鍣ㄤ細灏 SQL 鏌ヨ閲嶆柊璺敱缁 MQT锛堣鍙傞槄 鍥 2锛夈侻QT 閫氬父姣斿簳灞傜殑鍩烘湰琛紙MQT 鏋勫缓浜庤繖浜涘熀鏈〃涔嬩笂锛夊皬濂藉嚑涓暟閲忕骇銆傚洜鑰岋紝瀵逛簬鍚屼竴涓 SQL 鏌ヨ锛屽皢璇ユ煡璇㈤噸鏂拌矾鐢辩粰 MQT 杩欑鏌ヨ鏂规硶閫氬父姣旂敤鏌ヨ鍩烘湰琛ㄧ殑鏂规硶蹇緱澶氥
