Call for Paper - January 2023 Edition
IJCA solicits original research papers for the January 2023 Edition. Last date of manuscript submission is December 20, 2022. Read More

Performance Analysis of Column Oriented Database Vs Row Oriented Database

Print
PDF
International Journal of Computer Applications
© 2012 by IJCA Journal
Volume 50 - Number 14
Year of Publication: 2012
Authors:
Amit Kumar Dwivedi
C. S. Lamba
Shweta Shukla
10.5120/7841-1050

Amit Kumar Dwivedi, C S Lamba and Shweta Shukla. Article: Performance Analysis of Column Oriented Database Vs Row Oriented Database. International Journal of Computer Applications 50(14):31-34, July 2012. Full text available. BibTeX

@article{key:article,
	author = {Amit Kumar Dwivedi and C. S. Lamba and Shweta Shukla},
	title = {Article: Performance Analysis of Column Oriented Database Vs Row Oriented Database},
	journal = {International Journal of Computer Applications},
	year = {2012},
	volume = {50},
	number = {14},
	pages = {31-34},
	month = {July},
	note = {Full text available}
}

Abstract

There are two obvious methods to map a two-dimension relational database table onto a one-dimensional storage interface: store the table row-by-row, or store the table column-by-column. Traditionally, database system implementations and research have focused on the row-by row data layout, since it performs best on the most common application for database systems: business transactional data processing. However, there are a set of emerging applications for database systems for which the row-by-row layout performs poorly. These applications are more analytical in nature, whose goal is to read through the data to gain new insight and use it to drive decision making and planning. In this paper, we study the poor performance of row-by-row data layout for these emerging applications, and evaluate the column-by-column data layout opportunity as a solution to this problem. The solution will be analyzed and represented by graph. At the end of the paper we will see the comparative performance of Oracle 10g and MSSQLServer database.

References

  • Daniel J. Abadi. , In CIDR, Asilomar, CA, USA, 2007 Column stores for wide and sparse data.
  • S. Khosha_an, G. Copeland, T. Jagodis, H. Boral, and P. Valduriez. In ICDE, pages 636-643,1987, A query processing strategy for the decomposed storage model.
  • D. J. Abadi, S. R. Madden, and M. C. Ferreira. In SIGMOD, pages 671-682, 2006, Integrating Compression and Execution in Column-Oriented Database Systems.
  • P. Boncz, M. Zukowski, and N. Nes. MonetDB/X100:, In CIDR, 2005, Hyper-pipelining query execution.
  • P. A. Boncz and M. L. Kersten. MIL primitives for querying a fragmented world.
  • A. Ailamaki, D. J. DeWitt, M. D. Hill, and M. Skounakis, pages 169-180, 2001,Weaving relations for cache performance. In VLDB.
  • D. J. Abadi, D. S. Myers, D. J. DeWitt, and S. R. Madden, In ICDE, 2007,Materialization strategies in a column-oriented dbms.