What is a Wide Column Database?

By on

Wide Column DatabaseWide Column Databases, or Column Family Databases, refers to a category of NoSQL databases that works well for storing enormous amounts of data that can be collected. Its architecture uses persistent, sparse matrix, multi-dimensional mapping (row-value, column-value, and timestamp) in a tabular format meant for massive scalability (over and above the petabyte scale). Column Family stores do not follow the relational model, and they aren’t optimized for joins.

Good Wide Column Database use cases include:

  • Sensor Logs  [Internet of Things (IOT)]
  • User preferences
  • Geographic information
  • Reporting systems
  • Time Series Data
  • Logging and other write heavy applications

Wide Column Databases are not the preferred choice for applications with ad-hoc query patterns, high level aggregations and changing database requirements. This type of data store does not keep good data lineage.

Other Definitions of Wide Column Databases Include:

  • “A multidimensional nested sorted map of maps, where data is stored in cells of columns and grouped into column families.” (Akshay Pore, DATAVERSITY®)
  • “Scalability and high availability without compromising performance.” (Apache)
  • Database management systems that organize related facts into columns. (Meta S Brown, Forbes)
  • “Databases [that] are similar to key-value but allow a very large number of columns. They are well suited for analyzing huge data sets, and Cassandra is the best known.” (Rick Murphy, IBM)
  • A store that groups data into columns and allowing for an infinite number of them. (Mike Bonatsos, Temple University)
  • A store with data as rows and columns, like a RDBMS, but able to handle more ambiguous and complex data types, including unformatted text and imagery. (Michelle Knight, DATAVERSITY®)

Image credit: Akshay Pore

Businesses Use Wide Column Databases to Handle:

  • High volume of data
  • Extreme write speeds with relatively less velocity reads
  • Data extraction by columns using row keys

Photo Credit: Oleksiy Mark/Shutterstock.com

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept