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).