数据仓库及应用-数据仓库-无锡

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

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

2、ategyDatawarehousesarealsousedformanyotherpurposessuchasproductmanufacturingdatawarehousesDatawarehousesbecomethefocalpointintheenterprise-wideITinfrastructureWhatisDataWarehouse?WhatisDataWarehouseAdatawarehouseissimplyasingle,complete,andconsistentstoreofdata

3、obtainedfromavarietyofsourcesandmadeavailabletoendusersinawaytheycanunderstandanduseinabusinesscontext.WhatisDataWarehouseDataWarehouseDefinitionsThekeyelementsinthedefinitions:Subject-Oriented:Presentationasbusinesssubjects,notascomputerfiles.Integrated:Asingl

4、esourceofinformationforandaboutthebusiness.Non-Volatile:Stableinformationthatdoesn’tchangeeachtimeanoperationalprocessisexecuted.Time-Variant:Containingahistoryofthebusiness,aswellascurrentbusinessinformation.Accessible:Theprimarypurposeofadatawarehouseistoprov

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

6、结算计费帐务系统中心业务管理层网络及网元管理层电信网网元Non-VolatileTimeVariantAccessibleDataWarehouseCharacteristicsDatawarehouseseparatesfunctionsfromoperationalsystems.PropertyOperationalDataWarehouseResponseTimeSub-secondtosecondsSecondstohoursDataOperationDMLPrimarilyreadonlyNatureof

7、Data30-60daysSnapshotsovertimeDataOrganizationApplicationSubject,TimeSizeSmalltolargeLargetoverylargeDataSourcesOperational,InternalOperational,Internal,ExternalActivitiesProcessesAnalysisDataWarehouseCharacteristicsDatawarehouseservesasacentralrepositoryforrec

8、ordingeverythingaboutthebusinessforinformationretrieval.Dataisloadedfrominternalbusinessoperationalsystem,andexternalsystems.DataWarehouseCharacteristicsAdatawarehousehasafu