Data Warehouse Developer Question:
Download Job Interview Questions and Answers PDF
Explain me which one is faster, Multidimensional OLAP or Relational OLAP?
Answer:
☛ Multidimensional OLAP is faster than Relational OLAP.
☛ MOLAP: Multi-dimensional OLAP
☛ Data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats (one example is PowerOLAP’s .olp file). MOLAP products can be compatible with Excel, which can make data interactions easy to learn.
☛ ROLAP: Relational OLAP
☛ ROLAP products access a relational database by using SQL (structured query language), which is the standard language that is used to define and manipulate data in an RDBMS. Subsequent processing may occur in the RDBMS or within a mid-tier server, which accepts requests from clients, translates them into SQL statements, and passes them on to the RDBMS.
☛ MOLAP: Multi-dimensional OLAP
☛ Data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats (one example is PowerOLAP’s .olp file). MOLAP products can be compatible with Excel, which can make data interactions easy to learn.
☛ ROLAP: Relational OLAP
☛ ROLAP products access a relational database by using SQL (structured query language), which is the standard language that is used to define and manipulate data in an RDBMS. Subsequent processing may occur in the RDBMS or within a mid-tier server, which accepts requests from clients, translates them into SQL statements, and passes them on to the RDBMS.
Download Data Warehouse Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Do you know what is Data Warehousing? | Explain me what is ODS? |