Wide column store — NoSQL database

  • Compression: Efficient at data compression and data partitioning
  • Quick to load: They are very fast to load. A billion rows can be loaded in few seconds.
  • Aggregate queries: Due to their structure, column databases perform very good with aggregate queries i.e. sum, count, average
  • Scalability: Column databases are very scalable and are well suited to do massive parallel processing, which involves spreading data across many clusters
  • Updates can be inefficient
  • Perform poorly with joins making them unsuitable for Online Transaction Processing (OLTP)
  • Works well with OLAP(Online Analytical Processing)
  • Attribute based data such as equipment features
  • Internet of Things sensor data
  • Store data that gets logged in application



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


Master's student in Computer Science from University of Florida. I love to write and help others, so here am i.