Multidimensional query reformulation with measure decomposition

作者:

Highlights:

• Approach to support performance comparisons in a federation of data marts.

• Multidimensional queries over a global model integrating local sources.

• An extension to the multidimensional model with mathematical formulas for indicators.

• A query reformulation approach exploiting aggregation and indicator decomposition.

• Computational analysis of the reformulation algorithm and proof of correctness.

摘要

•Approach to support performance comparisons in a federation of data marts.•Multidimensional queries over a global model integrating local sources.•An extension to the multidimensional model with mathematical formulas for indicators.•A query reformulation approach exploiting aggregation and indicator decomposition.•Computational analysis of the reformulation algorithm and proof of correctness.

论文关键词:Federated data warehouses,Query rewriting,Multidimensional model,Indicator formulas,Materialized views

论文评审过程:Received 13 June 2017, Revised 20 March 2018, Accepted 8 May 2018, Available online 18 May 2018, Version of Record 19 July 2018.

论文官网地址:https://doi.org/10.1016/j.is.2018.05.002