Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, September 18, 2013    Justin Swanhart

You may have heard that there are performance benefits to using a column store instead of a row store. Column stores have become popular in closed source databases but they have recently become available in open source projects as well.

This talk will introduce the concept of column stores and contrast them with traditional row stores. It will then introduce a set of open source column store databases. The available features of each of the databases will be compared and contrasted. Finally the performance of loading a star schema and executing some mildly complex queries will be compared for each database, and the results will be compared with XtraDB, a row store.

The following open source products will be demonstrated and compared:

  • Infobright Community Edition (A MySQL column store)
  • LucidDB
  • MonetDB
  • XtraDB (A MySQL row store)

About the Author

Justin Swanhart

Justin is a Principal Support Engineer on the support team. In the past, he was a trainer at Percona and a consultant. Justin also created and maintains Shard-Query, a middleware tool for sharding and parallel query execution and Flexviews, a tool for materialized views for MySQL. Prior to working at Percona Justin consulted for Proven Scaling, was a backend engineer at Yahoo! and a database administrator at Smule and Gazillion games.