New blog post

[Christoph Rupp]

Read a new blog post on upscaledb.com:

Building an embedded column store database with upscaledb - part 1

This post is the first in a longer series of posts describing how to implement SQL-ish scenarios in a key/value store. In the first article I'll explain the basics, then will continue to describe OLAP vs OLTP and how embedded databases (specifically upscaledb) can be optimized for both usages. The third post will show simple recipes for translating SQL databases to upscaledb and for running simple queries. Afterwards I will go in depth and describe analytical operations on complex real-live data.

Read more at http://upscaledb.com/0005-building-an-embedded-column-store-database-part1.html

[Christoph Rupp]

Part 2 is now available:

Building an embedded column store database with upscaledb - part 2

In the first part of this series I have described the ideas behind "row oriented" and "column oriented" databases. This part will delve even deeper.

Read more at http://upscaledb.com/0006-building-an-embedded-column-store-database-part2.html