資源描述：
《數(shù)據(jù)倉(cāng)庫(kù)及應(yīng)用數(shù)據(jù)倉(cāng)庫(kù)無(wú)錫ppt課件.ppt》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。
1、數(shù)據(jù)倉(cāng)庫(kù)杭誠(chéng)方教授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網(wǎng)管系統(tǒng)財(cái)務(wù)管理系統(tǒng)市場(chǎng)分析決策系統(tǒng)TelcomDWSystem分析型大客戶CRM系統(tǒng)信用度管理客服系統(tǒng)(CallCenter1000/180/112/170）系統(tǒng)其它電信專業(yè)網(wǎng)業(yè)務(wù)系統(tǒng)“九七工程”之營(yíng)業(yè)管理生產(chǎn)調(diào)度系統(tǒng)（配線/配號(hào)/開(kāi)通）112故障查修系統(tǒng)資源管理系統(tǒng)170/催繳系統(tǒng)營(yíng)業(yè)系統(tǒng)本地公司/IC卡/磁卡管理系統(tǒng)
6、網(wǎng)上營(yíng)業(yè)系統(tǒng)商務(wù)管理層省級(jí)計(jì)費(fèi)結(jié)算計(jì)費(fèi)帳務(wù)系統(tǒng)中心業(yè)務(wù)管理層網(wǎng)絡(luò)及網(wǎng)元管理層電信網(wǎng)網(wǎng)元Non-VolatileTimeVariantAccessibleDataWarehouseCharacteristicsDatawarehouseseparatesfunctionsfromoperationalsystems.PropertyOperationalDataWarehouseResponseTimeSub-secondtosecondsSecondstohoursDataOperationDMLPrimari
7、lyreadonlyNatureofData30-60daysSnapshotsovertimeDataOrganizationApplicationSubject,TimeSizeSmalltolargeLargetoverylargeDataSourcesOperational,InternalOperational,Internal,ExternalActivitiesProcessesAnalysisDataWarehouseCharacteristicsDatawarehouseservesasace
8、ntralrepositoryforrecordingeverythingaboutthebusinessforinformationretrieval.Dataisloadedfrominternalbusinessoperationalsystem,andexternalsystems.DataWarehouseCharacteristicsAdatawarehousehasafu
