Hypothetical Analysis on Basis of View

Article Preview

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.

You might also be interested in these eBooks

Info:

Periodical:

Pages:

4007-4011

Citation:

Online since:

December 2010

Keywords:

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2011 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] http: /mondrian. pentaho. org.

Google Scholar

[2] http: /monetdb. cwi. nl.

Google Scholar

[3] Hurtado, C.A.; Mendelzon, A.O.; Vaisman, A.A., Maintain-ing data cubes under dimension updates, Proceedings 15th International Conference on Data Engineering, 1999, Volume, Issue, 23-26 Mar 1999, Page(s): 346 – 355 Digital Object, Identifier 10. 1109/ICDE. 1999. 754950.

DOI: 10.1109/icde.1999.754950

Google Scholar

[4] C. Hurtado, A.O. Mendelzon, and A. Vaisman, Updating OLAP dimensions, Proceedings of ACM DOLAP'99, (1999).

DOI: 10.1145/319757.319791

Google Scholar

[5] Ramirez, R.G.; Kulkarni, U.R.; Moser, K. A. The cost of re-trievals in what-if databases, Proceedings of the Twenty-Fourth Annual Hawaii International Conference on System Sciences, 1991, Volume ii, Issue, 8-11 Jan 1991 Page(s): 136 -145 vol. 2 Digital Object Identifier 10. 1109/ HICSS. 1991. 183973.

DOI: 10.1109/hicss.1991.183973

Google Scholar

[6] Daniel J. Abadi, Samuel R. Madden, Nabil Hachem, Column Stores vs. Row Stores: How Different Are They Really? In Proceedings of the ACM SIGMOD Conference, pages 967-980, (2008).

DOI: 10.1145/1376616.1376712

Google Scholar