SciELO - Scientific Electronic Library Online

 issue22Detección de fallas en motores de combustión mediante indicadores de temperatura y presión de inyecciónEvaluación de la gestión del mantenimiento en hospitales del instituto ecuatoriano de seguridad social de la zona 3 del Ecuador author indexsubject indexarticles search
Home Pagealphabetic serial listing  

Services on Demand




Related links

  • Have no similar articlesSimilars in SciELO


Ingenius. Revista de Ciencia y Tecnología

On-line version ISSN 1390-860XPrint version ISSN 1390-650X


DURAN-CAZAR, Jhonatan W.; TANDAZO-GAONA, Eduardo J.; MORALES-MORALES, Mario R.  and  MORALES CARDOSO, Santiago. Performance of columnar database. Ingenius [online]. 2019, n.22, pp.47-58. ISSN 1390-860X.

Companies’ capacity to efficiently process a great amount of data from a great variety of sources anywhere and anytime is essential for them to succeed. Data analysis becomes a key strategy for most of large organizations for them to get a competitive advantage. Hence, when massive amounts of date are to be stored, new questionings arise for consideration, because traditional relational database are not capable to lodge them. Such questions include aspects that go from the capacity to distribute and escalate the physical storage to the possibility of using schemes or non-usual types of data. The main objective of the research is to evaluate the performance of the columnar databases in data analytics. Make a comparison with relational databases, to determine their efficiency, making measurements in different test scenarios. The present study aims to provide (scientific evidence) an instrument that provides professionals interested in data analytics with a base for their knowledge, to include comparative tables with quantitative data that can support the conclusions of this research. A methodology of applied type and quantitative-comparative descriptive design is used, as it is the one that best adjusts to the study of database efficiency characteristics. In the measurement the averages method is used for n number of shots and it is supported in the Aqua Data Studio tool that guarantees a high reliability as it is a specialized software for the administration of databases. Finally, it has been determined that the columnar bases have a better performance in data analysis environments.

Keywords : data analytics; columnar database; in memory; NoSQL; performance.

        · abstract in Spanish     · text in Spanish     · Spanish ( pdf )