Column Oriented Database: Implementation and Performance Analysis
International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
www.ijsr.net | Open Access | Fully Refereed | Peer Reviewed International Journal

ISSN: 2319-7064

Research Paper | Computer Science & Engineering | India | Volume 4 Issue 9, September 2015

Column Oriented Database: Implementation and Performance Analysis

Vibha Shukla, Dr. Rajdev Tiwari

The volume of data in an organization is growing rapidly. So does the number of users who need to access and analyze this data. IT systems are used more and more intensive, in order to answer more numerous and complex demands needed to make critical business decisions. Data analysis and business reporting need more and more resources. Therefore, better, faster and more effective alternatives have to be found. Column oriented database systems have an important demand in the past few years. These databases are more suitable for data warehousing system to get analysis done faster as data is stored in columnar form. This paper provides a brief review of several papers, articles to know about the background of column oriented database. In this paper, we study the method for implementing column-store on top of Row-store in PostgreSql along with successful design and implementation. Performance results of Column-Store are presented, and compared with that of Row-store results with the help of TPC-H benchmark.

Keywords: Column-oriented database, data warehouse, row-oriented database

Edition: Volume 4 Issue 9, September 2015

Pages: 1621 - 1623

Share this Article

How to Cite this Article?

Vibha Shukla, Dr. Rajdev Tiwari, "Column Oriented Database: Implementation and Performance Analysis", International Journal of Science and Research (IJSR), https://www.ijsr.net/search_index_results_paperid.php?id=21091507, Volume 4 Issue 9, September 2015, 1621 - 1623

77 PDF Views | 51 PDF Downloads

Download Article PDF



Similar Articles with Keyword 'data warehouse'

Survey Paper, Computer Science & Engineering, India, Volume 3 Issue 6, June 2014

Pages: 1789 - 1791

The Survey Paper on Importance of Integration of Knowledge Management and Business Intelligence

Vina Lomte, Saloni Shah

Share this Article

Research Paper, Computer Science & Engineering, India, Volume 4 Issue 9, September 2015

Pages: 1621 - 1623

Column Oriented Database: Implementation and Performance Analysis

Vibha Shukla, Dr. Rajdev Tiwari

Share this Article

Comparative Studies, Computer Science & Engineering, India, Volume 4 Issue 3, March 2015

Pages: 1664 - 1667

Over View of Past Literature and Making Comparative Analysis Along with Our Strategy of Materialized View Selection

Sapna Choudhary, Roshna Mahajan

Share this Article

Research Paper, Computer Science & Engineering, India, Volume 4 Issue 11, November 2015

Pages: 1598 - 1606

A Design and Implementation of Efficient Algorithm for Materialized View Selection with its Preservation in a Data Warehouse Environment

Sapna Choudhary, Roshna Mahajan

Share this Article

Review Papers, Computer Science & Engineering, India, Volume 3 Issue 8, August 2014

Pages: 1342 - 1345

Survey on Big Data-Next frontier for Innovation

Anupriya

Share this Article
Top