Implementation of Column-Oriented Database in POSTGRESQL for Optimization of Read-Only Queries

摘要

The era of column-oriented database systems has truly begun with open source database systems like C-Store, MonetDb, LucidDb and commercial ones like Vertica. Column-oriented database stores data column-by-column which means it stores information of single attribute collectively. The need for Column-oriented database arose from the need of business intelligence for efficient decision making where traditional row-oriented database gives poor performance. PostgreSql is an open source row-oriented and most widely used relational database management system which does not have facility for storing data in column-oriented fashion. In our work we propose the best method for implementing column-store on top of row-store in PostgreSql along with successful design and implementation of the same.