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.
2023/11/4 18:04:54
955KB
cs
dm