Diseño de un Mercado de Datos para la toma de decisiones en el ámbito Académico de la Universidad Politécnica Territorial del estado Aragua “Dr. Federico Brito Figueroa” (UPTA)
Fecha
2011-07-11
Autores
Pimentel Latuff, César E
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
La investigación responde a la necesidad de soluciones a nivel estratégico en el ámbito académico de la “Universidad Politécnica Territorial del Estado Aragua”, (en lo sucesivo UPTA), el cual consiste básicamente en el diseño y construcción de un Mercado de Datos para dicha institución en el área académica, mediante el cual se puedan tomar decisiones oportunas en esta área de la institución.
La presentación de la información a través de reportes en una plataforma de filosofía Almacén de Datos lo proporcionan los sistemas de procesamiento analítico en línea, OLAP (por siglas en inglés On Line Analytical Processing), y estos procesamientos han demostrado ser adecuados con el modelo multidimensional. Para facilitar mostrar la información, los reportes que proporciona OLAP, la presenta en forma gráfica y de mapas. De esta manera se puede tener una visión global de la organización y así tomar decisiones acertadas sobre la base de necesidades de cada una de las áreas en las instituciones. En el mismo orden de ideas se puede mencionar que para el caso específico de la Universidad (UPTA) los siguientes elementos son algunos requerimientos que sirven de base para sustentar este trabajo: cálculo de promedio de notas de alumnos en las diferentes sedes y además desglosado por unidad curricular, profesor y alumno en cualquier período académico.
Cabe destacar que el valor practico de este trabajo es que se realiza en una institución educativa y no sobre la base mercantil como generalmente se hace, y cobra aun más fuerza por el hecho que está soportada sobre una plataforma de sistemas de Procesamiento de Transacciones en Línea (OLTP) basada en SQLServer, la cual es la única fuente de datos del sistema de Almacén de Datos a diseñar en la universidad UPTA.
The investigation is done to address the need for solutions to the strategic level in the academic field in the Territorial University of Aragua State "Dr. Federico Brito Figueroa, (hereinafter UPTA), which is basically the design and construction of a data mart for this institution in the academic field, by which to make appropriate decisions in this area of the institution. It is important to note that the presentation of information through reports on a platform of philosophy at Data Warehouse systems provide online analytical processing, OLAP (acronym in English for On Line Analytical Processing), and these prosecutions have proved adequate with the multidimensional model. To facilitate display information, which provides OLAP reporting, presentation in graphical form and maps. In this way you can get an overview of the organization, and make sound decisions based on needs of each of the areas in institutions. In the same vein, we may mention the specific case of the University (UPTA) the following are some basic requirements that serve to support this work: calculation of GPA of students in different locations and also broken down by curriculum unit, teacher and student in any academic period. Notably, the practical value of this work is being done in an educational institution and not on commercial basis as is usually done, and getting stronger by the fact that is supported on a platform of systems Online Transaction Processing (OLTP) based on SQLServer, which is the only data source Data Warehouse system design at the University UPTA.
The investigation is done to address the need for solutions to the strategic level in the academic field in the Territorial University of Aragua State "Dr. Federico Brito Figueroa, (hereinafter UPTA), which is basically the design and construction of a data mart for this institution in the academic field, by which to make appropriate decisions in this area of the institution. It is important to note that the presentation of information through reports on a platform of philosophy at Data Warehouse systems provide online analytical processing, OLAP (acronym in English for On Line Analytical Processing), and these prosecutions have proved adequate with the multidimensional model. To facilitate display information, which provides OLAP reporting, presentation in graphical form and maps. In this way you can get an overview of the organization, and make sound decisions based on needs of each of the areas in institutions. In the same vein, we may mention the specific case of the University (UPTA) the following are some basic requirements that serve to support this work: calculation of GPA of students in different locations and also broken down by curriculum unit, teacher and student in any academic period. Notably, the practical value of this work is being done in an educational institution and not on commercial basis as is usually done, and getting stronger by the fact that is supported on a platform of systems Online Transaction Processing (OLTP) based on SQLServer, which is the only data source Data Warehouse system design at the University UPTA.
Descripción
Palabras clave
Mercado de Datos, Sistemas de Información, Toma de Decisiones, OLAP (On Line Analytical Processing), SQLServer, UPTA (Universidad Politécnica Territorial del Estado Aragua)