Finding the best between the column store and row store Databases

Abstract

Row store databases are unavoidable to manage data in Information Systems. However, Web growth and consumer high-connectivity generate incredible amount of data and change ways to manage it. In a matter of fact, traditional Row Stores hardly satisfy new application needs they are faced with, especially for OLAP data processing and BI. Column Stores became to be an answer to this problematic but in a restricted area of features. In this perspective, we propose a deep study that compares column stores and row stores databases to get an answer of the real impact of the physical design of column stores and row stores on the queries response, on small or big volume of data by using the TPCH benchmark in a unique centralized environment.