oracle數(shù)據(jù)倉庫解決方案介紹-免費閱讀
【正文】 Lomb ? Bayview Financial Trading Group ? Beckman Coulter ? BellSouth ? British Tele ? Chase Manhattan Bank ? City of Toronto ? Circuit CIty ? CSX Oracle BI/DW最新的客戶 ? ? Eddie Bauer / Spiegel ? Ellis Island Foundation ? Ford Motor (.) ? France Tele ? . Aircraft Engines ? Hillenbrand Industries ? Hitachi Data Systems ? Honeywell ? ? ON Semiconductor ? Reuters ? TruServ ? UBS 16 Oracle數(shù)據(jù)倉庫客戶 (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 days 17 Oracle數(shù)據(jù)倉庫客戶 (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 厭 18 Oracle Warehouse Builder ? 設計 – 圖形化建模、映射關系定義 ? 構造 – 生成數(shù)據(jù)倉庫 – 生成抽取轉換過程 – 元數(shù)據(jù)集成 ? 管理 – 基于元數(shù)據(jù)的數(shù)據(jù)倉庫管理 Common Warehouse Metadata(CWM) DW/BI Tools CWM API CWM Model Services Interchange Repository O8i/9i 20 OWB設計和部署流程 設計目標數(shù)據(jù)倉庫 1 2 定義源數(shù)據(jù) ? 關系性數(shù)據(jù) ? 文本文件 ? 主機 映射源數(shù)據(jù) 3 Oracle9i 生成代碼 4 實例數(shù)據(jù)倉庫 5 抽取和轉換數(shù)據(jù) 6 21 開放
教學課件相關推薦
鄂ICP備17016276號-1