Aditi D. Andurkar, College of Engineering Pune, India

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.

DBMS, Column-store, Row-store, PostgreSql, index, benchmark, predicate, metadata, tuple construction