Pros:
Cons: As I mentioned, joins make query slower.
https://www.morpheusdata.com/blog/2015-02-17-pros-cons-db-normalization
But if I rethink on my use case, the join I am having is very basic one which would hardly impact the performance. Also, the category
is a kind of thing whose integrity and consistency should be maintained.
Appreciate this reply, I will say we have Device42 deployed in the environment but I personally am not satisfied with the offering, the product I am most interested in is Morpheus https://www.morpheusdata.com/ and I plan to move forward on an evaluation soon. A co-worker and I were actually talking about deploying NetBox several weeks ago and I need to follow back up on that since you mentioned it.