Multidimensional Databases – OLAP And ROLAP

Online Analytical Processing (OLAP), and cubes are other words for multi-dimensional sets of data that essentially serve as a staging space in which to analyze information. These special online analytic processing databases hold data not in tables but in OLAP cubes which are a mechanism used to store and query data in an organized, multi-dimensional, structure specifically optimized for analysis.

OLAP databases are designed to pre-calculate as many queries and combinations of data fields as possible in order to provide fast query response. However, while these solutions perform better than classical relational databases, their multi-dimensional structure makes them inflexible and unable to accommodate changes easily. In addition, storing large amounts of data in a cube causes a performance bottleneck. While OLAP databases are quite useful for basic use cases, large data sets require using capabilities from additional tools in tandem, which complicates analytical efforts and requires unique skills.

ROLAP an Enhanced Approach?

Another way to organize data for multi-dimensional querying is relational online analytic processing (ROLAP). ROLAP is a form of OLAP that performs multi-dimensional analysis of data stored in a relational database rather than in a multi-dimensional database, which is considered the OLAP standard.

Although ROLAP technology performs better than OLAP databases when processing large amounts of data, it cannot beat the speed and efficiency of OLAP on smaller amounts of data. ROLAP databases require a great deal of manual maintenance and are difficult for business users to operate so ROLAP is considered to be more inflexible than OLAP cubes. OLAP and ROLAP are both still popular today but neither technology can keep up with today’s demands for near real time data for analytics nor handle unstructured data.

Advantages of Multidimensional Databases

2016-10-18-btdl-blog-post-3

Learn more about the new technology that is replacing OLAP and ROLAP. Get your free eBook now.