oracle數(shù)據(jù)倉庫解決方案介紹-展示頁
2025-06-03 18:02本頁面
【正文】 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è)計 – 圖形化建模、映射關(guān)系定義 ? 構(gòu)造 – 生成數(shù)據(jù)倉庫 – 生成抽取轉(zhuǎn)換過程 – 元數(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è)計和部署流程 設(shè)計目標(biāo)數(shù)據(jù)倉庫 1 2 定義源數(shù)據(jù) ? 關(guān)系性數(shù)據(jù) ? 文本文件 ? 主機(jī) 映射源數(shù)據(jù) 3 Oracle9i 生成代碼 4 實例數(shù)據(jù)倉庫 5 抽取和轉(zhuǎn)換數(shù)據(jù) 6 21 開放的數(shù)據(jù)接口 ? 數(shù)據(jù)源 – Oracle – Flat Files – ODBC – SAP R/3* – DB2, Sybase, Informix, SQL Server (via Oracle Transparent Gateways) – Mainframe 22 ETL的流程化處理 23 數(shù)據(jù)倉庫全生命周期管理 ? 再導(dǎo)入 : 更改 OWB資源庫 ? 數(shù)據(jù)倉庫的升級 : 修改目標(biāo)數(shù)據(jù) Data Source Oracle8i Target OWB Repository Reimport Warehouse Upgrade Reimport 24 元數(shù)據(jù)報告和影響分析 25 OWB 的價值 ? 圖形化的設(shè)計和管理工具 ? 數(shù)據(jù)倉庫全生命周期管理 ? 集中的元數(shù)據(jù)管理 ? 優(yōu)化的數(shù)據(jù)倉庫模型 26 決策分析的全過程 報表 OLAP 隨機(jī)查詢 數(shù)據(jù)挖掘 決策 Repots Discoverer Express (OLAP option) Darwin (Data Mining optio
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1