元數(shù)據(jù)管理實用專題培訓(xùn)課件

元數(shù)據(jù)管理實用數(shù)據(jù)集成技術(shù)

數(shù)據(jù)展現(xiàn)分析

數(shù)據(jù)倉庫建模

廠商解決方案

談元數(shù)據(jù)管理

數(shù)據(jù)倉庫基礎(chǔ)

項目開發(fā)管理元數(shù)據(jù)管理工具InformaticaMetaManagerDAGMetaCenterIBMMetaStageOracleOWBCADecisionbaseTransformer……元數(shù)據(jù)MDC的開放信息模型分析與設(shè)計（AnalysisandDesign）對象與組件（ObjectandComponent）數(shù)據(jù)庫與數(shù)據(jù)倉庫（DatabaseandWarehousing）業(yè)務(wù)工程（BusinessEngineering）知識管理（KnowledgeManagement） OMG組織的CWM模型UMLMOF（元對象設(shè)施）XMI（XML元數(shù)據(jù)交換）元數(shù)據(jù)的重要性及時發(fā)現(xiàn)系統(tǒng)變化找出需要調(diào)整的ETL程序給出倉庫中數(shù)據(jù)和指標(biāo)的來源及規(guī)則調(diào)整倉庫的數(shù)據(jù)模型促進項目組成員的溝通監(jiān)控數(shù)據(jù)質(zhì)量采用元數(shù)據(jù)跟用戶確認(rèn)新的需求技術(shù)元數(shù)據(jù)業(yè)務(wù)元數(shù)據(jù)業(yè)務(wù)專家元數(shù)據(jù)開發(fā)人員項目經(jīng)理架構(gòu)師誰需要元數(shù)據(jù)業(yè)務(wù)經(jīng)理分析人員業(yè)務(wù)定義如：某銷售指標(biāo)不正確，找出銷售指標(biāo)的計算方法及計算項來源……業(yè)務(wù)專家分析人員開發(fā)人員業(yè)務(wù)專家項目經(jīng)理架構(gòu)師誰需要元數(shù)據(jù)業(yè)務(wù)經(jīng)理元數(shù)據(jù)需求分析定義如：分析指標(biāo)定義、報表定義、數(shù)據(jù)來源定義開發(fā)人員業(yè)務(wù)專家項目經(jīng)理架構(gòu)師誰需要元數(shù)據(jù)業(yè)務(wù)經(jīng)理元數(shù)據(jù)不同開發(fā)小組之間的交流如：DBA工程師與ETL工程師

DBA工程師與BI工程師

…..

