oracle數(shù)據(jù)倉(cāng)庫(kù)解決方案(編輯修改稿)
2025-02-27 13:46 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 d from other HW platform in 60 days17Oracle數(shù)據(jù)倉(cāng)庫(kù)客戶 (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)庫(kù)管理Common Warehouse Metadata(CWM)DW/BI ToolsCWM APICWM ModelServicesInterchangeRepositoryO8i/9i20OWB 設(shè)計(jì)和部署流程設(shè)計(jì)目標(biāo)數(shù)據(jù)倉(cāng)庫(kù)12 定義源數(shù)據(jù)? 關(guān)系性數(shù)據(jù)? 文本文件? 主機(jī)映射源數(shù)據(jù)3Oracle9i生成代碼4實(shí)例數(shù)據(jù)倉(cāng)庫(kù)5抽取和轉(zhuǎn)換數(shù)據(jù)621開放的數(shù)據(jù)接口? 數(shù)據(jù)源– Oracle– Flat Files– ODBC– SAP R/3*– DB2, Sybase, Informix, SQL Server (via Oracle Transparent Gateways)– Mainframe22ETL的流程化處理23數(shù)據(jù)倉(cāng)庫(kù)全生命周期管理?再導(dǎo)入 : 更改 OWB資源庫(kù)?數(shù)據(jù)倉(cāng)庫(kù)的升級(jí) : 修改目標(biāo)數(shù)據(jù)Data Source Oracle8i TargetOWB RepositoryReimportWarehouse UpgradeReimport24元數(shù)據(jù)報(bào)告和影響分析25OWB 的價(jià)值? 圖形化的設(shè)計(jì)和管理工具? 數(shù)據(jù)倉(cāng)庫(kù)全生命周期管理? 集中的元數(shù)據(jù)管理? 優(yōu)化的數(shù)據(jù)倉(cāng)庫(kù)模型26決策分析的全過(guò)程報(bào)表 OLAP隨機(jī)查詢數(shù)據(jù)挖掘決策RepotsDiscovererExpress(OLAP option)Darwin(Data Mining option)27Oracle Reports企業(yè)級(jí)的報(bào)表工具? 豐富的報(bào)表樣式? 多種文件格式(PDF,HTML,XML,XSL) ? 可擴(kuò)展的性能 (Report Server)? Web 發(fā)布28數(shù)據(jù)倉(cāng)庫(kù)業(yè)務(wù)用戶數(shù)據(jù)層語(yǔ)義層專業(yè)技術(shù)人員Oracle Discoverer業(yè)務(wù)人員的查詢工具29業(yè)務(wù)量廣東省中山市詳細(xì)記錄外部數(shù)據(jù)– Drill Down– Drill Across– Dril
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1