Semantic OLAP Patterns: Elements of Reusable Business Analytics

• Published in: On the Move to Meaningful Internet Systems. OTM 2017 Conferences Vol. 10574; pp. 318 - 336
• Main Authors: Schuetz, Christoph G., Schausberger, Simon, Kovacic, Ilko, Schrefl, Michael
• Format: Book Chapter
• Language: English
• Published: Switzerland Springer International Publishing AG 2017; Springer International Publishing
• Series: Lecture Notes in Computer Science
• Subjects: Ad hoc queries; Business terms; Design patterns; Multidimensional model; Semantic web technologies
• ISBN: 9783319694580; 3319694588
• ISSN: 0302-9743; 1611-3349
• DOI: 10.1007/978-3-319-69459-7_22

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.