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
SAKSHI CHHABRA

SAKSHI CHHABRA

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