As the old saying goes, "normalize until it hurts; denormalize until it works".