oracle數(shù)據(jù)倉(cāng)庫(kù)解決方案介紹-文庫(kù)吧資料
2025-02-13 13:46本頁(yè)面
【正文】 – 分區(qū)– 并行處理? 管理大用戶(hù)數(shù)– 資源管理 : 內(nèi)存 , CPU, 并行度– RAC? 提高查詢(xún)性能– 位圖連接索引 , 物化視圖? OLAP? 數(shù)據(jù)挖掘15? ABNAMRO? ACCO? Agilent? ? American General Financial? Bausch Lomb? Bayview Financial Trading Group? Beckman Coulter? BellSouth? British Tele? Chase Manhattan Bank? City of Toronto? Circuit CIty? CSXOracle BI/DW最新的客戶(hù)? ? Eddie Bauer / Spiegel? Ellis Island Foundation? Ford Motor (.)? France Tele? . Aircraft Engines? Hillenbrand Industries? Hitachi Data Systems? Honeywell? ? ON Semiconductor ? Reuters? TruServ? UBS16Oracle數(shù)據(jù)倉(cāng)庫(kù)客戶(hù) (1)? WellsFargo– 6+ TB raw data, Sun E10000, star schema– Recently merged two 3TB instances? Large Financial Institution– 5 TB raw data, IBM SP 52node, 200 CPU抯– hybrid schema, many starlike queries– data warehouse in 4th generation? Amazon– TB raw data, HP Superdome, 64 CPU抯– Hybrid schema, 500+ users, 1000 queries / day– migrated from other HW platform in 60 days17Oracle數(shù)據(jù)倉(cāng)庫(kù)客戶(hù) (2)?Large Telco Company– 10+ TB raw data, HP Superdome– 3NF schema– usage of range partitioning and TTS to keep DW near realtime to OLTP systems ( ~ 1 hour delta)?Acxiom– several DW, largest 6 TB raw data, 4 node Compaq cluster– Hybrid schema– Database resource manager for SLA抯– ?..Oracle抯 scalability depends on how well you do the HW side ?Oracle has no restricition in scalability 厭18Oracle Warehouse Builder ?設(shè)計(jì)– 圖形化建模、映射關(guān)系定義?構(gòu)造– 生成數(shù)據(jù)倉(cāng)庫(kù)– 生成抽取轉(zhuǎn)換過(guò)程– 元數(shù)據(jù)集成?管理– 基于元數(shù)據(jù)的數(shù)據(jù)倉(cāng)
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1