Gastvortrag von Dr. Mukesh Mohania

Reakkreditierung der Studienrichtung Wirtschaftsinformatik

Alle Neuigkeiten ansehen.



Unser Standort befindet sich hier.

Semantic OLAP Patterns: Elements of Reusable Business Analytics

Autoren: C. Schütz, S. Schausberger, I. Kovacic, M. Schrefl
Paper: Schu17b (2017)
Zitat: Proceedings of the Confederated International Conferences On-the-Move 2017 (OTM 2017), October 23-27, 2017, Rhodes, Greece, Springer International Publishing, Lecture Notes in Computer Science (LNCS Vol. 10574), Print ISBN 978-3-319-69458-0, Online ISBN 978-3-319-69459-7, peer reviewed, pp. 318-336, 2017.
Ressourcen: Kopie  (Senden Sie ein Email mit  Schu17b  als Betreff an dke.win@jku.at um diese Kopie zu erhalten)

Kurzfassung (Englisch):

Online analytical processing (OLAP) allows domain experts to gain insights into a subject of analysis. Domain experts are often casual users who interact with OLAP systems using standardized reports covering most of the domain experts' information needs. Analytical questions not answered by standardized reports must be posed as ad hoc queries. Casual users, however, are typically not familiar with OLAP data models and query languages, preferring to formulate questions in Business terms. Experience from industrial research projects shows that ad hoc queries frequently follow certain patterns which can be leveraged to provide assistance to domain experts. For example, queries in many domains focus on the relationships between a set of interest and a set of comparison. This paper proposes a pattern definition framework which allows for a machine-readable representation of recurring, domain-Independent patterns in OLAP. Semantic web technologies serve for the Definition of OLAP patterns as well as the data models and business terms used to instantiate the patterns. Ad hoc query composition then amounts to selecting an appropriate pattern and instantiating that pattern by reference to semantic predicates that encode business terms. Pattern instances eventually translate into a target language, e.g., SQL.

Keywords: Design patterns, multidimensional model, ad hoc queries, semantic web technologies, business Terms