商务智能解决方案

Sybase/BusinessIntelligenceSYBASE数据仓库/商务智能解决方案魏健商务智能咨询顾问SYBASE软件(中国)有限公司议程数据仓库解决方案概述数据仓库设计工具数据仓库引擎SybaseAdaptiveServerIQMultiplex“数据仓库是在企业管理和决策中面向主题的,集成的,与时间相关的和不可修改的数据集合”BillInmon数据仓库定义OLTP系统5-10年过去详细数据当前详细数据轻度汇总数据高度汇总数据数据集市用户分析网络资源分析数据仓库数据仓库/决策分析系统数据仓库是完全不同的数据库系统RDBMSSybaseSAP/ERPVSAMEXCEL操作(业务)系统特性事务处理性能是第一位的支持日常的业务事务驱动面向应用数据是当前的并在不断变化存储详细数据(每一个事件或事务)针对快速预定义的事务优化设计可预见的使用模式支持办事人员或行政人员数据仓库应用系统特点支持长远的业务战略决策分析驱动面向主题数据是历史的数据反映某个时间点或一段时间数据是静态的，除数据刷新外数据是汇总的优化是针对查询而不是更新支持管理人员和执行主管人员DATADATADATADATADATADATADATADATADATADATADATADATADATADATA数据仓库解决方案解决从数据库中获取信息的问题。INFORMATION信息信息INFORMATION什么是数据仓库解决方案？应用价值时间1.日常报表2.即席查询3.分析4.数据挖掘专题应用1234数据仓库应用类型数据仓库应用数据仓库系统体系架构RelationalPackageLegacyExternalsourceDataCleanToolSourceDataDataStagingWareHouseAdmin.ToolsEnterpriseDataWarehouseDataExtraction,TransformationandloadDatamartDatamartEnterprise/CentralDataWarehouseRDBMSROLAPRDBMSDimensionModelingConformeddimension&factIncludingatomic&aggregateArchitectedDatamartsCentralMetadataDataModelingToolEnd-UserToolEnd-UserToolMDBEnd-UserToolEnd-UserToolLocalMetadataLocalMetadata数据仓库/商务智能应用成功的关键•做什么，怎么做？•数据仓库性能Sybase&Partner专业服务数据仓库顾问咨询IndustryWarehouseStudioSybaseIWS方法学ERDesignToolImpactAnalysisMetadataManagementSybaseIndustryWarehouseStudio打包的数据仓库基础平台概述业务模型物理模式元数据ETL工具例子报表算法ETLToolMetadataExchangeSmartETLMaps(Future)SQLTemplatesCognosBusinessObjectsMicroStrategyBusinessModelsfocusedonKeyIndustryEventsEnterprise-wide,StarSchema-baseddesignIWS产品介绍TABLETABLETABLETABLETABLEIndustry-specificDataModelsDataWarehouse“OpenRDBMS*”ORACLE,IBM,MICROSOFT,NCR,SYBASE,etc.BIPartnersSampleApplicationsAnalyticalCRM•SalesAnalysis•CustomerProfiling•CampaignAnalysis•CustomerCareAnalysis•LoyaltyAnalysisBusinessPerformanceAnalysis•IndustrySpecificSampleDataGeneral-RepresentativeSystemsIntegratorsGuideProjectPlansImplementationProtocole.g.InformaticaETLToolWarehouseArchitectMulti-DimensionalDesignToolSQLSampleReportsWarehouseControlCenterMetaDataManagement客户构成分析营销活动分析客户兴趣分析忠诚度分析销售分析行业相关的经营业绩分析收益率分析EVT_TYP_ID=EVT_TYP_IDPRD_ID=PRD_IDENTY_ID=ENTY_IDENTY_ID=EMP_IDGEO_ID=GEO_IDLANGUAGE_ID=LANGUAGE_IDPRODUCT_ID=PRODUCT_IDDEMO_ID=DEMO_IDENTY_ID=V_E_ENTY_IDENTY_ID=ENTY_IDENTY_ID=F_C_ENTY_IDCOR_EVT_TYP_ID=COR_EVT_TYP_IDCOR_RPT_STRC_ID=COR_RPT_STRC_IDENTY_ID=CNTC_RSOL_EMP_IDGEO_ID=GEO_IDFNCL_SCOR_ID=FNCL_SCOR_IDMEASURE_UNIT_ID=MEASURE_UNIT_IDCOR_EVT_TXN_ID=COR_EVT_TXN_IDLANGUAGE_ID=LANGUAGE_IDCOR_EVT_TXN_SEQ_NB=COR_EVT_TXN_SEQ_NBPN_BHVR_SCOR_ID=PN_BHVR_SCOR_IDPRODUCT_ID=PRODUCT_IDDEMO_ID=DEMO_IDENTY_ID=ENTY_IDFNCL_SCOR_ID=FNCL_SCOR_IDMEASURE_UNIT_ID=MEASURE_UNIT_IDDEMO_ID=DEMO_IDPRODUCT_ID=PRODUCT_IDPN_BHVR_SCOR_ID=PN_BHVR_SCOR_IDLANGUAGE_ID=LANGUAGE_IDFNCL_SCORES_ID=FNCL_SCOR_IDMEASURE_UNIT_ID=D_M_MEASURE_UNIT_IDMEASURE_UNIT_ID=MEASURE_UNIT_IDGEO_ID=GEO_IDCOR_RPT_STRC_ID=COR_RPT_STRC_IDEVT_TYP_ID=COR_EVT_TYP_IDENTY_ID=F_C_ENTY_IDGEO_ID=GEO_IDLANGUAGE_ID=LANGUAGE_IDEVT_TYP_ID=EVT_TYP_IDDV_HR_EVT_TYPEEVT_TXN_IDpk,fkINTEGEREVT_TYP_IDfkINTEGEREVT_TYP_SHRT_NMCHAREVT_TYP_FULL_NMcharEVT_TYP_CAT_SHRT_NCHAREVT_TYP_CAT_FULL_NcharF_HR_EVTV_E_ENTY_IDfkINTEGERV_E2_ENTY_IDfkINTEGEREVT_DT_PRD_IDINTEGERADMINpk,fkINTEGEREVT_EMP_IDpk,fkINTEGEREVT_EMP_DEMOpk,fkINTEGEREVT_ADMIN_DEMOpk,fkINTEGERCORE_EXT_IDpk,fkINTEGERCORE_RPTG_STRUCpk,fkINTEGERGEO_IDpk,fkINTEGERMU_IDpkINTEGERFIN_SCORE_IDpk,fkINTEGERLANGUAGE_IDpk,fkINTEGERPB_SCORE_IDpkINTEGERF_C_ENTY_IDfkINTEGERPRODUCT_IDpkINTEGERDEMO_IDpk,fkINTEGEREMP_IDpk,fkINTEGERCDEX_SEQ_NOpkINTEGERQTYintegerF_CORE_EVTCOR_EVT_TXN_IDpkINTEGERCOR_EVT_TYP_IDpk,fkINTEGERD_M_MEASURE_UNIT_IDfkINTEGERCOR_RPT_STRC_IDpk,fkINTEGERGEO_IDpk,fkINTEGERMEASURE_UNIT_IDpk,fkINTEGERFNCL_SCOR_IDpk,fkINTEGERLANGUAGE_IDpk,fkINTEGERPN_BHVR_SCOR_IDpk,fkINTEGERPRODUCT_IDpk,fkINTEGERDEMO_IDpk,fkINTEGERENTY_IDpk,fkINTEGERV_E_ENTY_IDfkINTEGERCOR_EVT_TXN_SEQ_NBpkNUMBERPRD_IDfkINTEGERAMOUNTNUMBERD_CORE_EVT_TYPEVT_TYP_IDpkINTEGEREVT_TYP_SHRT_NAMVARCHAR(15)EVT_TYP_LONG_NAMVARCHAR(35)EVT_TYP_SUBTYP_NAMVARCHAR(15)D_CORE_RPT_STRCCOR_RPT_STRC_IDpkINTEGERHOLDING_COMPANYVARCHAR(35)ORG_TYPEVARCHAR(20)ORG_NAMEVARCHAR(35)REGIONVARCHAR(20)SALES_TEAM_TYPEVARCHAR(15)SALES_TEAMVARCHAR(15)SALES_PERSON_NAMEcharSALES_PERSON_GRADECHARSALES_PERSON_TYPECHARCHNL_CATEGORY1char(18)CHNL_TYPECHARCHNL_SUBCATCHARCHNL_NAMEcharCHNL_CEASED_TRD_DTDATECHNL_ENTY_IDINTEGERCHNL_CITYVARCHAR(20)CHNL_POSTCODEVARCHAR(20)BEGIN_DATE_PRD_IDINTEGEREND_DATE_PRD_IDINTEGERD_GEOGRAPHYGEO_IDpkINTEGERALL_ENTRIESCHARPOSTAL_CODECHARVARYING(15)CITYcharPOSTAL_CD_PFXchar(3)HZRD_WTHR_AREACHARHZD_WTHR_TYPECHARDMA_CODECHARSMSA_CODECHARST_PROV_AREACHARTV_REGIONCHARNTL_RADIO_AREACHARLCL_RADIO_AREACHARREGIONCHARCOUNTRYchar(3)CONTINENTY_ABBRchar(3)GEO_SUB_CNTNT_ABBRchar(3)SMRY_EFF_DTINTEGERSMRY_END_DTINTEGERPRISN_ADRS_INDCHARD_MSR_UNITMEASURE_UNIT_IDpkINTEGERSHRT_DESCchar(6)LONG_DESCchar(20)D_DEMOGRAPHICSDEMO_IDpkINTEGERALL_ENTRIESCHARINCOME_BANDVARCHAR(50)AGE_BANDVARCHAR(50)GNDRCHARMRTL_STATCHARHIGH_VALUE_INDICATCHARACMDTN_CTGRYCHARNBR_IN_HH_BANDVAR