arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 1302.0351cs.DB
收藏

为内存中假设分析引入新的维度值

New Dimension Value Introduction for In-Memory What-If Analysis

Gaurav Saxena, Ruchi Narula, Manish Mishra

摘要:

OLAP系统对历史数据进行操作,并为分析师的查询提供答案。最近的内存实现为实时的ad-hoc分析提供了显著的性能改进。在基于数据仓库和内存数据存储的OLAP系统上进行假设分析的原理和技术已经被详细地介绍过,但是在假设分析的上下文中对新的维度值(属性)引入的探索已经被限制。我们扩展了Andrey Balmin等人的方法,在数据图上使用选择修改操作符,在只读内存数据存储中引入新的维度和度量值作为场景。我们的系统构造的场景没有具体化的行和存储行信息作为查询。与方案关联的行是在特定查询需要时构造的。

英文摘要:

OLAP systems operate on historical data and provide answers to analysts queries. Recent in-memory implementations provide significant performance improvement for real time ad-hoc analysis. Philosophy and techniques of what-if analysis on data warehouse and in-memory data store based OLAP systems have been covered in great detail before but exploration of new dimension value (attribute) introduction has been limited in the context of what-if analysis. We extend the approach of Andrey Balmin et al of using select modify operator on data graph to introduce new values for dimensions and measures in a read-only in-memory data store as scenarios. Our system constructs scenarios without materializing the rows and stores the row information as queries. The rows associated with the scenarios are constructed as and when required by an ad-hoc query.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