郑保卫：数据架构及数据建模

2012.09.14数据架构及数据建模SACC2012SACC2012A-PDFWatermarkDEMO:Purchasefrom数据发展战略Ⅰ1SACC2012SACC201204与数据相关的技术BI:BusinessIntelligenceDataGovernanceDataIntegrationDataQualityDataWarehouseETLMDM(MasterDataManagement)BPM(BusinessProcessManagement)ContentManagementCRM(CustomerRelationshipManagement)CDI(CustomerDataIntegration)CustomerIntelligenceDataAcquisition,ReplicationDataAnalysisDataArchitectureDataManagementDataMartsDataMigraitonDataMiningDataModelingDataProfilingDataVisualizationDatabaseMarketingDatabaseApplicationPerformanceDatabasesDWDesign,MethodolotyEA(EnterpriseArchitecture)EAI(EnterpriseApplicationIntegration)MetadataManagementOperationalDataStoreRTE(Real-TimeEnterprise)SOA(Service-OrientedArchitecture)05数据趋势ProcessfailureandinformationscrapandreworkcausedbydefectiveinformationcoststheUnitedStatesalone$1.5trillionormore.Best-practicedataqualityprogramsarenotaone-shotmeasure(cleanupandmoveon)...Toachievesuchresults,successfulprogramsidentifytheorganizationalprocessesbehinddataquality.MuchlikeregularIThousekeeping,fromvirusscanningorperformancemonitoringtodatabackup,thedataqualityprogrambecomespartofdailyITroutine.Gartner,Incpressrelease.“'DirtyData'isaBusinessProblem,NotanITProblem,SaysGartner,”March2,2007.English,Larry.“PlainEnglishaboutInformationQuality:InformationQualityTippingPoint.”DMReview,July2007.Overthenexttwoyears,morethan25percentofcriticaldatainFortune1000companieswillcontinuetobeflawed,thatis,theinformationwillbeinaccurate,incompleteorduplicated…“OrganizingforDataQuality.”ResearchnotefromGartnerInc.,June1,2007.IDCestimatesthattheworldwillreachazettabyteofdata(1,000exabytesor1millionpedabytes)in2010Mearian,Lucas.“Azettabyteby2010:Corporatedatagrowsfiftyfoldinthreeyears.”Computerworld,March6,2007.QuantityQualitySACC2012SACC201206数据趋势MikeFerguson“AcceleratingEnterpriseDataGovernance”IntelligentBusinessStrategies.December2007Datagovernance(DG)referstotheoverallmanagementoftheavailability,usability,integrity,andsecurityofthedataemployedinanenterprise.Asounddatagovernanceprogramincludesagoverningbodyorcouncil,adefinedsetofprocedures,andaplantoexecutethoseprocedures.Manycompanieshavedifficultykeepingdataconsistent,synchronisedandinahighqualitystate,Dataneedstobemanagedinarobustway,soDatagovernanceisneeded.Enterprisedatagovernancerequiressystematicimplementationofcommonprocessesviare-usableservicesonadatamanagementplatform.DatagovernanceprocessescanbeautomatedusingdataservicesbuiltusingworkflowanddeployedonadataManagementplatformGovernance07DataGovernanceMaturityModelGovernance‘TheDataGovernanceMaturityModel’,2007,DataFluxThinkLocally,ActLocallyThinkGlobally,ActLocallyThinkGlobally,ActCollectivelyThinkGlobally,ActGloballyUNDISCIPLINEDREACTIVEPROACTIVEGOVERNEDLOWHIGHRewardLOWHIGHRiskLOWHIGHDatabaseMarketingSFADataWarehouseERPCRMCDIPDMMDMBPMIntegrationPeople,Policies,TechnologyAdoptionCDI:CustomerDataIntegrationPDM:ProductDataManagementMDM:MasterDataManagementBPM:BusinessProcessManagementSFA:SalesForceAutomationDQMSSACC2012SACC2012数据架构Ⅰ208EnterpriseArchitectureFrameworke.g.DATAe.g.DataDefinitionEnt=FieldReln=Addresse.g.PhysicalDataModelEnt=Segment/Table/etc.Reln=Pointer/Key/etc.e.g.LogicalDataModelEnt=DataEntityReln=DataRelationshipe.g.SemanticModelEnt=BusinessEntityReln=BusinessRelationshipListofThingsImportanttotheBusinessENTITY=ClassofBusinessThingListofProcessestheBusinessPerformsFunction=ClassofBusinessProcesse.g.ApplicationArchitectureI/O=UserViewsProc.=ApplicationFunctione.g.SystemDesignI/O=DataElements/SetsProc.=ComputerFunctione.g.ProgramI/O=ControlBlockProc.=LanguageStmte.g.FUNCTIONe.g.BusinessProcessModelProc.=BusinessProcessI/O=BusinessResourcesListofLocationsinwhichtheBusinessOperatesNode=MajorBusinessLocatione.g.BusinessLogisticsSystemNode=BusinessLocationLink=BusinessLinkagee.g.DistributedSystemNode=I/SFunction(Processor,Storage,etc)Link=LineCharacteristicse.g.TechnologyArchitectureNode=Hardware/SystemSoftwareLink=LineSpecificationse.g.NetworkArchitectureNode=AddressesLink=Protocolse.g.NETWORKArchitecturee.g.RuleSpecificationEnd=Sub-conditionMeans=Stepe.g.RuleDesignEnd=ConditionMeans=Actione.g.BusinessRuleModelEnd=StructuralAssertionMeans=ActionAssertionEnd=BusinessObjectiveMeans=BusinessStrategyListofBusinessGoals/StratEnds/Means=MajorBus.Goal/CriticalSuccessFactorListofEventsSignificantTime=MajorBusinessEvente.g.ProcessingStructureCycle=ProcessingCycleTime=SystemEvente.g.ControlStructureCycle=ComponentCycleTime=Executee.g.TimingDefinitionCycle=MachineCycleTime=Interrupte.g.SCHEDULEe.g.MasterScheduleTime=BusinessEventCycle=BusinessCycleListofOrganizationsPeople=MajorOrganizationse.g.WorkFlowModelPeople=OrganizationUnitWork=WorkProducte.g.HumanInterfacePeople=RoleWork=Deliverablee.g.PresentationArchitecturePeople=UserWork=ScreenFormate.g.SecurityArchitecturePeople=IdentityWork=Jobe.g.ORGANIZATIONtotheBusinessImportanttotheBusinessArchitecturee.g.STRATEGYe.g.BusinessPlanCONCEPTUALLOGICALPHYSICALOUT