Mercado de Datos para el control del consumo real de la energía eléctrica en el Puesto de Mando de la Dirección Provincial de Economía y Planificación en Villa Clara
Archivos
Fecha
2013-06-24
Autores
Delgado López, Liliaesther
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central "Marta Abreu" de la Villas
Resumen
La eficiencia energética es uno de los problemas esenciales que afectan el desempeño económico del país. La oficina del Puesto de Mando energético de la Dirección Provincial de Economía y Planificación en Villa Clara es la encargada de llevar el control del consumo de energía eléctrica en toda la provincia. Para llevar este control se manejan tres fuentes de datos, una almacena los planes del consumo y las dos restantes contienen el consumo real de los mayores y menores consumidores. El sistema MEnTOr es un sistema diseñado para la planificación del consumo mensual y anual de la energía eléctrica, y el consumo real se encuentra en ficheros Excel sin que exista un tratamiento histórico de los mismos, útiles para la dirección estratégica de la empresa.
En este trabajo se diseñó e implementó un Mercado de Datos a partir de la información obtenida de las fuentes de datos que permite el control del consumo real de energía de cada centro en comparación con sus planes, el comportamiento del consumo de energía en los diferentes meses, por trimestre, por año y por organismo, etc. Los resultados fueron validados con datos reales en la provincia de Villa Clara a partir de 2006.
Se exploró el uso de las tablas de hechos agregados con el propósito de obtener altos desempeños en el acceso a un Almacén de Datos.
Este estudio preliminar se tuvo en cuenta para el diseño del Mercado de Datos atendiendo a algunas de las recomendaciones sugeridas bajo el nombre de “buenas prácticas”.
The energy efficiency is one of the essential problems that affect the economic acting of the country. The office of the Position of energy Control of the Provincial Address of Economy and Planning in Villa Clara is the one in charge of taking into account the control of the electric power consumption in the whole province. To take this control three sources of data are managed, one stores the plans of the consumption the others contains the real consumption of the mayor and minors consumers. The Mentor system is a system designed for planning of the monthly and annual consumption of the electric power, and the real consumption is in Excel files and there is no historical treatment of the exists, useful for the strategic address of the company. In this work it was designed and it implemented a Data Mart starting from the obtained information of the sources of data that allows the control of the real consumption of energy of each center in comparison with their plans, the behavior of the energy consumption in the different months, for trimester, per year and for organism, etc. The results were validated with real data in the province of Villa Clara starting from 2006. The use of the charts of facts attachés was explored with the purpose of obtaining high acting in the access to a Warehouse of Data. This preliminary study was taking into account for the design of the Data Mart assisting some of the recommendations suggested under the name of "good practical."
The energy efficiency is one of the essential problems that affect the economic acting of the country. The office of the Position of energy Control of the Provincial Address of Economy and Planning in Villa Clara is the one in charge of taking into account the control of the electric power consumption in the whole province. To take this control three sources of data are managed, one stores the plans of the consumption the others contains the real consumption of the mayor and minors consumers. The Mentor system is a system designed for planning of the monthly and annual consumption of the electric power, and the real consumption is in Excel files and there is no historical treatment of the exists, useful for the strategic address of the company. In this work it was designed and it implemented a Data Mart starting from the obtained information of the sources of data that allows the control of the real consumption of energy of each center in comparison with their plans, the behavior of the energy consumption in the different months, for trimester, per year and for organism, etc. The results were validated with real data in the province of Villa Clara starting from 2006. The use of the charts of facts attachés was explored with the purpose of obtaining high acting in the access to a Warehouse of Data. This preliminary study was taking into account for the design of the Data Mart assisting some of the recommendations suggested under the name of "good practical."
Descripción
Palabras clave
Bases de Datos