Re:The growing irrelevance of MongoDB
by xerophyte12932 on Wednesday January 14, 2015 @07:56AM
(#8885900)
I would probably solve this problem using Relational DB by having an ItemHeader table with all the common attributes. Then will make an ItemAttributes table where I'd use the foreign key of the first table and just have Key/value pairs for all the unique attributes you want to give to the item. Any sort of query on any of the attributes can be one via a simple join.
Though i suppose it gets trickier if attributes may have sub attributes etc....
Though i suppose it gets trickier if attributes may have sub attributes etc....