<?xml version="1.0" encoding="ISO-8859-1"?><article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<front>
<journal-meta>
<journal-id>1390-860X</journal-id>
<journal-title><![CDATA[Ingenius. Revista de Ciencia y Tecnología ]]></journal-title>
<abbrev-journal-title><![CDATA[Ingenius]]></abbrev-journal-title>
<issn>1390-860X</issn>
<publisher>
<publisher-name><![CDATA[Universidad Politécnica Salesiana]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S1390-860X2019000200047</article-id>
<title-group>
<article-title xml:lang="es"><![CDATA[Rendimiento de bases de datos columnares]]></article-title>
<article-title xml:lang="en"><![CDATA[Performance of columnar database]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Durán-Cazar]]></surname>
<given-names><![CDATA[Jhonatan W.]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Tandazo-Gaona]]></surname>
<given-names><![CDATA[Eduardo J.]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Morales-Morales]]></surname>
<given-names><![CDATA[Mario R.]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Morales Cardoso]]></surname>
<given-names><![CDATA[Santiago]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Universidad Central del Ecuador  ]]></institution>
<addr-line><![CDATA[ ]]></addr-line>
<country>Ecuador</country>
</aff>
<aff id="Af2">
<institution><![CDATA[,Universidad Central del Ecuador  ]]></institution>
<addr-line><![CDATA[ ]]></addr-line>
<country>Ecuador</country>
</aff>
<aff id="Af3">
<institution><![CDATA[,Universidad Central del Ecuador  ]]></institution>
<addr-line><![CDATA[ ]]></addr-line>
<country>Ecuador</country>
</aff>
<aff id="Af4">
<institution><![CDATA[,Universidad Central del Ecuador  ]]></institution>
<addr-line><![CDATA[ ]]></addr-line>
<country>Ecuador</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>12</month>
<year>2019</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>12</month>
<year>2019</year>
</pub-date>
<numero>22</numero>
<fpage>47</fpage>
<lpage>58</lpage>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://scielo.senescyt.gob.ec/scielo.php?script=sci_arttext&amp;pid=S1390-860X2019000200047&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://scielo.senescyt.gob.ec/scielo.php?script=sci_abstract&amp;pid=S1390-860X2019000200047&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://scielo.senescyt.gob.ec/scielo.php?script=sci_pdf&amp;pid=S1390-860X2019000200047&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="es"><p><![CDATA[Resumen En la actualidad para el éxito de las empresas es decisiva la capacidad de procesar de manera eficiente una considerable cantidad de datos de una amplia gama de fuentes en cualquier lugar y momento. El análisis de datos se convierte en una estrategia clave para la mayoría de las grandes organizaciones para lograr una ventaja competitiva. Por tanto, surgen nuevas cuestiones a ser tomadas en cuenta a la hora de almacenar y consultar cantidades masivas de datos que, en general, las bases de datos relacionales tradicionales no pueden abarcar. Estas cuestiones incluyen desde la capacidad de distribuir y escalar el procesamiento o el almacenamiento físico, hasta la posibilidad de utilizar esquemas o tipos de datos no usuales. El objetivo principal de la investigación es evaluar el rendimiento de las bases de datos columnares en analítica de datos. Efectuar una comparación con bases de datos de tipo relacional, para determinar su eficiencia, realizando mediciones en distintos escenarios de pruebas. El presente estudio pretende proporcionar (evidencia científica) un instrumento que facilite a los profesionales interesados en la analítica de datos una base para sus conocimientos, al incluir cuadros y tablas comparativos con datos cuantitativos con los que se pueda sustentar las conclusiones de esta investigación. Se usa una metodología aplicada y de diseño descriptivo cuantitativo-comparativo al ser el que mejor se ajusta al estudio de características de eficiencia de bases de datos. En la medición se usa el método de promedios para n número de tomas y se soporta en la herramienta Aqua Data Studio que garantiza una alta confiabilidad al ser un programa especializado para la administración de bases de datos. Finalmente, se ha logrado determinar que las bases columnares tienen un mejor rendimiento en ambientes de análisis de datos.]]></p></abstract>
<abstract abstract-type="short" xml:lang="en"><p><![CDATA[Abstract Companies&#8217; 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.]]></p></abstract>
<kwd-group>
<kwd lng="es"><![CDATA[análisis de datos]]></kwd>
<kwd lng="es"><![CDATA[base de datos columnar]]></kwd>
<kwd lng="es"><![CDATA[en memoria]]></kwd>
<kwd lng="es"><![CDATA[NoSQL]]></kwd>
<kwd lng="es"><![CDATA[rendimiento]]></kwd>
<kwd lng="en"><![CDATA[data analytics]]></kwd>
<kwd lng="en"><![CDATA[columnar database]]></kwd>
<kwd lng="en"><![CDATA[in memory]]></kwd>
<kwd lng="en"><![CDATA[NoSQL]]></kwd>
<kwd lng="en"><![CDATA[performance]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[NOSQL database: New era of databases for big data analytics - classification, characteristics and comparison]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Moniruzzaman]]></surname>
<given-names><![CDATA[B. M.]]></given-names>
</name>
<name>
<surname><![CDATA[Hossain]]></surname>
<given-names><![CDATA[S. A.]]></given-names>
</name>
</person-group>
<source><![CDATA[International Journal of Database Theory and Application]]></source>
<year>2013</year>
<volume>6</volume>
<numero>4</numero>
<issue>4</issue>
<page-range>1-5</page-range></nlm-citation>
</ref>
<ref id="B2">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Rendimiento de tecnologías nosql sobre cantidades masivas de datos]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Pollo Cattaneo]]></surname>
<given-names><![CDATA[M. F.]]></given-names>
</name>
<name>
<surname><![CDATA[López Nocera]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Daián Rottoli]]></surname>
<given-names><![CDATA[G.]]></given-names>
</name>
</person-group>
<source><![CDATA[Cuaderno Activa]]></source>
<year>2014</year>
<numero>6</numero>
<issue>6</issue>
<page-range>11-7</page-range></nlm-citation>
</ref>
<ref id="B3">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Characteristics of in-memory business intelligence]]></article-title>
<collab>I. Mihaela-Laura</collab>
<source><![CDATA[Informatica Economica]]></source>
<year>2014</year>
<volume>18</volume>
<numero>3</numero>
<issue>3</issue>
<page-range>17-25</page-range></nlm-citation>
</ref>
<ref id="B4">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[¿Qué características tienen los esquemas NoSQL?]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Robles]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
<name>
<surname><![CDATA[Sánchez]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Serrano]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
<name>
<surname><![CDATA[Adárraga]]></surname>
<given-names><![CDATA[B.]]></given-names>
</name>
<name>
<surname><![CDATA[Heredia]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
</person-group>
<source><![CDATA[Investigación y desarrollo en TIC]]></source>
<year>2015</year>
<volume>6</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>40-4</page-range></nlm-citation>
</ref>
<ref id="B5">
<nlm-citation citation-type="">
<article-title xml:lang=""><![CDATA[Bases de datos]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Marqués]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
</person-group>
<source><![CDATA[Universitat Jaume]]></source>
<year>2011</year>
</nlm-citation>
</ref>
<ref id="B6">
<nlm-citation citation-type="">
<article-title xml:lang=""><![CDATA[Fundamentals of Database Systems]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ramez]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
<name>
<surname><![CDATA[Shamkant]]></surname>
<given-names><![CDATA[B. N.]]></given-names>
</name>
</person-group>
<source><![CDATA[Pearson Education]]></source>
<year>2015</year>
</nlm-citation>
</ref>
<ref id="B7">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[A perspective on applications of in-memory analytics in supply chain management]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Hahn]]></surname>
<given-names><![CDATA[G.]]></given-names>
</name>
<name>
<surname><![CDATA[Packowski]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
</person-group>
<source><![CDATA[Decision Support Systems]]></source>
<year>2015</year>
<volume>76</volume>
<page-range>45-52</page-range></nlm-citation>
</ref>
<ref id="B8">
<nlm-citation citation-type="">
<article-title xml:lang=""><![CDATA[The In-Memory Revolution]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Plattner]]></surname>
<given-names><![CDATA[H.]]></given-names>
</name>
<name>
<surname><![CDATA[Leukert]]></surname>
<given-names><![CDATA[B.]]></given-names>
</name>
</person-group>
<source><![CDATA[Springer]]></source>
<year>2015</year>
</nlm-citation>
</ref>
<ref id="B9">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Inteligencia de negocios basada en bases de datos in-memory]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Morales Morales]]></surname>
<given-names><![CDATA[M. R.]]></given-names>
</name>
<name>
<surname><![CDATA[Morales Cardoso]]></surname>
<given-names><![CDATA[S. L.]]></given-names>
</name>
</person-group>
<source><![CDATA[Revista Publicando]]></source>
<year>2017</year>
<volume>11</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>201-17</page-range></nlm-citation>
</ref>
<ref id="B10">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[In-memory databases and innovations in Business Intelligence]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Babeanu]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
<name>
<surname><![CDATA[Ciobanu]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
</person-group>
<source><![CDATA[Database Systems Journal]]></source>
<year>2015</year>
<volume>6</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>59-67</page-range></nlm-citation>
</ref>
<ref id="B11">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Comparative study of sql and nosql databases to evaluate their suitability for big data application]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Shetty]]></surname>
<given-names><![CDATA[V. D.]]></given-names>
</name>
<name>
<surname><![CDATA[Chidimar]]></surname>
<given-names><![CDATA[S. J.]]></given-names>
</name>
</person-group>
<source><![CDATA[International Journal of Computer Science and Information Technology Research]]></source>
<year>2016</year>
<volume>4</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>314-8</page-range></nlm-citation>
</ref>
<ref id="B12">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[A performance evaluation of in-memory databases]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kabakus]]></surname>
<given-names><![CDATA[A. T.]]></given-names>
</name>
<name>
<surname><![CDATA[Kara]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Journal of King Saud University &#8211; Computer and Information Sciences]]></source>
<year>2017</year>
<volume>29</volume>
<numero>4</numero>
<issue>4</issue>
<page-range>520-5</page-range></nlm-citation>
</ref>
<ref id="B13">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Testing of transactional services in nosql key-value databases]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[González-Aparicio]]></surname>
<given-names><![CDATA[M. T.]]></given-names>
</name>
<name>
<surname><![CDATA[Younas]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Tuya]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[Casado]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Future Generation Computer Systems]]></source>
<year>2018</year>
<volume>80</volume>
<page-range>384-99</page-range></nlm-citation>
</ref>
<ref id="B14">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Type of nosql databases and its comparison with relational databases]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Nayak]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
<name>
<surname><![CDATA[Poriya]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
<name>
<surname><![CDATA[Poojary]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
</person-group>
<source><![CDATA[International Journal of Applied Information Systems (IJAIS)]]></source>
<year>2013</year>
<volume>5</volume>
<numero>4</numero>
<issue>4</issue>
<page-range>16-9</page-range></nlm-citation>
</ref>
<ref id="B15">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Report to brewer&#8217;s original presentation of his cap theorem at the symposium on principles of distributed computing (podc) 2000]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Simon]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
</person-group>
<source><![CDATA[University of Basel, HS2012]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B16">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Cap twelve years later: How the "rules" have changed]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Brewer]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
</person-group>
<source><![CDATA[Computer]]></source>
<year>2012</year>
<volume>45</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>23-9</page-range></nlm-citation>
</ref>
<ref id="B17">
<nlm-citation citation-type="confpro">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Indrawan-Santiago]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
</person-group>
<source><![CDATA[15th International Conference on Network-Based Information Systems]]></source>
<year>2012</year>
<conf-name><![CDATA[ &#8220;Database research: Are we at a crossroad? reflection on nosql]]></conf-name>
<conf-loc> </conf-loc>
<page-range>45-51</page-range></nlm-citation>
</ref>
<ref id="B18">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Nosql: clasificación de las bases de datos según el teorema cap]]></article-title>
<collab>GENBETA</collab>
<source><![CDATA[GENBETA]]></source>
<year>2019</year>
</nlm-citation>
</ref>
<ref id="B19">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Evaluation criteria for selecting nosql databases in a single-box environment]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Engle]]></surname>
<given-names><![CDATA[R. D. L.]]></given-names>
</name>
<name>
<surname><![CDATA[Langhals]]></surname>
<given-names><![CDATA[B. T.]]></given-names>
</name>
<name>
<surname><![CDATA[Grimaila]]></surname>
<given-names><![CDATA[M. R.]]></given-names>
</name>
<name>
<surname><![CDATA[Hodson]]></surname>
<given-names><![CDATA[D. D.]]></given-names>
</name>
</person-group>
<source><![CDATA[International Journal of Database Management Systems (IJDMS )]]></source>
<year>2018</year>
<volume>10</volume>
<numero>4</numero>
<issue>4</issue>
<page-range>1-12</page-range></nlm-citation>
</ref>
<ref id="B20">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Best relational databases software]]></article-title>
<collab>Crowd</collab>
<source><![CDATA[Crowd. Inc]]></source>
<year>2019</year>
</nlm-citation>
</ref>
<ref id="B21">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Db-engines ranking of wide column stores]]></article-title>
<collab>DB-Engines</collab>
<source><![CDATA[DB-Engines]]></source>
<year>2019</year>
</nlm-citation>
</ref>
<ref id="B22">
<nlm-citation citation-type="journal">
<article-title xml:lang=""><![CDATA[Corporación favorita grocery sales forecasting.]]></article-title>
<collab>Kaggle</collab>
<source><![CDATA[Kaggle]]></source>
<year>2019</year>
</nlm-citation>
</ref>
<ref id="B23">
<nlm-citation citation-type="">
<article-title xml:lang=""><![CDATA[Estudio del rendimiento de una base de datos columnar en el análisis de datos]]></article-title>
<person-group person-group-type="author">
<name>
<surname><![CDATA[Durán Cazar]]></surname>
<given-names><![CDATA[J. W.]]></given-names>
</name>
<name>
<surname><![CDATA[Tandazo Gaona]]></surname>
<given-names><![CDATA[E. J.]]></given-names>
</name>
<name>
<surname><![CDATA[Morales Morales]]></surname>
<given-names><![CDATA[M. R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Universidad Central del Ecuador]]></source>
<year>2018</year>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
