Columnar Data Format
Column-oriented databases, such as NoSQL, represent all data via a “thing’s” attribute, i.e. the age of a person, stored in a column-based table. A column-oriented database stores a particular column on disk in such a way that all values of the column are adjacent to each other. Column-oriented databases are great for aggregating large amounts of data or if you have queries that require only a few fields from a wide table, but do not work well against “SELECT * FROM…” queries. Columnar data formats are best-suited for analytical workloads (OLAP).