元數(shù)據(jù)管理實用ppt課件

《元數(shù)據(jù)管理實用ppt課件》由會員分享，可在線閱讀，更多相關《元數(shù)據(jù)管理實用ppt課件（33頁珍藏版）》請在裝配圖網(wǎng)上搜索。

元數(shù)據(jù)管理,1,數(shù)據(jù)集成技術,數(shù)據(jù)展現(xiàn)分析,數(shù)據(jù)倉庫建模,廠商解決方案,談元數(shù)據(jù)管理,數(shù)據(jù)倉庫基礎,項目開發(fā)管理,元數(shù)據(jù)管理工具,Informatica MetaManager DAG MetaCenter IBM MetaStage Oracle OWB CA Decisionbase Transformer ……,元數(shù)據(jù),MDC的開放信息模型 分析與設計（Analysis and Design） 對象與組件（Object and Component） 數(shù)據(jù)庫與數(shù)據(jù)倉庫（Database and Warehousing） 業(yè)務工程（Business Engineering） 知識管理（Knowledge Management） OMG組織的CWM模型 UML MOF（元對象設施） XMI（XML元數(shù)據(jù)交換）,元數(shù)據(jù)的重要性,及時發(fā)現(xiàn)系統(tǒng)變化 找出需要調整的ETL程序 給出倉庫中數(shù)據(jù)和指標的來源及規(guī)則 調整倉庫的數(shù)據(jù)模型 促進項目組成員的溝通 監(jiān)控數(shù)據(jù)質量 采用元數(shù)據(jù)跟用戶確認新的需求,技術元數(shù)據(jù),業(yè)務元數(shù)據(jù),誰需要元數(shù)據(jù),,,,,誰需要元數(shù)據(jù),,,,,,開發(fā)人員,誰需要元數(shù)據(jù),,,,,,,,,誰需要元數(shù)據(jù),,業(yè)務經(jīng)理,,項目經(jīng)理,誰需要元數(shù)據(jù),,,,,,,,,,架構師,誰需要元數(shù)據(jù),元數(shù)據(jù)的存儲區(qū),數(shù)據(jù)倉庫元數(shù)據(jù)結構圖,元數(shù)據(jù)管理示意圖,源數(shù)據(jù),EDW （ODS+DW+DM）,前端工具,,,connections,暫存區(qū),,,,,元數(shù)據(jù) 數(shù)據(jù)庫,,,Informatica Metadata Manger,,,,,,,,,Informatica Metadata Manager,,,,,,,,Informatica Metadata Manager,,,,,,,* (on Oracle 8.1.7 and above, SQL Server 2000 SP3 and DB2 7.x EE/EEE and above),Source definition,源系統(tǒng)地址, 網(wǎng)絡連接, 訪問方式Location, network connection, access methods 計算機系統(tǒng), 操作系統(tǒng)Computer platform definition, operating system definition 數(shù)據(jù)庫服務器名,訪問方式,數(shù)據(jù)結構,有關的表,列Database server name, access methods, schema, table, elements of interests 源數(shù)據(jù)庫鏈接說明 Source database links 逆工程與源系統(tǒng)設計獲取定義說明Reverse engineering and source design capture specification 元數(shù)據(jù)交換說明Metadata exchange definition,Staging area definition,源至暫存區(qū)映像（Source-staging mapping） 暫存區(qū)至目標區(qū)映像Staging-target mapping 中間文件的傳輸說明File transport specification 中間文件的說明及使用File specification and usage 中間文件的前后處理(清理與壓縮)說明File pre/post event processing specification 暫存區(qū)數(shù)據(jù)庫的前后處理及中間處理說明及使用Staging database usage and pre/post process specification,Target modeling definition,星結構Star schema 事實表定義說明Fact table definition 度量Measurement 數(shù)字鍵Numeric key 交替鍵Foreign key 索引Index definition 定義數(shù)據(jù)（如數(shù)據(jù)類型，數(shù)值大小和省缺值） 有效性制約Validation constraint 數(shù)據(jù)域值定義Data range validation 分區(qū)定義說明Partition specification 存儲說明Storage specification,維表定義與說明Dimension table definition 主鍵Primary key 緩慢變化的維Slowly changed dimension 維的等級/層次Dimension hierarchy 維的共享Dimension sharing 維的版號化Dimension versioning 數(shù)據(jù)庫完整性限定Database integrity constraints,Target modeling definition,維表定義與說明Dimension table definition 主鍵Primary key 緩慢變化的維Slowly changed dimension 維的等級/層次Dimension hierarchy 維的共享Dimension sharing 維的版號化Dimension versioning 數(shù)據(jù)庫完整性限定Database integrity constraints,Mapping definition,源至目標映像Source-target mapping 基本數(shù)據(jù)到綜合數(shù)據(jù)的映像Basic data-summary mapping 標準字典Standard dictionary 轉換字典Conversion dictionary 參照表Lookup tables 映像表Mapping tables,ETL definition,轉換規(guī)則和方法Conversion rule and method 數(shù)據(jù)清洗說明Data cleaning specifications 批作業(yè)說明Batch job specification 加載頻率Loading frequency 累加時間片控制說明Incremental time slice control specification 回退說明與準則Rollback specification and policy 剝離與修改數(shù)據(jù)準則Strip and modification in bound data policy 轉換函數(shù)庫Conversion function library 傳輸定義與說明Transportation definition 加載定義與說明Loading definition,ETL definition,會期/對話管理定義與說明Session management definition 預定作業(yè)排時Scheduling 批作業(yè)前后事件說明及處理方法Pre-batch and post-batch job events 批作業(yè)日志Batch logging 會期/對話日志Session log 拒收日志Rejected log 壞數(shù)據(jù)日志Bad data log,Summary management definition,事實表/維表至總計方陣映像Fact/dimension-summary cube mapping 總計至總計映像Summary-summary mapping 總計方陣設計Summary cube layout 聚合定義說明Aggregate definition 實體化視圖/方陣定義說明Materialized view/cube definition 方陣間關系Relationships between cubes 嵌入式實體化視圖/方陣之間的依賴性Dependency of nested materialized views/cubes 方陣組 Grouping of cubes,Summary management definition,刷新過程的定義與說明Refreshing definition 刷新前后事件處理說明Pre-refreshing and post refreshing events 刷新方法Refreshing methods 刷新組Refreshing groups 刷新執(zhí)行順序Refreshing sequence 刷新頻率Refreshing frequency 刷新過程處理軟件Refreshing procedures 刷新作業(yè)的監(jiān)控檢查Refreshing monitoring,OLAP definition,查詢機制Query engine 虛擬方陣/視圖定義Virtual cube/view definition 訪問權限管理說明Privilege management specification 用戶接口定義與說明User interface definition 訪問方式Access method 結果數(shù)據(jù)提交方法Delivery method and definition 結果數(shù)據(jù)傳輸定義與說明Result set transportation definition 用戶登入/登出User log in/log off 用戶活動日志以及出錯處理User logging and error handling 聯(lián)機分析用戶手冊OLPA User manual,Application Software Specification,軟件版號管理與說明Version control 數(shù)據(jù)庫應用版號Database application version 軟件與程序版號Software and program version 程序與數(shù)據(jù)的參照所名Function-data object references 包/過程軟件/函數(shù)Packages/stored procedures/functions 函數(shù)庫Function library 元件Components 程序調用層次模型定義與說明Hierarchical level model 2-3級結構Architecture – 2-3-tier structure 程序庫Library 業(yè)務規(guī)則定義說明Business Rule definition 業(yè)務規(guī)則表Business rule tables 業(yè)務規(guī)則表與業(yè)務政策的聯(lián)系Association between Business rule and business policies,Quality control and security definition,安全政策Security policy 審計日志Audit log 錯誤捕捉Error trapping 錯誤追朔方法及說明Error tracing method and specification 數(shù)據(jù)庫訪問及網(wǎng)絡交通日志Database access and network traffic logging,,,,,,,,,S-ODS ETL,ODS-DW ETL,DW-DM ETL,SOURCE,ODS,DW,DM,,,,,,,DETAILED INFORMATION:,元數(shù)據(jù)的應用 —— 血緣分析,元數(shù)據(jù)的應用 —— 影響分析,