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

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

元數(shù)據(jù)管理,1,數(shù)據(jù)集成技術(shù),數(shù)據(jù)展現(xiàn)分析,數(shù)據(jù)倉庫建模,廠商解決方案,談元數(shù)據(jù)管理,數(shù)據(jù)倉庫基礎(chǔ),項(xiàng)目開發(fā)管理,元數(shù)據(jù)管理工具,Informatica MetaManager DAG MetaCenter IBM MetaStage Oracle OWB CA Decisionbase Transformer ……,元數(shù)據(jù),MDC的開放信息模型 分析與設(shè)計(jì)（Analysis and Design） 對(duì)象與組件（Object and Component） 數(shù)據(jù)庫與數(shù)據(jù)倉庫（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程序 給出倉庫中數(shù)據(jù)和指標(biāo)的來源及規(guī)則 調(diào)整倉庫的數(shù)據(jù)模型 促進(jìn)項(xiàng)目組成員的溝通 監(jiān)控?cái)?shù)據(jù)質(zhì)量 采用元數(shù)據(jù)跟用戶確認(rèn)新的需求,技術(shù)元數(shù)據(jù),業(yè)務(wù)元數(shù)據(jù),誰需要元數(shù)據(jù),,,,,誰需要元數(shù)據(jù),,,,,,開發(fā)人員,誰需要元數(shù)據(jù),,,,,,,,,誰需要元數(shù)據(jù),,業(yè)務(wù)經(jīng)理,,項(xiàng)目經(jīng)理,誰需要元數(shù)據(jù),,,,,,,,,,架構(gòu)師,誰需要元數(shù)據(jù),元數(shù)據(jù)的存儲(chǔ)區(qū),數(shù)據(jù)倉庫元數(shù)據(jù)結(jié)構(gòu)圖,元數(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)絡(luò)連接, 訪問方式Location, network connection, access methods 計(jì)算機(jī)系統(tǒng), 操作系統(tǒng)Computer platform definition, operating system definition 數(shù)據(jù)庫服務(wù)器名,訪問方式,數(shù)據(jù)結(jié)構(gòu),有關(guān)的表,列Database server name, access methods, schema, table, elements of interests 源數(shù)據(jù)庫鏈接說明 Source database links 逆工程與源系統(tǒng)設(shè)計(jì)獲取定義說明Reverse engineering and source design capture specification 元數(shù)據(jù)交換說明Metadata exchange definition,Staging area definition,源至?xí)捍鎱^(qū)映像（Source-staging mapping） 暫存區(qū)至目標(biāo)區(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,星結(jié)構(gòu)Star schema 事實(shí)表定義說明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 存儲(chǔ)說明Storage specification,維表定義與說明Dimension table definition 主鍵Primary key 緩慢變化的維Slowly changed dimension 維的等級(jí)/層次Dimension hierarchy 維的共享Dimension sharing 維的版號(hào)化Dimension versioning 數(shù)據(jù)庫完整性限定Database integrity constraints,Target modeling definition,維表定義與說明Dimension table definition 主鍵Primary key 緩慢變化的維Slowly changed dimension 維的等級(jí)/層次Dimension hierarchy 維的共享Dimension sharing 維的版號(hào)化Dimension versioning 數(shù)據(jù)庫完整性限定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ù)清洗說明Data cleaning specifications 批作業(yè)說明Batch job specification 加載頻率Loading frequency 累加時(shí)間片控制說明Incremental time slice control specification 回退說明與準(zhǔn)則Rollback specification and policy 剝離與修改數(shù)據(jù)準(zhǔn)則Strip and modification in bound data policy 轉(zhuǎn)換函數(shù)庫Conversion function library 傳輸定義與說明Transportation definition 加載定義與說明Loading definition,ETL definition,會(huì)期/對(duì)話管理定義與說明Session management definition 預(yù)定作業(yè)排時(shí)Scheduling 批作業(yè)前后事件說明及處理方法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 聚合定義說明Aggregate definition 實(shí)體化視圖/方陣定義說明Materialized view/cube definition 方陣間關(guān)系Relationships between cubes 嵌入式實(shí)體化視圖/方陣之間的依賴性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,查詢機(jī)制Query engine 虛擬方陣/視圖定義Virtual cube/view definition 訪問權(quán)限管理說明Privilege management specification 用戶接口定義與說明User interface definition 訪問方式Access method 結(jié)果數(shù)據(jù)提交方法Delivery method and definition 結(jié)果數(shù)據(jù)傳輸定義與說明Result set transportation definition 用戶登入/登出User log in/log off 用戶活動(dòng)日志以及出錯(cuò)處理User logging and error handling 聯(lián)機(jī)分析用戶手冊(cè)O(shè)LPA User manual,Application Software Specification,軟件版號(hào)管理與說明Version control 數(shù)據(jù)庫應(yīng)用版號(hào)Database application version 軟件與程序版號(hào)Software and program version 程序與數(shù)據(jù)的參照所名Function-data object references 包/過程軟件/函數(shù)Packages/stored procedures/functions 函數(shù)庫Function library 元件Components 程序調(diào)用層次模型定義與說明Hierarchical level model 2-3級(jí)結(jié)構(gòu)Architecture – 2-3-tier structure 程序庫Library 業(yè)務(wù)規(guī)則定義說明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ò)誤追朔方法及說明Error tracing method and specification 數(shù)據(jù)庫訪問及網(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)用 —— 影響分析,