MySQL Forums :: Data Warehouse :: Dimensional model, user ids and number of tables

Thanks for you suggestions.

I have created my fact table, looking like this:

CREATE TABLE IF NOT EXISTS `fact_table` (
`month_key` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`ressource_key` int(10) unsigned NOT NULL,
`group_key` int(10) unsigned NOT NULL,
measures...
PRIMARY KEY (`user_id`,`month_key`,`ressource_key`),
KEY `month_group_key` (`user_id`,`month_key`,`group_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

Any comments on it?

I will create dimensions for ressource_key and group key. I was thinking about using a unix timestamp for the month_key (ie. 10 digit int) or should i use the SQL timestamp?



Edited 4 time(s). Last edit at 06/30/2009 02:26PM by Mads Jensen.