ROLAP/Tabular-Direct Query
-
miércoles, 07 de marzo de 2012 4:10
Do we have specific scenario examples of when ROLAP is fit over DirectQuery/vice versa. Direct Query needs data to be in single SQL Sever. Let us assume that we have the dimension modeled data in Single SQL Server - then DQ or ROLAP which is best fit.
I would like to leave the feature of Writeback aside.
A comparision of ROLAP against Tabular/Direct Query would be helpful in the areas of Modeling, Processing Architecture, Cacheing etc.
Regards
kart
kart
Todas las respuestas
-
miércoles, 07 de marzo de 2012 4:31
Hi,
Multi-dimensional models supports MOLAP,ROLAP,HOLAP modes
Tabular models support vertipaq and DirectQuery modes.
You can't use rolap on tabular model and direct query on multi-dimensional.
Direct query in tabular does the same thing as ROLAP in multi-dimensional.
For detailed information on Direct Query, it's pros & cons check this link.
http://msdn.microsoft.com/en-us/library/hh230898(v=sql.110).aspx
================================================
Please mark as answer if helpful
-
miércoles, 07 de marzo de 2012 8:03
Yes that Tabular/DQ and ROLAP are similar in lines by their overall offering and have thier own capabilities. But the idea is that to bring the differences by quoting them to business scenarios against the assumption of having Dim Model based Physical Schema in a Single SQL DB. Would like to see if we havethe clear list side-by-side comparing ROLAP/DQ in Processing Architecuture/PRocessing Need, Real-time Support/cacheing etc, data source support etc.
Why should one go to Tabular/DQ if ROLAP provides the same functionality (from developer perspective).
Does ROLAP need Dimensional modeled source to provide better performance!
Should we use Tabular only if our source is in more relational format!
BTW. Thanks for adding MSDN link on DQ. Below are other links that can will help this
http://msdn.microsoft.com/en-us/library/hh212940(v=sql.110).aspx
http://msdn.microsoft.com/en-us/library/ms174915.aspx
kart
