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
2 days 13 hours ago
37 weeks 10 hours ago
37 weeks 10 hours ago
1 year 19 weeks ago
1 year 20 weeks ago
1 year 20 weeks ago
1 year 21 weeks ago
1 year 22 weeks ago
1 year 22 weeks ago
1 year 22 weeks ago