How to choose between types of Nosql?

Asked

Viewed 76 times

-1

Nosql databases have different basic types:

  1. Column based
  2. Key-value database
  3. Graph-based
  4. Document based database

What are the differences between these types and how to choose between them?

  • The question is very wide. Each one has its particularities as well as relational Bds. Including whether or not to use Nosql BD. Be more specific in your question, expose a problem, that the community helps solve it.

1 answer

1

According to Han2014 models can be described as such:

Key-value: Means that each value has a corresponding key. This model supports highly concurrent operations, horizontal scalability (Scale out) and queries. (In addition to map-reduce operations)

Dbs with this architecture: Redis, Tokyo-Cabinet and Flaris.

Collumn-oriented: Data is stored in columns, rather than rows, and data is stored separately for each column. Each column is treated as a different process. Ideal for distributed systems.

Dbs with this architecture: Facebook Cassandra, Hypertable

Document-based: It has a structure similar to Key-value, however each value has a semantic meaning stored in JSON or XML. Allows the generation of secondary indexes.

Dbs with this architecture: Mongodb and Counchedb.

Graph-based, according to my research, is considered another approach, used when other views of the data are needed. As Nosql works by aggregation it has a limited perspective.

Choosing one model or another depends on the characteristics of your work and only you can measure this by analyzing the pros and cons of each model. The article quoted at the beginning may be a good starting point for this.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.