Column-oriented database systems: A comparison study

Arjun G. Roy, Mohammad K. Hossain, Arijit Chatterjee, William Perrizo

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Scopus citations

Abstract

Over the years, there has been a slow but increasing focus on the column-oriented database management systems (DBMSs). Column-oriented DBMSs are different from the traditional ones in the way data is stored and accessed. Traditional ones store data row-wise while the column-oriented ones store the data column-wise. This allows column-oriented DBMSs to have extensive usage in various data warehouse applications because of their better performance in terms of read I/O in comparison to the conventional DBMSs. This is primarily due to the fact that column-oriented DBMSs only retrieve the columns defined in the query rather than the entire row in case of traditional DBMSs. In this paper, we study some of the existing and latest open-source column-oriented database management systems. Our approach is to highlight the salient features unique to the system. We also compare the DBMSs on the basis of some integral database features such as indexing, compression, transaction handling, etc. In addition, we give a concise but comprehensive summary of the commerical DBMSs using column-oriented architecture.

Original languageEnglish (US)
Title of host publicationProceedings of the ISCA 27th International Conference on Computers and Their Applications, CATA 2012
Pages264-269
Number of pages6
StatePublished - Dec 1 2012
Externally publishedYes
Event27th International Conference on Computers and Their Applications, CATA 2012 - Las Vegas, NV, United States
Duration: Mar 12 2012Mar 14 2012

Publication series

NameProceedings of the ISCA 27th International Conference on Computers and Their Applications, CATA 2012

Conference

Conference27th International Conference on Computers and Their Applications, CATA 2012
Country/TerritoryUnited States
CityLas Vegas, NV
Period3/12/123/14/12

Fingerprint

Dive into the research topics of 'Column-oriented database systems: A comparison study'. Together they form a unique fingerprint.

Cite this