UrbanPro
true

Learn BI Reporting from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

What Are Olap, Molap, Rolap, Dolap, Holap?

ITech Analytic Solutions
15/12/2017 0 0

1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

2. MOLAP: Multidimensional OLAP: This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request. Targeted at groups of users because it's a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.

3. DOLAP: Desktop OLAP: Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects). Designed for low-end, single, departmental user. Data is stored in cubes on the desktop. It's like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.

4. ROLAP: Relational OLAP: Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases. Used for large departments or groups because it supports large amounts of data and users.

5. HOLAP: Hybridization of OLAP, which can include any of the above.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

specimen of how to create a Mail Merge in Microsoft Office WORD document. when you will create it will appear as below mentioned document
Mr. SHARMA AVINASH VPSC pvt. ltd., H.NO.16, REVENUE CIRCLE, , CIVIL LINES,NEAR COLLECTRATE, AJMER - 305001, RAJASTHAN INDIA To Mr. SHARMA, Themes and styles also help keep your document coordinated....
V

Vaibhav R.

0 0
0

Big Data Hadoop Basic Tutorial For Beginners
Hadoop Basics for Admin and developers Hadoop is a framework used for storing and processing huge data sets. By huge data I mean Big Data. Big data is any data that cannot be handled by traditional RDBMS....
R

Rahul R

0 0
0

Macros/VBA Function - Format
Hi VBA/Macro Learners, Today we will see how to use FORMAT Function in VBA to get modify the format of Numbers,Dates,Times & String. Syntax: FORMAT(expression,format,,) 'Ex1: Modify the Format...

Remove gridline on active sheet
If you want to remove gridline on your active work sheet then follow below path Go to Ribbon click on View tab then uncheck gridline check box as shown in picture

10 Cool SQL Optimizations That Do Not Depend On The Cost Model
Today, we don’t want to talk about cost based optimisation, i.e. optimisations that depend on a database’s cost model. We’ll look into much simpler optimisations that can be implemented...

Looking for BI Reporting Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more