【文件属性】：
文件名称：实例使用DMQL定义星型模式-浙大关于大数据的讲解
文件大小：814KB
文件格式：PPT
更新时间：2021-04-25 19:39:07
大数据算法
实例：使用DMQL定义星型模式
define cube sales_star [time, item, branch, location]:
dollars_sold = sum(sales_in_dollars), avg_sales = avg(sales_in_dollars), units_sold = count(*)
define dimension time as (time_key, day, day_of_week, month, quarter, year)
define dimension item as (item_key, item_name, brand, type, supplier_type)
define dimension branch as (branch_key, branch_name, branch_type)
define dimension location as (location_key, street, city, province_or_state, country)