Jun 13, 2016

If you're interested in reading more about the general design of column stores, I can recommend [0] as a great place to start. It also compares design decisions made in MonetDB to other column stores.

If you want to look at simple code after the reading, I'm slowly implementing a naive column store over at [1] in golang. The overall structure isn't flexible but the individual columns are quite portable. It has a number of tests and benchmarks using a few months of MTG price data I had sitting around.

[0] http://db.csail.mit.edu/pubs/abadi-column-stores.pdf

[1] https://github.com/Everlag/naive-columstore

May 23, 2016

For anyone looking for info about column oriented DBs, I can recommend [0] as a great place to start. It covers the basic optimizations and compares some older solutions at a fairly high level.

[0]http://db.csail.mit.edu/pubs/abadi-column-stores.pdf