数据仓库及应用数据仓库无锡ppt课件.ppt

《数据仓库及应用数据仓库无锡ppt课件.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、数据仓库杭诚方教授WhatisDataWarehouseDatawarehouseisaverylargedatabasethatstoresintegrateddataofoneormorebusinesssubjectareasDatawarehouseisbuilttosupportdataanalysisfordecisionmakingIntegratedcustomerdatawarehouseisanecessarysteptothesuccessofthebusinessintelligence

2、strategyDatawarehousesarealsousedformanyotherpurposessuchasproductmanufacturingdatawarehousesDatawarehousesbecomethefocalpointintheenterprise-wideITinfrastructureWhatisDataWarehouse?WhatisDataWarehouseAdatawarehouseissimplyasingle,complete,andconsistentstore

3、ofdataobtainedfromavarietyofsourcesandmadeavailabletoendusersinawaytheycanunderstandanduseinabusinesscontext.WhatisDataWarehouseDataWarehouseDefinitionsThekeyelementsinthedefinitions:Subject-Oriented:Presentationasbusinesssubjects,notascomputerfiles.Integrat

4、ed:Asinglesourceofinformationforandaboutthebusiness.Non-Volatile:Stableinformationthatdoesn’tchangeeachtimeanoperationalprocessisexecuted.Time-Variant:Containingahistoryofthebusiness,aswellascurrentbusinessinformation.Accessible:Theprimarypurposeofadatawareh

5、ouseistoprovidereadilyaccessibleinformationtobusinesspeople.Subject-OrientedIntegratedIntegrated网管系统财务管理系统市场分析决策系统TelcomDWSystem分析型大客户CRM系统信用度管理客服系统(CallCenter1000/180/112/170）系统其它电信专业网业务系统“九七工程”之营业管理生产调度系统（配线/配号/开通）112故障查修系统资源管理系统170/催缴系统营业系统本地公司/IC卡/磁卡管理系统

6、网上营业系统商务管理层省级计费结算计费帐务系统中心业务管理层网络及网元管理层电信网网元Non-VolatileTimeVariantAccessibleDataWarehouseCharacteristicsDatawarehouseseparatesfunctionsfromoperationalsystems.PropertyOperationalDataWarehouseResponseTimeSub-secondtosecondsSecondstohoursDataOperationDMLPrimari

7、lyreadonlyNatureofData30-60daysSnapshotsovertimeDataOrganizationApplicationSubject,TimeSizeSmalltolargeLargetoverylargeDataSourcesOperational,InternalOperational,Internal,ExternalActivitiesProcessesAnalysisDataWarehouseCharacteristicsDatawarehouseservesasace

8、ntralrepositoryforrecordingeverythingaboutthebusinessforinformationretrieval.Dataisloadedfrominternalbusinessoperationalsystem,andexternalsystems.DataWarehouseCharacteristicsAdatawarehousehasafu