Let’s talk about Database Paradigms, Wide Column Model

In short, a wide column model is a type of NoSQL Database. It uses tables, rows, and even columns! (Quite the upgrade since the key-value model)

But wait… we can interpret the wide-column store as a two-dimensional key-value store.

The two major players in this category are firstly Apache Cassandra and Apache Hbase, I said earlier that they have columns and rows but they are not in the original sense.

In the original columnar data model, each column is stored separately on the disk.

Wide-column stores usually support the notion of column families where data is stored in a row-by-row fashion, such as the columns were together.

Well, I am glad you asked!
Yes, we can, it does not have a schema and we can use a language called CQL (no, it is not a typo from SQL), and here is an example of CQL syntax:

SELECT * | select_expression
FROM [keyspace_name.] table_name
[WHERE partition_value]
[AND clustering_filters]
[ORDER BY PK_column_name ASC|DESC]

An upside of this paradigm is that it can be easily scaled up and it is used mostly in scaling time-series data, historical records etc.

This should round up the second article in this series, stay tuned for the Document Paradigm!



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Coman Cosmin

I convert real world problem into technical solutions. I do research and make robots.