12 ms·
Is this actually an objective truth? "relational" just refers to the relation within the table, it's less about having a database system with good inter-table r
by d_watt 7y ago
Is this actually an objective truth? "relational" just refers to the relation within the table, it's less about having a database system with good inter-table relationship handling. It happens to be that a lot of the things we think about as relational are OLTP and have good fkeys, etc.
Is there any real reason why a document store can't have good joins between collections? If you index the lookup keys, I don't understand what about the underlying document model would make joining impossible to optimize as well as a relational model.
- alexpetralia 7y agoI don't think most document stores enforce foreign key relationships (and hence consistency) like RDBMS do, so in practice that would make joins difficult.
- d_watt 7y agoIs joining on an fkey any more performant than without it assuming the same indexing is applied? When you say difficult do you mean from a developer ergonomics standpoint (knowing there's data integrity), or from a database optimizability standpoint?
- alexpetralia 7y agoThe former. You have a guarantee of consistency, whereas otherwise you must adjust for this in your application code. Database performance wise I agree they are equivalent.