Relational Online Analytical Processing (ROLAP)
Definition - What does Relational Online Analytical Processing (ROLAP) mean?
Relational online analytical processing (ROLAP) is a kind of online analytical processing (OLAP) that analyzes data using multidimensional data models. The difference between ROLAP and other OLAPs is that it accesses data that is stored in a relational database rather than from a multidimensional database, which is the one most commonly used in other OLAPs. It can also generate SQL queries to perform calculations when an end-user wishes to do so.
Techopedia explains Relational Online Analytical Processing (ROLAP)
ROLAP can handle large volumes of data. Although its use of a relational database means that it requires more processing time, it can be accessed by any SQL tool, and it does not have to be a tool specifically for OLAPs. Compared to multidimensional online analytical processing (MOLAP), ROLAP tools are much better at controlling non-aggregated facts such as textual descriptions.
In terms of disadvantages, the performance of a ROLAP depends on the data size; it can be slow when the data being processed is large and fast if otherwise. Athough any SQL tool can access ROLAP, it is limited by these tools because SQL statements do not meet all users' needs, especially when performing complex calculations.
In terms of disadvantages, the performance of a ROLAP depends on the data size; it can be slow when the data being processed is large and fast if otherwise. Athough any SQL tool can access ROLAP, it is limited by these tools because SQL statements do not meet all users' needs, especially when performing complex calculations.
-
Beginner's Guide to Business Intelligence - Learn how to harness the power of business intelligence and analysis to gain a competitive marketplace advantage. We cover the technology that powers BI, delve into the latest market research, and examine emerging trends. -
Business Intelligence Buyer's Guide - This guide examines the data warehousing and data visualization/analytics markets. Case studies detail how businesses are using this today, as well as which products serve best for each major applications.
-
Business Intelligence Product Selection Tool - Find the Best Business Intelligence Vendors You're just a few steps away from your custom recommendations
Email Newsletter
Join thousands of others with our weekly newsletter
Please Wait...
Resources
![[DON'T MISS] Optimal Forecasting: Save Time, Money and Trouble](http://cdn.techopedia.com/resource/images/qrcode.png?width=80&height=40)
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.
