4 ms·
> If your data has a one-to-many relationship, then Document Database (NoSQL) is more appropriate. Maybe. Probably not. But what happens when you want to query
by eyelidlessness 5y ago
> If your data has a one-to-many relationship, then Document Database (NoSQL) is more appropriate.
Maybe. Probably not. But what happens when you want to query the inverse many-to-one relation? Unless your document store is effectively indexing these one-to-many relations as another document store with inverse relations (at which point you have an RDBMS regardless of what you call it), it’s probably going to be wildly inefficient.
- esclerofilo 5y agoArticle agrees, check out the picture at the end. It has "many to one" listed as a relational strength.
- eyelidlessness 5y agoI know, that’s part of why I found the quote so off and felt like it should be questioned directly.