Analytical metadata modeling for next generation BI systems

Jovan Varga, Oscar Romero, Torben Bach Pedersen, Christian Thomsen

Publikation: Bidrag til tidsskriftTidsskriftartikelForskningpeer review

1 Citation (Scopus)

Resumé

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.
OriginalsprogEngelsk
TidsskriftJournal of Systems and Software
Vol/bind144
Sider (fra-til)240 - 254
Antal sider15
ISSN0164-1212
DOI
StatusUdgivet - 1 okt. 2018

Fingerprint

Competitive intelligence
Metadata
Data structures
Decision making
Semantics

Citer dette

@article{3f9a1ef9e4fa4bf6bd0419015cda5933,
title = "Analytical metadata modeling for next generation BI systems",
abstract = "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.",
keywords = "Business intelligence, Metadata, Ontological metamodeling",
author = "Jovan Varga and Oscar Romero and Pedersen, {Torben Bach} and Christian Thomsen",
year = "2018",
month = "10",
day = "1",
doi = "10.1016/j.jss.2018.06.039",
language = "English",
volume = "144",
pages = "240 -- 254",
journal = "Journal of Systems and Software",
issn = "0164-1212",
publisher = "Elsevier",

}

Analytical metadata modeling for next generation BI systems. / Varga, Jovan; Romero, Oscar; Pedersen, Torben Bach; Thomsen, Christian.

I: Journal of Systems and Software, Bind 144, 01.10.2018, s. 240 - 254.

Publikation: Bidrag til tidsskriftTidsskriftartikelForskningpeer review

TY - JOUR

T1 - Analytical metadata modeling for next generation BI systems

AU - Varga, Jovan

AU - Romero, Oscar

AU - Pedersen, Torben Bach

AU - Thomsen, Christian

PY - 2018/10/1

Y1 - 2018/10/1

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

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

KW - Business intelligence, Metadata, Ontological metamodeling

UR - http://www.scopus.com/inward/record.url?scp=85049309062&partnerID=8YFLogxK

U2 - 10.1016/j.jss.2018.06.039

DO - 10.1016/j.jss.2018.06.039

M3 - Journal article

VL - 144

SP - 240

EP - 254

JO - Journal of Systems and Software

JF - Journal of Systems and Software

SN - 0164-1212

ER -