What is the difference between NoSQL (such as CouchDB, Cassandra, MongoDB) and column-oriented databases (such as Vertica, MonetDB)?
For example, Vertica is a column-oriented relational database, so it will not actually be considered a NoSQL data store.
“NoSQL movement” data storage is better defined as a non-relational, shared-free, horizontally scalable database without (ACID) guarantees. Some column-oriented databases can be characterized in this way. In addition to column storage, NoSQL implementations also include document storage, object storage, tuple storage, and graph storage.
The more you read about NoSQL, it starts to sound like a column-oriented database.
What is the difference between NoSQL (such as CouchDB, Cassandra, MongoDB) and column-oriented databases (such as Vertica, MonetDB)?
Some NoSQL databases are column-oriented databases, and some SQL databases are also column-oriented. Whether the database is column-oriented or row-oriented is the implementation detail of the physical storage of the database, and is true for both relational and non-relational databases.
For example, Vertica is a column-oriented relational database, so it will not actually be considered a NoSQL data store.
“NoSQL movement” data storage is better defined as a non-relational, shared-free, horizontally scalable database without (ACID) guarantees. Some column-oriented databases can be characterized in this way. In addition to column storage, NoSQL implementations also include document storage, object storage, tuple storage, and graph storage.