Sistema para el control general del Órgano de Informática, Comunicaciones y Cifras del MININT en Ciego de Ávila
Fecha
2014-06-27
Autores
Alonso Chaviano, Asiel Hextiandro
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
La Delegación Provincial del Ministerio del Interior en Ciego de Ávila tiene como misión principal mantener el orden y la seguridad de la provincia, tanto en tiempo de paz como en tiempo de guerra, por lo que es punto clave la mejora de la disciplina por parte de los trabajadores de la Delegación. El Órgano de Informática Comunicaciones y Cifras (OICC) como entidad que pertenece a la Delegación, propone la creación de un sistema de información operacional, en el que quedará registrada información importante referente a todos los trabajadores del órgano, además de lograr la automatización del control asistencial; proceso que se desarrolla a través de un escáner de huellas digitales, donde quedará registrado el trabajador y el momento exacto que arribó o salió del OICC. La utilización de la información histórica almacenada para que la misma no sea pasiva y ayude a la toma de decisiones por parte de la jefatura es el principal problema que se plantea.
En este trabajo se crea un Mercado de Datos con 9 dimensiones creadas, 8 tablas de hechos, entre ellas 2 transaccionales y 6 periódicas. Para el desarrollo de la solución se utilizó el lenguaje java, además de las herramientas de la Suite de Pentaho, y el Sistema de Gestor de Base de Datos PostgreSQL.
The Provincial Office of the Ministry of Interior in Ciego de Ávila has its main mission to maintain the order and the security of the province in peace time as well as in war time. For that reason is a key point the improvement of the discipline of the workers of the Office. The Organ of Computer, Communications and Numbers (OICC) as an entity that belongs to the Office proposes the creation of a system of operational information, in which will be registered important information with respect to all the workers of the organ as well as to achieve the automation of the assistance control; a process that is developed through a fingerprints scanner, where the worker and the exact moment of arrival or departure of the OICC will be registered. The use of the stored historical information so it doesn’t remain passive and could help to decision making of the headquarters is the main problem raised. In this thesis a data mart is created with 9 conformed dimensions, 8 fact tables, including 2 transactional and 6 snapshots periodic. For the development of the solution the Java language was used, besides the Suite Pentaho tools and Database Management System PostgreSQL.
The Provincial Office of the Ministry of Interior in Ciego de Ávila has its main mission to maintain the order and the security of the province in peace time as well as in war time. For that reason is a key point the improvement of the discipline of the workers of the Office. The Organ of Computer, Communications and Numbers (OICC) as an entity that belongs to the Office proposes the creation of a system of operational information, in which will be registered important information with respect to all the workers of the organ as well as to achieve the automation of the assistance control; a process that is developed through a fingerprints scanner, where the worker and the exact moment of arrival or departure of the OICC will be registered. The use of the stored historical information so it doesn’t remain passive and could help to decision making of the headquarters is the main problem raised. In this thesis a data mart is created with 9 conformed dimensions, 8 fact tables, including 2 transactional and 6 snapshots periodic. For the development of the solution the Java language was used, besides the Suite Pentaho tools and Database Management System PostgreSQL.
Descripción
Palabras clave
Sistema de Información, Mercado de Datos, Programacion, Ciego de Ávila