Antipattern: Clone Tables or Columns
In the television series Star Trek (âStar Trekâ and related marks are trademarks of CBS Studios Inc.), âtribblesâ are small furry animals kept as pets. Tribbles are very appealing at first, but soon they reveal their tendency to reproduce out of control, and managing the overpopulation of tribbles becomes a serious problem.
The tribble population outgrows every space, and no one wants to take responsibility for them. Eventually, Captain Kirk discovers that his ship and crew canât function, and he has to order his crew to make it top priority to remove the tribbles.
Database tables or columns can become like the tribbles, multiplying out of control, if your database design is to create new tables ...
Get SQL Antipatterns, Volume 1 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.