subject: OLAP servers simplifying data processing [print this page] OLAP Server is based on two kinds of structure. They are Relational OLAP and Multi -dimensional OLAP accesses data from the warehouses directly and MOLAP executes a multi dimensional database for providing analysis .ROLAP is not in any way affected by the huge amounts of data stored on the database and gives the opportunity to the system designer regarding performance while MOLAP requires pre-compilations of databases so as to increase batch performance. ROLAP is better for dynamic consolidation for decision support analysis and MOLAP suits consolidation of data in batch. Compared to MOLAP, ROLAP can be used for a business dimensions and it has better support for OLAP analysis for the huge amounts of atomic level data, at the same time MOLAP delivers performance when data is less. Considering the end user requirement the server is important for staging multi dimensional data.
