3 ms·
In NoSQL world, you often store multiple duplicates of the same data, each of which is optimized for a different use case.
by badpun 2y ago
In NoSQL world, you often store multiple duplicates of the same data, each of which is optimized for a different use case.
- dehrmann 2y agoThe SQL world calls this an "index."
- etc-hosts 2y agoI am attempting to reach enlightenment by contemplating your wisdom.
- winrid 2y agoNo. Most NoSQL dbs support indexes and secondary indexes too. In SQL world we call this "denormalization". It's called the same thing in NoSQL, too.
- badpun 2y agoIndices are no good if you constantly do large amounts of inserts or updates (say, entire clickstream of a popular global site) - keeping them up to date will massively slow down the inserts/updates. Wheresas, in NoSQL, you can do as inserts as quickly as your disk can write data, and still query the dataset as if it had an index.