Design Patterns
Ideal Design/Structure for Lookup Tables
In my work over the years that I have continually strived for the ideal structure of a lookup table. I must have designed hundreds of them by now in at least four different RDBMS engines. I may have finally arrived at a structure I really like, so I thought I would share it, with the hope that other people may benefit from adopting it, or even better, suggest improvements to the design.
Categories: Database Design | Design Patterns


Recent comments
3 weeks 5 days ago
3 weeks 5 days ago
38 weeks 4 days ago
39 weeks 3 days ago
39 weeks 3 days ago
40 weeks 3 days ago
41 weeks 7 hours ago
41 weeks 8 hours ago
41 weeks 2 days ago
41 weeks 3 days ago