%0 Journal Article
%T What-If Query Processing Policy of Main-Memory OLAP System
主存OLAP系统中what-if查询处理策略
%A ZHANG Yan-Song
%A XIAO Yan-Qin
%A WANG Shan
%A CHEN Hong
%A
张延松
%A 肖艳芹
%A 王珊
%A 陈红
%J 软件学报
%D 2010
%I
%X A what-if analysis can provide a more meaningful information than classical OLAP (on-line analysis processing). Multi-Scenario hypothesis upon historical data needs efficient what-if data view support. Two novel algorithms of deltaMap and pre-merge, which can greatly improve the performance of delta table algorithm with set operations, are proposed. To analyze the performance of query re-writing algorithm and delta cube algorithm under different what-if update conditions, a global performance analysis and comparison are presented in the experiment section. This paper proposes a cost model for a what-if analysis processing engine, based on different algorithms with parameters such as application scenario, what-if update rate, complexity of what-if updates, memory storage policy, cardinality of query result set etc, that can be used as a practical framework in a what-if analysis system.
%K what-if analysis
%K main-memory database
%K delta table
%K query re-writing
%K deltaMap index
%K pre-merge algorithm
what-if分析
%K 内存数据库
%K delta表
%K 查询重写
%K deltaMap索引
%K pre-merge算法
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=7735F413D429542E610B3D6AC0D5EC59&aid=3590E05B19457813EB1CEFDF0483A6A6&yid=140ECF96957D60B2&vid=659D3B06EBF534A7&iid=F3090AE9B60B7ED1&sid=B69FEB12D9A4855D&eid=8BBC50AE1A1F67D9&journal_id=1000-9825&journal_name=软件学报&referenced_num=0&reference_num=15