Answer Posted / marcelo malheiros

I know a lot of people understand ROLAP and MOLAP as where
the information is stored: if data is in a RDBMS, is ROLAP;
if it is in a self-contained cube, it is MOLAP.

What I find the above a misconcept of the terms.

I believe ROLAP and MOLAP differs from each other in the
language you use to retrieve the result set and the result
set format...

I don't find that storage is relevant... How would classify
BI done on top of IMS, IDMS, ADABAS, VSAM and other non
RDBMS data storages?... Yes, BI started using those data
repositories... As well, how would you classify BI deployed
on top of a flat file or an XML file?...

SO MY POINT IS THAT THE DATA STORAGE DOES NOT DEFINE ROLAP
OR MOLAP...

By MOLAP:
I understand that the data is retrieved via MDX and the
result set is formated as a hiearchy with tags (something
similar to XML) which provides seemless hierarchy
manipulation capabilities to MOLAP.

By ROLAP:
I understand that the data is retrieved via SQL (relational
algebra) and the result set is always formatted as a table.

My humble 2 cents...

Cheers!
Marcelo

Explain the structure of cold fusion?

991

---

Explain what is real time data-warehousing?

1046

---

Why should you put your data warehouse on a different system than your oltp system?

930

---

How to define a cube??

879

---

How to export mappings to the production environment?

834

---

Explain the difference between keylokup and joiner?

840

---

what are different storage options supported by oracle ?

2034

---

Explain the definition of normalized and denormalized view and what are the differences between them?

863

---

How can you communicate with web server (apache or iis) from coldfusion?

1030

---

What are session timeout and application timeout?

962

---

Explain what is difference between query studio and report studio?

932

---

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1015

---

Explain the versions of reportnet?

921

---

What is surrogate key? Where we use it explain with example?

858

---

What is Cognos script editor?

2480

---