The Database Architecture Jigsaw Puzzle

textabstractEach DBMS represents a solution in a design space covering hundreds of parameters. The sheer size of this space leaves large parts unexplored, but also requires courage. The open-source MonetDB system is used to exemplify the pitfalls and opportunities of such an exploration into the realm of column-stores. We illustrate the vistas of high-risk projects based on radical changes in the design parameters, e.g., database cracking for self-organization, informative query summaries and database storage rings where the database is on the move. The missing jigsaw pieces identified are important for real innovations and provide an inspiration for changing the legacy architecture embodied in (relational) database products