实例使用DMQL定义星型模式-浙大关于大数据的讲解

时间:2024-05-15 13:25:47
【文件属性】:

文件名称:实例使用DMQL定义星型模式-浙大关于大数据的讲解

文件大小:814KB

文件格式:PPT

更新时间:2024-05-15 13:25:47

大数据算法

实例:使用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)


网友评论