Parable of the Watchmakers
There once were two watchmakers, named Hora and Tempus, who made very fine watches. The phones in their workshops rang frequently; new customers were constantly calling them. However, Hora prospered while Tempus became poorer and poorer. In the end, Tempus lost his shop. What was the reason behind this?
The watches consisted of about 1000 parts each. The watches that Tempus made were designed such that, when he had to put down a partly assembled watch (for instance, to answer the phone), it immediately fell into pieces and had to be reassembled from the basic elements.
Hora had designed his watches so that he could put together subassemblies of about ten components each. Ten of these subassemblies could be put together to make a larger sub- assembly. Finally, ten of the larger subassemblies constituted the whole watch. Each subassembly could be put down without falling apart.
For the longest time I have been playing with interrogatives and associations. Now, I think I finally have a complete representation and taxonomy.
Abstractly, it looks like the following:
Concretely, it appears as follows:
As I mentioned in my earlier post, I was not satisfied with a six interrogative, four association model. Consequently, I worked to resolve this and came up with the table above with the interrogative columns (seven hats) and the associative rows (seven coats). I also came up with the data model below:
My hypothesis is, used correctly, the above data model can address all relational/dimensional requirements.
- The Art of Database Normalizaton
- STL Shakedown R0.4
- Implicity and Explicity
- Listening is Inductive; Speaking is Deductive
- The Six Hats, Six Coats Framework