mondrian mysql 实例_Mondrian测试数据库footmart生成记

mysql> show tables;

+-------------------------------+

| Tables_in_foodmart |

+-------------------------------+

| account |

| agg_c_10_sales_fact_1997 |

| agg_c_14_sales_fact_1997 |

| agg_c_special_sales_fact_1997 |

| agg_g_ms_pcat_sales_fact_1997 |

| agg_l_03_sales_fact_1997 |

| agg_l_04_sales_fact_1997 |

| agg_l_05_sales_fact_1997 |

| agg_lc_06_sales_fact_1997 |

| agg_lc_100_sales_fact_1997 |

| agg_ll_01_sales_fact_1997 |

| agg_pl_01_sales_fact_1997 |

| category |

| currency |

| customer |

| days |

| department |

| employee |

| employee_closure |

| expense_fact |

| inventory_fact_1997 |

| inventory_fact_1998 |

| position |

| product |

| product_class |

| promotion |

| region |

| reserve_employee |

| salary |

| sales_fact_1997 |

| sales_fact_1998 |

| sales_fact_dec_1998 |

| store |

| store_ragged |

| time_by_day |

| warehouse |

| warehouse_class |

+-------------------------------+

可以看出这里面的store_sales、store_cost、unit_sales可以作为度量的列，然后将他们使用某些聚合方式计算就能够作为度量了。其余的例如product_id、time_id、customer_id、promotion_id、store_id是其它维度表的主键，通过这个id来关联维度表，例如与time_id关联的表是time_by_day，表结构以下：