Business intelligence applied to monitoring and meta-monitoring scenarios

Producción científica: Capítulo del libro/informe/acta de congresoContribución de conferenciarevisión exhaustiva

3 Citas (Scopus)

Resumen

This paper presents the use of the Business Intelligence process and some of its technologies to perform monitoring and meta-monitoring actions on sensed data and physical components that compose an environmental monitoring platform. These actions are mainly related to the capture of data that are the input to carry out the support of the decision-making process in the regulation and control of environmental pollution, the definition of policies, and the application of preventive and corrective actions to keep the monitoring physical infrastructure operational. For application development, they were used three tools of the Pentaho Suite. Kettle for carrying out the Extraction, Transformation and Load (ETL) process of data stored using the relational model (MySQL), and the no relational (MongoDB) paradigm, Worbench for modelling the On-Line Analytical Processing (OLAP) cubes that operate over the data warehouse created from the monitoring operational data, and BI Server tool for publishing the defined cubes. Finally, we obtain as result a tool with a user friendly interface, and with capacities to filter and generate automatically summary tables and statistical graphics, based on the data of an environmental monitoring physical infrastructure.

Título traducido de la contribuciónBusiness intelligence applied to monitoring and meta-monitoring scenarios
Idioma originalInglés
Título de la publicación alojadaProceedings of the 11th Iberian Conference on Information Systems and Technologies, CISTI 2016
EditoresAlvaro Rocha, Luis Paulo Reis, Manuel Perez Cota, Ramiro Goncalves, Octavio Santana Suarez
EditorialIEEE Computer Society
ISBN (versión digital)9789899843462
DOI
EstadoPublicada - 25 jul. 2016
Evento11th Iberian Conference on Information Systems and Technologies, CISTI 2016 - Gran Canaria, Espana
Duración: 15 jun. 201618 jun. 2016

Serie de la publicación

NombreIberian Conference on Information Systems and Technologies, CISTI
Volumen2016-July
ISSN (versión impresa)2166-0727
ISSN (versión digital)2166-0735

Conferencia

Conferencia11th Iberian Conference on Information Systems and Technologies, CISTI 2016
País/TerritorioEspana
CiudadGran Canaria
Período15/06/1618/06/16

Nota bibliográfica

Publisher Copyright:
© 2016 AISTI.

Palabras clave

  • Business Intelligence
  • OLAP
  • Pentaho
  • data warehouse
  • meta-monitoring
  • monitoring

Citar esto