There are alot of resources with modeling document NoSQL databases that describe embedded vs normalized, multicollection approach. But i could find very few about third, middle-way, which actually sounds most like the core of NoSQL: keeping multiple document types in same collection.
There are implementation details like having type
field for each document and index on it but what i cannot find some info about is what is the turning point in deciding if some documents should be separate into different colletions or kept within the same?
I've found some sources mentioning collection size, but still, that doesn't either sound like the good reason because sharding/scaling single collection with multiple document types also sound like a perfectly viable option to me.
So, i am trying to find out some explanation, what is that 'The Reason' when deciding between single collection multiple document types vs multiple collections each storing one document type?
I don't know if its significant, but if it is, i am thinking in context of MongoDB and DocumentDB.