Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model

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...

Full description

Bibliographic Details
Main Authors: Fuentes-Vargas, David-Antonio, Mendoza-Becerra, Martha-Eliana, Gómez-Flórez, Luis-Carlos
Format: Online
Language:eng
Published: Universidad Pedagógica y Tecnológica de Colombia 2022
Subjects:
Online Access:https://revistas.uptc.edu.co/index.php/ingenieria/article/view/15211
_version_ 1801706101691908096
author Fuentes-Vargas, David-Antonio
Mendoza-Becerra, Martha-Eliana
Gómez-Flórez, Luis-Carlos
author_facet Fuentes-Vargas, David-Antonio
Mendoza-Becerra, Martha-Eliana
Gómez-Flórez, Luis-Carlos
author_sort Fuentes-Vargas, David-Antonio
collection OJS
description 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.
format Online
id oai:oai.revistas.uptc.edu.co:article-15211
institution Revista Facultad de Ingeniería
language eng
publishDate 2022
publisher Universidad Pedagógica y Tecnológica de Colombia
record_format ojs
spelling oai:oai.revistas.uptc.edu.co:article-152112023-05-31T16:24:04Z Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model Bodega de datos adaptable con base en el factor de investigación del modelo de acreditación institucional del CNA Fuentes-Vargas, David-Antonio Mendoza-Becerra, Martha-Eliana Gómez-Flórez, Luis-Carlos Data Warehouses Dimensional Modeling Quality Guidelines Research Higher Education bodegas de datos Modelado Dimensional Lineamientos de calidad Investigación Educación Superior 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. 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%. Universidad Pedagógica y Tecnológica de Colombia 2022-12-31 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion text/xml application/pdf https://revistas.uptc.edu.co/index.php/ingenieria/article/view/15211 10.19053/01211129.v31.n62.2022.15211 Revista Facultad de Ingeniería; Vol. 31 No. 62 (2022): October-December 2022 (Continuous Publication); e15211 Revista Facultad de Ingeniería; Vol. 31 Núm. 62 (2022): Octubre-Diciembre 2022 (Publicación Continua) ; e15211 2357-5328 0121-1129 eng https://revistas.uptc.edu.co/index.php/ingenieria/article/view/15211/12576 https://revistas.uptc.edu.co/index.php/ingenieria/article/view/15211/12579 Copyright (c) 2022 David-Antonio Fuentes-Vargas, Martha-Eliana Mendoza-Becerra, Luis-Carlos Gómez-Flórez http://creativecommons.org/licenses/by/4.0
spellingShingle Data Warehouses
Dimensional Modeling
Quality Guidelines
Research
Higher Education
bodegas de datos
Modelado Dimensional
Lineamientos de calidad
Investigación
Educación Superior
Fuentes-Vargas, David-Antonio
Mendoza-Becerra, Martha-Eliana
Gómez-Flórez, Luis-Carlos
Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model
title Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model
title_alt Bodega de datos adaptable con base en el factor de investigación del modelo de acreditación institucional del CNA
title_full Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model
title_fullStr Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model
title_full_unstemmed Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model
title_short Adaptable Data Warehouse Based on the Research Factor of the NAC Institutional Accreditation Model
title_sort adaptable data warehouse based on the research factor of the nac institutional accreditation model
topic Data Warehouses
Dimensional Modeling
Quality Guidelines
Research
Higher Education
bodegas de datos
Modelado Dimensional
Lineamientos de calidad
Investigación
Educación Superior
topic_facet Data Warehouses
Dimensional Modeling
Quality Guidelines
Research
Higher Education
bodegas de datos
Modelado Dimensional
Lineamientos de calidad
Investigación
Educación Superior
url https://revistas.uptc.edu.co/index.php/ingenieria/article/view/15211
work_keys_str_mv AT fuentesvargasdavidantonio adaptabledatawarehousebasedontheresearchfactorofthenacinstitutionalaccreditationmodel
AT mendozabecerramarthaeliana adaptabledatawarehousebasedontheresearchfactorofthenacinstitutionalaccreditationmodel
AT gomezflorezluiscarlos adaptabledatawarehousebasedontheresearchfactorofthenacinstitutionalaccreditationmodel
AT fuentesvargasdavidantonio bodegadedatosadaptableconbaseenelfactordeinvestigaciondelmodelodeacreditacioninstitucionaldelcna
AT mendozabecerramarthaeliana bodegadedatosadaptableconbaseenelfactordeinvestigaciondelmodelodeacreditacioninstitucionaldelcna
AT gomezflorezluiscarlos bodegadedatosadaptableconbaseenelfactordeinvestigaciondelmodelodeacreditacioninstitucionaldelcna