Operational AI WIKI

All 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

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).

Related Terms

WIKI Contribution

  • Have a new word to add?
  • Have an updated definition?
Become a contributor