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.
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.
But can we use commands?
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
[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!