文件名称：实例使用DMQL定义雪花模式-浙大关于大数据的讲解
文件大小：814KB
文件格式：PPT
更新时间：2024-05-15 13:25:48
大数据算法
实例：使用DMQL定义雪花模式 define cube sales_snowflake [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(supplier_key, supplier_type)) define dimension branch as (branch_key, branch_name, branch_type) define dimension location as (location_key, street, city(city_key, province_or_state, country))