2 ms·
The entire premise of NoSQL is based on two (perceived) shortcomings of SQL databases: its rigid structure limits flexibility and its transactional safety limit
by tremon 10y ago
The entire premise of NoSQL is based on two (perceived) shortcomings of SQL databases: its rigid structure limits flexibility and its transactional safety limits speed and scale. So it really depends on what you mean. No, NoSQL isn't that different from regular SQL in that it still provides an object-based data storage and retrieval facility. Yes, NoSQL is different from regular SQL because it does away with the most fundamental properties of SQL.
isn't a collection pretty much like a table
No, it isn't. A table (or relation) has predefined columns, and each row adheres to the data type and constraints for each column. If you were to model a NoSQL "collection" as a table, you'd end up with a sparse matrix where the number of columns could be equal to number_of_rows * number_of_distinct_attributes of the original collection.
you have to tie two collections together with a common ID
Nothing in SQL requires you to join collections based on a common ID (though it is the most useful). But still, an SQL join has a predefined result structure regardless of the actual table contents or join condition. There is no predicting the data structure of a NoSQL join.