In a typical star schema, you end up with a bunch of columns that are an ID into some lookup table, where the lookup table is pretty much just this:
create table hostnames (
id primary key,
And when you select from your main table, you end up with a bunch of left joins, when you insert, you always have to lookup for the ID first, then insert if it's not there. It's a pain. 50% of my database related code is just for dealing with this.
It would be nice to have a way to indicate to the database that a given column has low number of distinct values, so that it can build its own internal lookup table and save space. The above would become:
create table sometablewithahostname (
hostname varchar(200) keyword,
And there is no need to manage a the other tables. Is there a RDBMS system that does that?