<?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>0121-1129</journal-id>
<journal-title><![CDATA[Revista Facultad de Ingeniería]]></journal-title>
<abbrev-journal-title><![CDATA[Rev. Fac. ing.]]></abbrev-journal-title>
<issn>0121-1129</issn>
<publisher>
<publisher-name><![CDATA[Universidad Pedagógica y Tecnológica de Colombia]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S0121-11292022000400208</article-id>
<article-id pub-id-type="doi">10.19053/01211129.v31.n62.2022.15211</article-id>
<title-group>
<article-title xml:lang="en"><![CDATA[Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model]]></article-title>
<article-title xml:lang="es"><![CDATA[Bodega de datos adaptable con base en el factor de investigación del modelo de acreditación institucional del CNA]]></article-title>
<article-title xml:lang="pt"><![CDATA[Data warehouse adaptável com base no fator de pesquisa do modelo de acreditação institucional CAN]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Fuentes-Vargas]]></surname>
<given-names><![CDATA[David-Antonio]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Mendoza-Becerra]]></surname>
<given-names><![CDATA[Martha-Eliana]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Gómez-Flórez]]></surname>
<given-names><![CDATA[Luis-Carlos]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Universidad Industrial de Santander  ]]></institution>
<addr-line><![CDATA[Bucaramanga Santander]]></addr-line>
<country>Colombia</country>
</aff>
<aff id="Af2">
<institution><![CDATA[,Universidad del Cauca  ]]></institution>
<addr-line><![CDATA[Popayán Cauca]]></addr-line>
<country>Colombia</country>
</aff>
<aff id="Af3">
<institution><![CDATA[,Universidad Industrial de Santander  ]]></institution>
<addr-line><![CDATA[Bucaramanga Santander]]></addr-line>
<country>Colombia</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>12</month>
<year>2022</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>12</month>
<year>2022</year>
</pub-date>
<volume>31</volume>
<numero>62</numero>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://www.scielo.org.co/scielo.php?script=sci_arttext&amp;pid=S0121-11292022000400208&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.co/scielo.php?script=sci_abstract&amp;pid=S0121-11292022000400208&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.co/scielo.php?script=sci_pdf&amp;pid=S0121-11292022000400208&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="en"><p><![CDATA[Abstract One of the main challenges of higher education institutions is continuously improving educational quality. In Colombia, the National Accreditation Council is in charge of evaluating if an institution provides high-quality education. One of the stages in obtaining recognition of high quality requires submitting a self-assessment report with quantitative data by the institution. This stage is very demanding for the institutions because it requires handling data extracted from various sources. Data warehouses are an alternative solution since they allow information from various sources to be centralized and support decision-making. This article proposes dimensional models adaptable to the availability of information sources for institutions and focuses on investigative processes. The research methodology used is the Iterative Research Pattern, where the problem was observed through the review of related studies and self-assessment reports submitted to the National Accreditation Council by public institutions. Subsequently, the requirements of the model were created and validated by a group of experts in institutional quality accreditation. Then, the solution was developed, and six adaptable dimensional research models were proposed using the MiPymes methodology, which is validated through a focus group of experts in dimensional modeling of data warehouses that considered the degree of adaptability of the models is 100% to the identified requirements.]]></p></abstract>
<abstract abstract-type="short" xml:lang="es"><p><![CDATA[Resumen Uno de los principales desafíos de las instituciones de educación superior es mejorar continuamente la calidad educativa. En Colombia, el Consejo Nacional de Acreditación se encarga de evaluar si una institución está brindando educación de alta calidad. Una de las etapas para obtener el reconocimiento de alta calidad requiere la presentación de un informe de autoevaluación con datos cuantitativos por parte de la institución. Esta etapa es muy exigente para las instituciones porque require el manejo de datos extraídos de diversas fuentes. Las bodegas de datos son una solución alternativa ya que permiten centralizar información de diversas fuentes y apoyar la toma de decisiones. Este artículo propone modelos dimensionales adaptables a la disponibilidad de fuentes de información para las instituciones y se enfoca en los procesos investigativos. La metodología de investigación utilizada es el Patrón de Investigación Iterativa, donde se observó el problema a través de la revisión de estudios relacionados e informes de autoevaluación presentados al Consejo Nacional de Acreditación por instituciones públicas. Posteriormente, los requisitos del modelo fueron creados y validados por un grupo de expertos en acreditación de calidad institucional. Luego se desarrolló la solución y se propusieron seis modelos de investigación dimensional adaptables utilizando la metodología MiPymes, los cuales son validados a través de un grupo focal de expertos en modelado dimensional de bodegas de datos que consider que el grado de adaptabilidad de los modelos a los requerimientos es del 100%.]]></p></abstract>
<abstract abstract-type="short" xml:lang="pt"><p><![CDATA[Resumo Um dos principais desafios das instituições de ensino superior é melhorar continuamente a qualidade educacional. Na Colômbia, o Conselho Nacional de Acreditação é responsável por avaliar se uma instituição está oferecendo educação de alta qualidade. Uma das etapas para obter o reconhecimento de alta qualidade exige a apresentação de um relatório de autoavaliação com dados quantitativos por parte da instituição. Esta etapa é muito exigente para as instituições porque requer a gestão de dados extraídos de várias fontes. Os data warehouses são uma solução alternativa, pois permitem centralizar informações de diversas fontes e apoiar a tomada de decisão. Este artigo propõe modelos dimensionais adaptáveis &#8203;&#8203;à disponibilidade de fontes de informação para instituições e tem como foco processos investigativos. A metodologia de pesquisa utilizada é o Padrão de Pesquisa Iterativa, onde o problema foi observado por meio da revisão de estudos relacionados e relatórios de autoavaliação enviados ao Conselho Nacional de Acreditação por instituições públicas. Posteriormente, os requisitos do modelo foram elaborados e validados por um grupo de especialistas em acreditação de qualidade institucional. Em seguida, desenvolveu-se a solução e propuseram-se seis modelos dimensionais adaptáveis &#8203;&#8203;de pesquisa utilizando a metodologia MiPymes, os quais são validados através de um grupo focal de especialistas em modelagem dimensional de data warehouses que consideraram que o grau de adaptabilidade dos modelos aos requisitos é de 100%.]]></p></abstract>
<kwd-group>
<kwd lng="en"><![CDATA[data warehouses]]></kwd>
<kwd lng="en"><![CDATA[dimensional modeling]]></kwd>
<kwd lng="en"><![CDATA[higher education]]></kwd>
<kwd lng="en"><![CDATA[quality guidelines]]></kwd>
<kwd lng="en"><![CDATA[research]]></kwd>
<kwd lng="es"><![CDATA[bodegas de datos]]></kwd>
<kwd lng="es"><![CDATA[modelado dimensional]]></kwd>
<kwd lng="es"><![CDATA[educación superior]]></kwd>
<kwd lng="es"><![CDATA[lineamientos de calidad]]></kwd>
<kwd lng="es"><![CDATA[investigación]]></kwd>
<kwd lng="pt"><![CDATA[data warehouses]]></kwd>
<kwd lng="pt"><![CDATA[modelagem dimensional]]></kwd>
<kwd lng="pt"><![CDATA[educação superior]]></kwd>
<kwd lng="pt"><![CDATA[diretrizes de qualidade]]></kwd>
<kwd lng="pt"><![CDATA[pesquisa]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<label>[1]</label><nlm-citation citation-type="book">
<collab>CESU</collab>
<source><![CDATA[Acuerdo 03 de 2014]]></source>
<year>2014</year>
<page-range>32</page-range><publisher-loc><![CDATA[Colombia ]]></publisher-loc>
<publisher-name><![CDATA[Consejo Nacional de Acreditación (NAC)]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B2">
<label>[2]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Martínez]]></surname>
<given-names><![CDATA[J. E.]]></given-names>
</name>
<name>
<surname><![CDATA[Tobón]]></surname>
<given-names><![CDATA[S]]></given-names>
</name>
<name>
<surname><![CDATA[Romero]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Problemáticas relacionadas con la acreditación de la calidad de la educación superior en América Latina]]></article-title>
<source><![CDATA[Innovación Educativa]]></source>
<year>2017</year>
<volume>17</volume>
<numero>73</numero>
<issue>73</issue>
<page-range>79-96</page-range></nlm-citation>
</ref>
<ref id="B3">
<label>[3]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Peñafiel]]></surname>
<given-names><![CDATA[G. E. Silva]]></given-names>
</name>
<name>
<surname><![CDATA[Yánez]]></surname>
<given-names><![CDATA[V. M. Zapata]]></given-names>
</name>
<name>
<surname><![CDATA[Guamán]]></surname>
<given-names><![CDATA[K. P. Morales]]></given-names>
</name>
<name>
<surname><![CDATA[Padilla]]></surname>
<given-names><![CDATA[L. M. Toaquiza]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Análisis de metodologías para desarrollar Data Warehouse aplicado a la toma de decisiones]]></article-title>
<source><![CDATA[Ciencia Digital]]></source>
<year>2019</year>
<volume>3</volume>
<numero>3.4</numero>
<issue>3.4</issue>
<page-range>397-418</page-range></nlm-citation>
</ref>
<ref id="B4">
<label>[4]</label><nlm-citation citation-type="">
<collab>IBM</collab>
<source><![CDATA[Engineering Lifecycle Management - Data Warehouse]]></source>
<year>2022</year>
</nlm-citation>
</ref>
<ref id="B5">
<label>[5]</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kimball]]></surname>
<given-names><![CDATA[R]]></given-names>
</name>
<name>
<surname><![CDATA[Ross]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
</person-group>
<source><![CDATA[The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling]]></source>
<year>2013</year>
<edition>3</edition>
<publisher-name><![CDATA[John Wiley &amp; Sons, Inc]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B6">
<label>[6]</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Camilo]]></surname>
<given-names><![CDATA[W]]></given-names>
</name>
<name>
<surname><![CDATA[Mera]]></surname>
<given-names><![CDATA[L]]></given-names>
</name>
</person-group>
<source><![CDATA[Modelo Dimensional para Proyectos y Grupos de Investigación de la VRI de la Universidad del Cauca]]></source>
<year>2022</year>
<publisher-name><![CDATA[Universidad del Cauca]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B7">
<label>[7]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Miranda]]></surname>
<given-names><![CDATA[E. K. A.]]></given-names>
</name>
<name>
<surname><![CDATA[Suryani]]></surname>
<given-names><![CDATA[E. L. I.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Implementation of Data Warehouse, Data Mining and Dashboard for Higher Education]]></article-title>
<source><![CDATA[Journal of Theoretical and Applied Information Technology]]></source>
<year>2014</year>
<volume>64</volume>
<numero>3</numero>
<issue>3</issue>
<page-range>710-7</page-range></nlm-citation>
</ref>
<ref id="B8">
<label>[8]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Tria]]></surname>
<given-names><![CDATA[F. Di]]></given-names>
</name>
<name>
<surname><![CDATA[Lefons]]></surname>
<given-names><![CDATA[E]]></given-names>
</name>
<name>
<surname><![CDATA[Tangorra]]></surname>
<given-names><![CDATA[F]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Academic Data Warehouse Design Using a Hybrid Methodology]]></article-title>
<source><![CDATA[Computer Science and Information Systems]]></source>
<year>2015</year>
<volume>12</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>135-60</page-range></nlm-citation>
</ref>
<ref id="B9">
<label>[9]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Portal]]></surname>
<given-names><![CDATA[S. Gorbea]]></given-names>
</name>
<name>
<surname><![CDATA[Jaramillo]]></surname>
<given-names><![CDATA[M. Madera]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Diseño de un data warehouse para medir el desarrollo disciplinar en instituciones académicas]]></article-title>
<source><![CDATA[Investigación Bibliotecológica]]></source>
<year>2017</year>
<volume>31</volume>
<page-range>161-81</page-range></nlm-citation>
</ref>
<ref id="B10">
<label>[10]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Solodovnikova]]></surname>
<given-names><![CDATA[D]]></given-names>
</name>
<name>
<surname><![CDATA[Niedrite]]></surname>
<given-names><![CDATA[L]]></given-names>
</name>
<name>
<surname><![CDATA[Niedritis]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Architecture Enabling Adaptation of Data Integration Processes for a Research Information System]]></article-title>
<source><![CDATA[Foundations of Computing and Decision Sciences]]></source>
<year>2018</year>
<volume>43</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>129-49</page-range></nlm-citation>
</ref>
<ref id="B11">
<label>[11]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Medina]]></surname>
<given-names><![CDATA[F]]></given-names>
</name>
<name>
<surname><![CDATA[Fariña]]></surname>
<given-names><![CDATA[F]]></given-names>
</name>
<name>
<surname><![CDATA[Castillo-Rojas]]></surname>
<given-names><![CDATA[W.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Data Mart para obtención de indicadores de productividad académica en una universidad Data Mart to obtain indicators of academic productivity in a university]]></article-title>
<source><![CDATA[Ingeniare. Revista Chilena de Ingeniería]]></source>
<year>2018</year>
<volume>26</volume>
<page-range>88-101</page-range></nlm-citation>
</ref>
<ref id="B12">
<label>[12]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Lapura]]></surname>
<given-names><![CDATA[E. V. F.]]></given-names>
</name>
<name>
<surname><![CDATA[Fernandez]]></surname>
<given-names><![CDATA[J. K. J.]]></given-names>
</name>
<name>
<surname><![CDATA[Pagatpat]]></surname>
<given-names><![CDATA[M. J. K.]]></given-names>
</name>
<name>
<surname><![CDATA[Dinawanao]]></surname>
<given-names><![CDATA[D. D.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Development of a University Financial Data Warehouse and its Visualization Tool]]></article-title>
<source><![CDATA[Procedia Computer Science]]></source>
<year>2018</year>
<volume>135</volume>
<page-range>587-95</page-range></nlm-citation>
</ref>
<ref id="B13">
<label>[13]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Mendoza]]></surname>
<given-names><![CDATA[M. E.]]></given-names>
</name>
<name>
<surname><![CDATA[Durán]]></surname>
<given-names><![CDATA[L]]></given-names>
</name>
<name>
<surname><![CDATA[Rivera]]></surname>
<given-names><![CDATA[N]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[MBD 1.0. Metodología de Desarrollo de Bodegas de Datos Para Micro, Pequeñas y Medianas Empresas]]></article-title>
<source><![CDATA[UIS Ingenierías]]></source>
<year>2010</year>
<volume>9</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>85-101</page-range></nlm-citation>
</ref>
<ref id="B14">
<label>[14]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Pratt]]></surname>
<given-names><![CDATA[K. S.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Design Patterns for Research Methods: Iterative Field Research]]></article-title>
<source><![CDATA[AAAI Spring Symposium: Experimental Design for Real]]></source>
<year>2009</year>
<numero>1994</numero>
<issue>1994</issue>
<page-range>1-7</page-range></nlm-citation>
</ref>
<ref id="B15">
<label>[15]</label><nlm-citation citation-type="">
<collab>Congreso Nacional de Colombia</collab>
<source><![CDATA[Ley 30 de Diciembre 28 de 1992]]></source>
<year>1992</year>
</nlm-citation>
</ref>
<ref id="B16">
<label>[16]</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kitchenham]]></surname>
<given-names><![CDATA[B]]></given-names>
</name>
<name>
<surname><![CDATA[Brereton]]></surname>
<given-names><![CDATA[P]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A systematic review of systematic review process research in software engineering]]></article-title>
<source><![CDATA[Information and Software Technology]]></source>
<year>2013</year>
<volume>55</volume>
<numero>12</numero>
<issue>12</issue>
<page-range>2049-75</page-range></nlm-citation>
</ref>
<ref id="B17">
<label>[17]</label><nlm-citation citation-type="">
<collab>ISO/IEC</collab>
<source><![CDATA[International Standard ISO/IEC 25010]]></source>
<year>2011</year>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
