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
                                            
                                     
                                        
                                            1