O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15.6. CHAPTER SUMMARY

  • OLAP is critical because its multidimensional analysis, fast access, and powerful calculations exceed that of other analysis methods.

  • OLAP is defined on the basis of Codd's initial twelve guidelines.

  • OLAP characteristics include multidimensional view of the data, interactive and complex analysis facility, ability to perform intricate calculations, and fast response time.

  • Dimensional analysis is not confined to three dimensions that can be represented by a physical cube. Hypercubes provide a method for representing views with more dimensions.

  • ROLAP and MOLAP are the two major OLAP models. The difference between them lies in the way the basic data is stored. Ascertain which model is more suitable for your environment.

  • OLAP tools have matured. Some RDBMSs include support for OLAP.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required