分析人員元數(shù)據(jù)開發(fā)人員業(yè)務(wù)專家項目經(jīng)理架構(gòu)師誰需要元數(shù)據(jù)業(yè)務(wù)經(jīng)理業(yè)務(wù)管理與信息消費如：數(shù)據(jù)分析、業(yè)務(wù)決策、給前系統(tǒng)提出改進建議，對數(shù)據(jù)倉庫系統(tǒng)二期、三期提出更多的業(yè)務(wù)需求分析人員開發(fā)人員業(yè)務(wù)專家項目經(jīng)理架構(gòu)師誰需要元數(shù)據(jù)業(yè)務(wù)經(jīng)理元數(shù)據(jù)數(shù)據(jù)倉庫項目管理控制如：定義項目范圍、控制項目風(fēng)險、評估不同系統(tǒng)集成時產(chǎn)生的影響（影響分析）……分析人員元數(shù)據(jù)開發(fā)人員業(yè)務(wù)人員項目經(jīng)理架構(gòu)師誰需要元數(shù)據(jù)業(yè)務(wù)經(jīng)理項目架構(gòu)設(shè)計如：了解多個業(yè)務(wù)系統(tǒng)的結(jié)構(gòu)、關(guān)聯(lián)關(guān)系，數(shù)據(jù)轉(zhuǎn)換規(guī)則設(shè)計…..分析人員元數(shù)據(jù)的存儲區(qū)數(shù)據(jù)倉庫元數(shù)據(jù)結(jié)構(gòu)圖元數(shù)據(jù)管理示意圖源數(shù)據(jù)EDW（ODS+DW+DM）前端工具connections暫存區(qū)元數(shù)據(jù)數(shù)據(jù)庫InformaticaMetadataMangerMetadataObjectBrowserandGraphicalReportsPowerCenterIntegrationServerSuperGlueWarehouseMetadataSourcesSGIntegrationRepositoryCWMClassMetaModelPresentationServerMetadataXConnectsSGConsoleRolebaseddashboardsandMetadataReportsWinNT,2000,XPWarehouseOracle8.1.7,9.2.0.1andabove,10gSQLServer2000SP3DB2UDB8.xEE/EEEIntegrationRepoOracle8.1.7,9.2.0.1andabove,10gSQLServer2000SP3DB2UDB7.xEE/EEEandaboveREPOSITORIESPowerCenterIntegrationServerInformaticaMetadataManagerMetadataObjectBrowserandGraphicalReportsSuperGlueWarehouseSGIntegrationRepositoryCWMClassMetaModelPresentationServerMetadataXConnectsSGConsoleRolebaseddashboardsandMetadataReportsWinNT,2000,XPSERVERSPC7.1.1IntegrationServerPC7.1.1on:NT,SOLARISHPUnix,IBMAIX(PCsupportedversions)PA4.1.1AppsServer[BrowserIE6.0using:iPlanet6.0,IIS6.0ORApache1.3]BEAWL6.1SP4on:NT4.0SP5,NT2000SP2,Win2003SOLARIS7.0,8.0HPUnix11.0,11iIBMAIX4.3,5.1Websphere5.1on:NT4.0SP5,NT2000SP2,Win2003SOLARIS7.0,8.0IBMAIX4.3,5.1MetadataSourcesInformaticaMetadataManagerMetadataObjectBrowserandGraphicalReportsPowerCenterIntegrationServerSuperGlueWarehouseSGIntegrationRepositoryCWMClassMetaModelPresentationServerMetadataXConnectsSGConsoleRolebaseddashboardsandMetadataReportsWinNT,2000,XPETLPowerCenter5.x,6.x,7.x*PowerMart5.x,6.x,7.x*BIPowerAnalyzer4.x*BOBJ5.0,5.1.x,6.xCOGNImpromptu7.x

COGNReportNet1.x

MSTRDesigner7.x

DB2CubeViewsXCONNECTS*(onOracle8.1.7andabove,SQLServer2000SP3andDB27.xEE/EEEandabove)DatabasesOracle8.1.7,9i,10gSQLServer2000Sybase12.xTERADATAV2R5DB2UDB7.1,7.2,8.1EE/EEEIBMInformix9.2DesignToolsERwin3.0to3.5.2,4.0SP1to4.1OracleDesigner1.3.2,2.1.2,6.0,6i,9iSybasePowerDesignerPDM6.1.x,7.5to9.5IBMRationalER98(I)to2000,2000eto2002MicrosoftVISIODatabase(ERX)EmbarcaderoERStudio5.1to6.0

MetadataSourcesSourcedefinition

源系統(tǒng)地址,網(wǎng)絡(luò)連接,訪問方式Location,networkconnection,accessmethods計算機系統(tǒng),操作系統(tǒng)Computerplatformdefinition,operatingsystemdefinition數(shù)據(jù)庫服務(wù)器名,訪問方式,數(shù)據(jù)結(jié)構(gòu),有關(guān)的表,列Databaseservername,accessmethods,schema,table,elementsofinterests源數(shù)據(jù)庫鏈接說明

Sourcedatabaselinks逆工程與源系統(tǒng)設(shè)計獲取定義說明Reverseengineeringandsourcedesigncapturespecification元數(shù)據(jù)交換說明Metadataexchangedefinition

Stagingareadefinition

源至?xí)捍鎱^(qū)映像（Source-stagingmapping）暫存區(qū)至目標(biāo)區(qū)映像Staging-targetmapping中間文件的傳輸說明Filetransportspecification中間文件的說明及使用Filespecificationandusage中間文件的前后處理(清理與壓縮)說明Filepre/posteventprocessingspecification暫存區(qū)數(shù)據(jù)庫的前后處理及中間處理說明及使用Stagingdatabaseusageandpre/postprocessspecificationTargetmodelingdefinition

