国科大数据挖掘刘莹第一次作业

国科大数据挖掘刘莹第一次作业
1.Supposethatadatawarehouseconsistsoffourdimensions,date,spectator,location,andgame,andtwomeasures,countandcharge,wherechargeisthefarethataspectatorpayswhenwatchingagameonagivendate.Spectatorsmaybestudents,adults,orseniors,witheachcategoryhavingitsownchargerate.(a)Drawastarschemadiagramforthedatawarehouse.(b)Startingwiththebasecuboid[date,spectator,location,game]，whatspecificOLAPoperationsshouldoneperforminordertolistthetotalchargepaidbystudentspectatorsinLosAngeles?(c)Bitmapindexingisaveryusefuloptimizationtechnique.Pleasepresenttheprosandconsofusingbitmapindexinginthisgivendatawarehouse. 本软件ID:10968165