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.
Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
