Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation

João Moreira, Kelli Cordeiro, Maria Luiza M. Campos, Marcos Borges

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

2 Citations (Scopus)

Abstract

An issue in operating a national electric system is how the corporate image of an Independent System Operator (ISO) can be impacted by disturbances in the system and their related news publications from specialized press. To deal with it, a solution was developed in the context of the Brazilian Electric System National Operator (ONS): an analytical system for disturbances analysis integrating both structured and unstructured data sources. It considers both the daily news publications about the electric sector from ONS clippings website and the details of operational disturbances from the company data marts. We introduce here an adaptation of the hybrid multidimensional (MD) design method, considering heterogeneous data sources during business analysis and design phases. Most important, we illustrate how ontological analysis can enhance the semantic expressiveness of the MD modeling activity through a semi-automatic derivation process. The analytical potential is evidenced by a real scenario case study.
Original languageUndefined
Title of host publication4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT)
Place of PublicationBelgium
PublisherCEUR
Pages72-77
Number of pages6
Publication statusPublished - 27 Mar 2015
Event4th Workshop on Energy Data Management, EnDM 2015 - Brussels, Belgium
Duration: 27 Mar 201527 Mar 2015

Publication series

NameCEUR workshop proceedings
PublisherCEUR-WS.org
Volume1330
ISSN (Print)1613-0073

Workshop

Workshop4th Workshop on Energy Data Management, EnDM 2015
CountryBelgium
CityBrussels
Period27/03/1527/03/15

Keywords

  • SCS-Services
  • disturbances
  • EWI-26497
  • METIS-315053
  • Ontology
  • IR-98379
  • Multidimensional design
  • Unstructured

Cite this

Moreira, J., Cordeiro, K., Campos, M. L. M., & Borges, M. (2015). Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation. In 4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT) (pp. 72-77). (CEUR workshop proceedings; Vol. 1330). Belgium: CEUR.
Moreira, João ; Cordeiro, Kelli ; Campos, Maria Luiza M. ; Borges, Marcos. / Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation. 4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT). Belgium : CEUR, 2015. pp. 72-77 (CEUR workshop proceedings).
@inproceedings{9e35d85a9e27477d92616c2ccedf019a,
title = "Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation",
abstract = "An issue in operating a national electric system is how the corporate image of an Independent System Operator (ISO) can be impacted by disturbances in the system and their related news publications from specialized press. To deal with it, a solution was developed in the context of the Brazilian Electric System National Operator (ONS): an analytical system for disturbances analysis integrating both structured and unstructured data sources. It considers both the daily news publications about the electric sector from ONS clippings website and the details of operational disturbances from the company data marts. We introduce here an adaptation of the hybrid multidimensional (MD) design method, considering heterogeneous data sources during business analysis and design phases. Most important, we illustrate how ontological analysis can enhance the semantic expressiveness of the MD modeling activity through a semi-automatic derivation process. The analytical potential is evidenced by a real scenario case study.",
keywords = "SCS-Services, disturbances, EWI-26497, METIS-315053, Ontology, IR-98379, Multidimensional design, Unstructured",
author = "Jo{\~a}o Moreira and Kelli Cordeiro and Campos, {Maria Luiza M.} and Marcos Borges",
year = "2015",
month = "3",
day = "27",
language = "Undefined",
series = "CEUR workshop proceedings",
publisher = "CEUR",
pages = "72--77",
booktitle = "4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT)",

}

Moreira, J, Cordeiro, K, Campos, MLM & Borges, M 2015, Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation. in 4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT). CEUR workshop proceedings, vol. 1330, CEUR, Belgium, pp. 72-77, 4th Workshop on Energy Data Management, EnDM 2015, Brussels, Belgium, 27/03/15.

Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation. / Moreira, João; Cordeiro, Kelli; Campos, Maria Luiza M.; Borges, Marcos.

4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT). Belgium : CEUR, 2015. p. 72-77 (CEUR workshop proceedings; Vol. 1330).

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

TY - GEN

T1 - Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation

AU - Moreira, João

AU - Cordeiro, Kelli

AU - Campos, Maria Luiza M.

AU - Borges, Marcos

PY - 2015/3/27

Y1 - 2015/3/27

N2 - An issue in operating a national electric system is how the corporate image of an Independent System Operator (ISO) can be impacted by disturbances in the system and their related news publications from specialized press. To deal with it, a solution was developed in the context of the Brazilian Electric System National Operator (ONS): an analytical system for disturbances analysis integrating both structured and unstructured data sources. It considers both the daily news publications about the electric sector from ONS clippings website and the details of operational disturbances from the company data marts. We introduce here an adaptation of the hybrid multidimensional (MD) design method, considering heterogeneous data sources during business analysis and design phases. Most important, we illustrate how ontological analysis can enhance the semantic expressiveness of the MD modeling activity through a semi-automatic derivation process. The analytical potential is evidenced by a real scenario case study.

AB - An issue in operating a national electric system is how the corporate image of an Independent System Operator (ISO) can be impacted by disturbances in the system and their related news publications from specialized press. To deal with it, a solution was developed in the context of the Brazilian Electric System National Operator (ONS): an analytical system for disturbances analysis integrating both structured and unstructured data sources. It considers both the daily news publications about the electric sector from ONS clippings website and the details of operational disturbances from the company data marts. We introduce here an adaptation of the hybrid multidimensional (MD) design method, considering heterogeneous data sources during business analysis and design phases. Most important, we illustrate how ontological analysis can enhance the semantic expressiveness of the MD modeling activity through a semi-automatic derivation process. The analytical potential is evidenced by a real scenario case study.

KW - SCS-Services

KW - disturbances

KW - EWI-26497

KW - METIS-315053

KW - Ontology

KW - IR-98379

KW - Multidimensional design

KW - Unstructured

M3 - Conference contribution

T3 - CEUR workshop proceedings

SP - 72

EP - 77

BT - 4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT)

PB - CEUR

CY - Belgium

ER -

Moreira J, Cordeiro K, Campos MLM, Borges M. Hybrid multidimensional design for heterogeneous data supported by ontological analysis: an application case in the Brazilian electric system operation. In 4th Workshop on Energy Data Management (EnDM) in the 18th International Conference on Extending Database Technology (EDBT). Belgium: CEUR. 2015. p. 72-77. (CEUR workshop proceedings).