Analytical metadata modeling for next generation BI systems

Business Intelligence (BI) systems are extensively used as in-house solutions to support decision-making in organizations. Next generation BI 2.0 systems claim for expanding the use of BI solutions to external data sources and assisting the user in conducting data analysis. In this context, the Anal...

Full description

Bibliographic Details
Authors: Varga, Jovan|||0000-0003-3773-3382, Romero Moral, Óscar|||0000-0001-6350-8328, Bach Pedersen, Torben, Thomsen, Christian
Format: article
Publication Date:2018
Country:España
Institution:Universitat Politècnica de Catalunya (UPC)
Repository:UPCommons. Portal del coneixement obert de la UPC
Language:English
OAI Identifier:oai:upcommons.upc.edu:2117/124373
Online Access:https://hdl.handle.net/2117/124373
https://dx.doi.org/10.1016/j.jss.2018.06.039
Access Level:Open access
Keyword:Metadata
Decision support systems
Business intelligence
Ontological metamodeling
Metadades
Sistemes d'ajuda a la decisió
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
id ES_b6c9eec83ffca4c34176680dbc04c339
oai_identifier_str oai:upcommons.upc.edu:2117/124373
network_acronym_str ES
network_name_str España
repository_id_str
spelling Analytical metadata modeling for next generation BI systemsVarga, Jovan|||0000-0003-3773-3382Romero Moral, Óscar|||0000-0001-6350-8328Bach Pedersen, TorbenThomsen, ChristianMetadataDecision support systemsBusiness intelligenceOntological metamodelingMetadadesSistemes d'ajuda a la decisióÀrees temàtiques de la UPC::Informàtica::Sistemes d'informacióBusiness Intelligence (BI) systems are extensively used as in-house solutions to support decision-making in organizations. Next generation BI 2.0 systems claim for expanding the use of BI solutions to external data sources and assisting the user in conducting data analysis. In this context, the Analytical Metadata (AM) framework defines the metadata artifacts (e.g., schema and queries) that are exploited for user assistance purposes. As such artifacts are typically handled in ad-hoc and system specific manners, BI 2.0 argues for a flexible solution supporting metadata exploration across different systems. In this paper, we focus on the AM modeling. We propose SM4AM, an RDF-based Semantic Metamodel for AM. On the one hand, we claim for ontological metamodeling as the proper solution, instead of a fixed universal model, due to (meta)data models heterogeneity in BI 2.0. On the other hand, RDF provides means for facilitating defining and sharing flexible metadata representations. Furthermore, we provide a method to instantiate our metamodel. Finally, we present a real-world case study and discuss how SM4AM, specially the schema and query artifacts, can help traversing different models instantiating our metamodel and enabling innovative means to explore external repositories in what we call metamodel-driven (meta)data exploration.Peer Reviewed20182018-10-0120182018-11-15journal articlehttp://purl.org/coar/resource_type/c_6501AMhttp://purl.org/coar/version/c_ab4af688f83e57aainfo:eu-repo/semantics/articleapplication/pdfhttps://hdl.handle.net/2117/124373https://dx.doi.org/10.1016/j.jss.2018.06.039reponame:UPCommons. Portal del coneixement obert de la UPCinstname:Universitat Politècnica de Catalunya (UPC)Inglésengopen accesshttp://purl.org/coar/access_right/c_abf2Attribution-NonCommercial-NoDerivs 3.0 Spainhttp://creativecommons.org/licenses/by-nc-nd/3.0/es/info:eu-repo/semantics/openAccessoai:upcommons.upc.edu:2117/1243732026-05-27T15:37:01Z
dc.title.none.fl_str_mv Analytical metadata modeling for next generation BI systems
title Analytical metadata modeling for next generation BI systems
spellingShingle Analytical metadata modeling for next generation BI systems
Varga, Jovan|||0000-0003-3773-3382
Metadata
Decision support systems
Business intelligence
Ontological metamodeling
Metadades
Sistemes d'ajuda a la decisió
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
title_short Analytical metadata modeling for next generation BI systems
title_full Analytical metadata modeling for next generation BI systems
title_fullStr Analytical metadata modeling for next generation BI systems
title_full_unstemmed Analytical metadata modeling for next generation BI systems
title_sort Analytical metadata modeling for next generation BI systems
dc.creator.none.fl_str_mv Varga, Jovan|||0000-0003-3773-3382
Romero Moral, Óscar|||0000-0001-6350-8328
Bach Pedersen, Torben
Thomsen, Christian
author Varga, Jovan|||0000-0003-3773-3382
author_facet Varga, Jovan|||0000-0003-3773-3382
Romero Moral, Óscar|||0000-0001-6350-8328
Bach Pedersen, Torben
Thomsen, Christian
author_role author
author2 Romero Moral, Óscar|||0000-0001-6350-8328
Bach Pedersen, Torben
Thomsen, Christian
author2_role author
author
author
dc.subject.none.fl_str_mv Metadata
Decision support systems
Business intelligence
Ontological metamodeling
Metadades
Sistemes d'ajuda a la decisió
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
topic Metadata
Decision support systems
Business intelligence
Ontological metamodeling
Metadades
Sistemes d'ajuda a la decisió
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
description Business Intelligence (BI) systems are extensively used as in-house solutions to support decision-making in organizations. Next generation BI 2.0 systems claim for expanding the use of BI solutions to external data sources and assisting the user in conducting data analysis. In this context, the Analytical Metadata (AM) framework defines the metadata artifacts (e.g., schema and queries) that are exploited for user assistance purposes. As such artifacts are typically handled in ad-hoc and system specific manners, BI 2.0 argues for a flexible solution supporting metadata exploration across different systems. In this paper, we focus on the AM modeling. We propose SM4AM, an RDF-based Semantic Metamodel for AM. On the one hand, we claim for ontological metamodeling as the proper solution, instead of a fixed universal model, due to (meta)data models heterogeneity in BI 2.0. On the other hand, RDF provides means for facilitating defining and sharing flexible metadata representations. Furthermore, we provide a method to instantiate our metamodel. Finally, we present a real-world case study and discuss how SM4AM, specially the schema and query artifacts, can help traversing different models instantiating our metamodel and enabling innovative means to explore external repositories in what we call metamodel-driven (meta)data exploration.
publishDate 2018
dc.date.none.fl_str_mv 2018
2018-10-01
2018
2018-11-15
dc.type.none.fl_str_mv journal article
http://purl.org/coar/resource_type/c_6501
AM
http://purl.org/coar/version/c_ab4af688f83e57aa
dc.type.openaire.fl_str_mv info:eu-repo/semantics/article
format article
dc.identifier.none.fl_str_mv https://hdl.handle.net/2117/124373
https://dx.doi.org/10.1016/j.jss.2018.06.039
url https://hdl.handle.net/2117/124373
https://dx.doi.org/10.1016/j.jss.2018.06.039
dc.language.none.fl_str_mv Inglés
eng
language_invalid_str_mv Inglés
language eng
dc.rights.none.fl_str_mv open access
http://purl.org/coar/access_right/c_abf2
Attribution-NonCommercial-NoDerivs 3.0 Spain
http://creativecommons.org/licenses/by-nc-nd/3.0/es/
dc.rights.openaire.fl_str_mv info:eu-repo/semantics/openAccess
rights_invalid_str_mv open access
http://purl.org/coar/access_right/c_abf2
Attribution-NonCommercial-NoDerivs 3.0 Spain
http://creativecommons.org/licenses/by-nc-nd/3.0/es/
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:UPCommons. Portal del coneixement obert de la UPC
instname:Universitat Politècnica de Catalunya (UPC)
instname_str Universitat Politècnica de Catalunya (UPC)
reponame_str UPCommons. Portal del coneixement obert de la UPC
collection UPCommons. Portal del coneixement obert de la UPC
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869417475760717824
score 15.301603

Similar Items