Implementation of Column-Oriented Database in POSTGRESQL for Optimization of Read-Only Queries
Aditi D. Andurkar · 2012
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 rowstore in PostgreSql along with successful design and implementation of the same.