星結(jié)構(gòu)Starschema事實表定義說明Facttabledefinition度量Measurement數(shù)字鍵Numerickey交替鍵Foreignkey索引Indexdefinition定義數(shù)據(jù)（如數(shù)據(jù)類型，數(shù)值大小和省缺值）有效性制約Validationconstraint數(shù)據(jù)域值定義Datarangevalidation分區(qū)定義說明Partitionspecification存儲說明Storagespecification維表定義與說明Dimensiontabledefinition主鍵Primarykey緩慢變化的維Slowlychangeddimension維的等級/層次Dimensionhierarchy維的共享Dimensionsharing維的版號化Dimensionversioning數(shù)據(jù)庫完整性限定DatabaseintegrityconstraintsTargetmodelingdefinition

維表定義與說明Dimensiontabledefinition主鍵Primarykey緩慢變化的維Slowlychangeddimension維的等級/層次Dimensionhierarchy維的共享Dimensionsharing維的版號化Dimensionversioning數(shù)據(jù)庫完整性限定DatabaseintegrityconstraintsMappingdefinition源至目標(biāo)映像Source-targetmapping基本數(shù)據(jù)到綜合數(shù)據(jù)的映像Basicdata-summarymapping標(biāo)準(zhǔn)字典Standarddictionary轉(zhuǎn)換字典Conversiondictionary參照表Lookuptables映像表MappingtablesETLdefinition轉(zhuǎn)換規(guī)則和方法Conversionruleandmethod數(shù)據(jù)清洗說明Datacleaningspecifications批作業(yè)說明Batchjobspecification加載頻率Loadingfrequency累加時間片控制說明Incrementaltimeslicecontrolspecification回退說明與準(zhǔn)則Rollbackspecificationandpolicy剝離與修改數(shù)據(jù)準(zhǔn)則Stripandmodificationinbounddatapolicy轉(zhuǎn)換函數(shù)庫Conversionfunctionlibrary傳輸定義與說明Transportationdefinition加載定義與說明LoadingdefinitionETLdefinition會期/對話管理定義與說明Sessionmanagementdefinition預(yù)定作業(yè)排時Scheduling批作業(yè)前后事件說明及處理方法Pre-batchandpost-batchjobevents批作業(yè)日志Batchlogging會期/對話日志Sessionlog拒收日志Rejectedlog壞數(shù)據(jù)日志BaddatalogSummarymanagementdefinition事實表/維表至總計方陣映像Fact/dimension-summarycubemapping總計至總計映像Summary-summarymapping總計方陣設(shè)計Summarycubelayout聚合定義說明Aggregatedefinition實體化視圖/方陣定義說明Materializedview/cubedefinition方陣間關(guān)系Relationshipsbetweencubes嵌入式實體化視圖/方陣之間的依賴性Dependencyofnestedmaterializedviews/cubes方陣組GroupingofcubesSummarymanagementdefinition刷新過程的定義與說明Refreshingdefinition刷新前后事件處理說明Pre-refreshingandpostrefreshingevents刷新方法Refreshingmethods刷新組Refreshinggroups刷新執(zhí)行順序Refreshingsequence刷新頻率Refreshingfrequency刷新過程處理軟件Refreshingprocedures刷新作業(yè)的監(jiān)控檢查RefreshingmonitoringOLAPdefinition查詢機制Queryengine虛擬方陣/視圖定義Virtualcube/viewdefinition訪問權(quán)限管理說明Privilegemanagementspecification用戶接口定義與說明Userinterfacedefinition訪問方式Accessmethod結(jié)果數(shù)據(jù)提交方法Deliverymethodanddefinition結(jié)果數(shù)據(jù)傳輸定義與說明Resultsettransportationdefinition用戶登入/登出Userlogin/logoff用戶活動日志以及出錯處理Userlogginganderrorhandling聯(lián)機分析用戶手冊O(shè)LPAUsermanualApplicationSoftwareSpecification軟件版號管理與說明Versioncontrol數(shù)據(jù)庫應(yīng)用版號Databaseapplicationversion軟件與程序版號Softwareandprogramversion程序與數(shù)據(jù)的參照所名Functi