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.

Provided by: Academy & Industry Research Collaboration Center Topic: Data Management Date Added: Jul 2012 Format: PDF

Download Now

Find By Topic