OLAP Patterns: A pattern-based approach to multidimensional data analysis

作者:

Highlights:

• Individual OLAP queries are insufficient for documenting and sharing best-practice solutions for analytical problems.

• OLAP patterns document best-practice solutions for satisfying generic information needs

• Executable queries can be automatically obtained through instantiation of OLAP patterns.

• OLAP patterns can be shared within organizations as well as across organizations and even across domains.

• Applicability of OLAP patterns in a specific context is checked via parameters and constraints.

摘要

•Individual OLAP queries are insufficient for documenting and sharing best-practice solutions for analytical problems.•OLAP patterns document best-practice solutions for satisfying generic information needs•Executable queries can be automatically obtained through instantiation of OLAP patterns.•OLAP patterns can be shared within organizations as well as across organizations and even across domains.•Applicability of OLAP patterns in a specific context is checked via parameters and constraints.

论文关键词:Business intelligence,Conceptual modeling,Solution pattern,Online analytical processing,Data warehouse

论文评审过程:Received 11 September 2020, Revised 3 November 2021, Accepted 11 November 2021, Available online 25 November 2021, Version of Record 20 December 2021.

论文官网地址:https://doi.org/10.1016/j.datak.2021.101948