Guided Query Composition with Semantic OLAP Patterns

Ilko Kovacic; Christoph Georg Schütz; Simon Schausberger; Roman Sumereder; Michael Schrefl

Guided Query Composition with Semantic OLAP Patterns

Ilko Kovacic, Christoph Georg Schütz, Simon Schausberger, Roman Sumereder, Michael Schrefl

Institute of Business Informatics - Data & Knowledge Engineering

Research output: Chapter in Book/Report/Conference proceeding › Conference proceedings › peer-review

Abstract

Enabling domain experts to independently compose ad hoc OLAP queries is the primary goal of semantic OLAP (semOLAP) patterns. In this respect, a semOLAP pattern represents a recurring domain-independent OLAP query by describing the application scope and defining the structure of the query using formal pattern elements (FPEs). Such a semOLAP pattern is executable: In order to execute a semOLAP pattern, the user instantiates the pattern by providing FPE bindings. In this paper, we propose an approach for guided query composition which considers the inherent query structure in order to determine a navigation flow and recommend possible bindings for the corresponding FPEs. Guidance supports both existing as well as future, currently unidentified sem\-OLAP patterns. The presented approach has been implemented in the course of a collaborative research project between industry and academia on precision dairy farming.

Original language	English
Title of host publication	Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference
Place of Publication	http://ceur-ws.org/Vol-2083/paper-11.pdf
Publisher	CEUR Digital
Pages	67-74
Number of pages	8
Volume	2083
Publication status	Published - 2018

Publication series

Name	CEUR Workshop Proceedings

Fields of science

102 Computer Sciences
102010 Database systems
102015 Information systems
102016 IT security
102025 Distributed systems
102027 Web engineering
102028 Knowledge engineering
102030 Semantic technologies
102033 Data mining
502050 Business informatics
503008 E-learning

JKU Focus areas

Computation in Informatics and Mathematics
Management and Innovation

Cite this

Kovacic, Ilko ; Schütz, Christoph Georg ; Schausberger, Simon et al. / Guided Query Composition with Semantic OLAP Patterns. Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference. Vol. 2083 http://ceur-ws.org/Vol-2083/paper-11.pdf : CEUR Digital, 2018. pp. 67-74 (CEUR Workshop Proceedings).

@inproceedings{3a968d16cb644c8fb05e1b32b0717c10,

title = "Guided Query Composition with Semantic OLAP Patterns",

abstract = "Enabling domain experts to independently compose ad hoc OLAP queries is the primary goal of semantic OLAP (semOLAP) patterns. In this respect, a semOLAP pattern represents a recurring domain-independent OLAP query by describing the application scope and defining the structure of the query using formal pattern elements (FPEs). Such a semOLAP pattern is executable: In order to execute a semOLAP pattern, the user instantiates the pattern by providing FPE bindings. In this paper, we propose an approach for guided query composition which considers the inherent query structure in order to determine a navigation flow and recommend possible bindings for the corresponding FPEs. Guidance supports both existing as well as future, currently unidentified sem\textbackslash{}-OLAP patterns. The presented approach has been implemented in the course of a collaborative research project between industry and academia on precision dairy farming.",

author = "Ilko Kovacic and Sch{\"u}tz, \{Christoph Georg\} and Simon Schausberger and Roman Sumereder and Michael Schrefl",

year = "2018",

language = "English",

volume = "2083",

series = "CEUR Workshop Proceedings",

publisher = "CEUR Digital",

pages = "67--74",

booktitle = "Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference",

}

Kovacic, I, Schütz, CG, Schausberger, S, Sumereder, R & Schrefl, M 2018, Guided Query Composition with Semantic OLAP Patterns. in Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference. vol. 2083, CEUR Workshop Proceedings, CEUR Digital, http://ceur-ws.org/Vol-2083/paper-11.pdf, pp. 67-74.

Guided Query Composition with Semantic OLAP Patterns. / Kovacic, Ilko; Schütz, Christoph Georg; Schausberger, Simon et al.
Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference. Vol. 2083 http://ceur-ws.org/Vol-2083/paper-11.pdf: CEUR Digital, 2018. p. 67-74 (CEUR Workshop Proceedings).

Research output: Chapter in Book/Report/Conference proceeding › Conference proceedings › peer-review

TY - GEN

T1 - Guided Query Composition with Semantic OLAP Patterns

AU - Kovacic, Ilko

AU - Schütz, Christoph Georg

AU - Schausberger, Simon

AU - Sumereder, Roman

AU - Schrefl, Michael

PY - 2018

Y1 - 2018

N2 - Enabling domain experts to independently compose ad hoc OLAP queries is the primary goal of semantic OLAP (semOLAP) patterns. In this respect, a semOLAP pattern represents a recurring domain-independent OLAP query by describing the application scope and defining the structure of the query using formal pattern elements (FPEs). Such a semOLAP pattern is executable: In order to execute a semOLAP pattern, the user instantiates the pattern by providing FPE bindings. In this paper, we propose an approach for guided query composition which considers the inherent query structure in order to determine a navigation flow and recommend possible bindings for the corresponding FPEs. Guidance supports both existing as well as future, currently unidentified sem\-OLAP patterns. The presented approach has been implemented in the course of a collaborative research project between industry and academia on precision dairy farming.

AB - Enabling domain experts to independently compose ad hoc OLAP queries is the primary goal of semantic OLAP (semOLAP) patterns. In this respect, a semOLAP pattern represents a recurring domain-independent OLAP query by describing the application scope and defining the structure of the query using formal pattern elements (FPEs). Such a semOLAP pattern is executable: In order to execute a semOLAP pattern, the user instantiates the pattern by providing FPE bindings. In this paper, we propose an approach for guided query composition which considers the inherent query structure in order to determine a navigation flow and recommend possible bindings for the corresponding FPEs. Guidance supports both existing as well as future, currently unidentified sem\-OLAP patterns. The presented approach has been implemented in the course of a collaborative research project between industry and academia on precision dairy farming.

UR - http://www.dke.jku.at/research/publications/index.xq

M3 - Conference proceedings

VL - 2083

T3 - CEUR Workshop Proceedings

SP - 67

EP - 74

BT - Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference

PB - CEUR Digital

CY - http://ceur-ws.org/Vol-2083/paper-11.pdf

ER -

Kovacic I, Schütz CG, Schausberger S, Sumereder R, Schrefl M. Guided Query Composition with Semantic OLAP Patterns. In Proceedings of the 2nd International Workshop on Data Analytics Solutions for Real-Life Applications (DARLI-AP 2018), EDBT/ICDT 2018 Joint Conference. Vol. 2083. http://ceur-ws.org/Vol-2083/paper-11.pdf: CEUR Digital. 2018. p. 67-74. (CEUR Workshop Proceedings).

Guided Query Composition with Semantic OLAP Patterns

Abstract

Publication series

Fields of science

JKU Focus areas

Other files and links

AgriProKnow - Prozessbezogenes Informationsmanagement in Precision Dairy Farming

Cite this

Guided Query Composition with Semantic OLAP Patterns

Abstract

Publication series

Fields of science

JKU Focus areas

Other files and links

Projects

AgriProKnow - Prozessbezogenes Informationsmanagement in Precision Dairy Farming

Cite this