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

《元數(shù)據(jù)管理實(shí)用ppt課件》由會(huì)員分享，可在線閱讀，更多相關(guān)《元數(shù)據(jù)管理實(shí)用ppt課件（33頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

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