【文件属性】：
文件名称：国科大数据挖掘刘莹第一次作业
文件大小：955KB
文件格式：DOCX
更新时间：2022-03-13 05:08:30
cs dm
1.Suppose that a data warehouse consists of four dimensions, date, spectator, location, and game, and two measures, count and charge, where charge is the fare that a spectator pays when watching a game on a given date. Spectators may be students, adults, or seniors, with each category having its own charge rate.
(a)Draw a star schema diagram for the data warehouse.
(b) Starting with the base cuboid [date, spectator, location, game]，what specific OLAP operations should one perform in order to list the total charge paid by student spectators in Los Angeles?
(c) Bitmap indexing is a very useful optimization technique. Please present the pros and cons of using bitmap indexing in this given data warehouse.