Performance of Columnar Database Rendimiento de bases de datos columnares

Abstract

Companies’ capacity to efficiently process a great amount of data from a great variety of sources any-where and anytime is essential for them to suc-ceed. Data analysis becomes a key strategy for most large organizations to get a competitive advantage. Hence, new issues should be considered when massive amounts of date are to be stored, because traditional relational database are not capable to lodge them. Such questions include aspects that range from the capacity to distribute and escalate the physical stor-age, to the possibility of using schemes or non-usual types of data. The main objective of this research is to evaluate the performance of the columnar databases in data analysis., comparing them with relational databases, to determine their efficiency using mea-surements in different test scenarios. The present study seeks to provide (scientific evidence) profession-als interested in data analysis with a basic instrument for their knowledge, to include comparative tables with quantitative data that can support the conclu-sions of this research. A methodology of applied type and quantitative-comparative descriptive design is used, as it is the one of the most appropriate to study database efficiency characteristics. In the measure-ment, the method of averages is used for a number n of records, and it is supported in the Aqua Data Studio tool that guarantees a high reliability, as a spe-cialized software for the administration of databases. Finally, it has been determined that the columnar databases have a better performance in data analysis environments.