CODEWITHSUNDEEP
nosql
Dewey Munoz
Dewey Munoz

Reputation: 360

What is the main difference between key-value and wide column nosql databases?

What is the main difference between key-value and wide column? Is it that all data from a given column is stored together, which makes reads of specific columns faster?

Upvotes: 8

Views: 5135

Answers (2)

Carole Nash
Carole Nash

Reputation: 118

A wide-column store is like a 2-dimensional key-value store, where the first key is used as a row identifier and the second is used as a column identifier.

Upvotes: 8

Dewey Munoz
Dewey Munoz

Reputation: 360

With a key-value nosql db, every key only maps to one value. With a wide-column nosql db, every key maps to potentially many columns that can be selected. This can make reads more efficient, since we only need to read the columns that we are interested in. With the key-value nosql db, all the columns would be in the same value field, so everything would have to be read.

Upvotes: 8

Related Questions