Hypothetical Analysis on Basis of View

Abstract

With the development of computer’s hardware, main memory becomes bigger and bigger and can hold more data, so some operation before need disk I/O, now can be completed in main memory. In OLAP what-if or hypothetical analysis may need modify data or alter structure of cube, it should recalculate cube and is a long process. This paper presents how to do What-if analysis in main memory database environments and the experience shows that main memory OLAP is obvious superior to disk OLAP.