Analytical metadata modeling for next generation BI systems

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

Research output: Contribution to journalJournal articleResearchpeer-review

1 Citation (Scopus)

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.
Original languageEnglish
JournalJournal of Systems and Software
Volume144
Pages (from-to)240 - 254
Number of pages15
ISSN0164-1212
DOIs
Publication statusPublished - 1 Oct 2018

Fingerprint

Competitive intelligence
Metadata
Data structures
Decision making
Semantics

Keywords

  • Business intelligence, Metadata, Ontological metamodeling

Cite this

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

In: Journal of Systems and Software, Vol. 144, 01.10.2018, p. 240 - 254.

Research output: Contribution to journalJournal articleResearchpeer-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 -