Explain me which one is faster, Multidimensional OLAP or Relational OLAP?
Submitted by: Administrator☛ 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.
Submitted by: Administrator
☛ 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.
Submitted by: Administrator
Read Online Data Warehouse Developer Job Interview Questions And Answers
Top Data Warehouse Developer Questions
☺ | Explain me why is chameleon method used in data warehousing? |
☺ | Tell us what is Hybrid SCD? |
☺ | Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing? |
☺ | Can you list the Schema that a data warehouse system can implements? |
☺ | Tell us what is Virtual Warehouse? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |