The One True look-up Table (OTLT)
"The One True look-up Table (OTLT) is a nightmare that keeps showing up. The idea is that you put ALL the encodings into one huge table rather than have one table for each one."
12/15/20231 min read
The One True look-up Table
The first AppDev I worked on as a programmer (in 1987) had one table containing all reference data as part of the system design provided. Pretty soon I realized that this design approach had some downsides, and I created separate tables for each reference data entity type.
It seems that I am not the only one having this opinion: "The One True look-up Table (OTLT) is a nightmare that keeps showing up. The idea is that you put ALL the encodings into one huge table rather than have one table for each one."
Below are some references to articles related to the One True look-up Table