This is a data warehouse pattern - there is a central "Fact" table with integer indexes each of which is the primary key to a different "Dimension" of the data. you can picture it a star with the Fact in the middle surrounded by the Dimensions. Given this structure queries are really easy and flexible and fast. See http://en.wikipedia.org/wiki/Star_schema