Support Questions
Find answers, ask questions, and share your expertise

Apache Cassandra :Is a a key-value or a column-oriented (or tabular) database management system?

Expert Contributor

Can anyone clarify this :

Apache Cassandra is a key-value or a column-oriented (or tabular) database management system?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Apache Cassandra :Is a a key-value or a column-oriented (or tabular) database management system?

@Amit Dass

Both, Cassandra and HBase are columnar.

Key-Value stores store keys value pairs, generally in buckets, exactly like a hash table data structure. Example is Redis, Memcache, etc.

Column stores seem to store data in related rows, but they actually serialize the data into columns.

++++

If any response addressed your question, please vote and accept best answer.

View solution in original post

2 REPLIES 2

Re: Apache Cassandra :Is a a key-value or a column-oriented (or tabular) database management system?

Super Guru

@Amit Dass Yes it is a key value store similar to Apache HBase. Think of it as a map. To get a "column" you need to know how to find it. That is through the rowkey design. the rowkey+column name provide you the "Map" to the column of where it physically resides.

Re: Apache Cassandra :Is a a key-value or a column-oriented (or tabular) database management system?

@Amit Dass

Both, Cassandra and HBase are columnar.

Key-Value stores store keys value pairs, generally in buckets, exactly like a hash table data structure. Example is Redis, Memcache, etc.

Column stores seem to store data in related rows, but they actually serialize the data into columns.

++++

If any response addressed your question, please vote and accept best answer.

View solution in original post