What is the difference between NOSQL and the column-oriented database?

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.

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.

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 642 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.