We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Study Groups By Subject code Wise (Click Below on your university link & Join Your Subject Group)
Looking For Something at vustudents.ning.com?Search Here
Suppose an organization wants to implement an OLAP system. OLAP can be implemented in different ways, such as MOLAP, ROLAP, DOLAP and HOLAP. The organization demands extensive read operations on the database for real time decision making. In order to get real benefit from the business, data must be retrieved very fast to make decision making process quick and on time. Keeping in view the performance and storage cost, which option you will choose to implement OLAP and why? Justify your answer with solid reasoning.
Share This With Friends......
According to the situation, the HOLAP is best because HOLAP storage mode combines attributes of both MOLAP and ROLAP. Like MOLAP, HOLAP causes the aggregations of the partition to be stored in a multidimensional structure in an SQL Server Analysis Services instance. HOLAP does not cause a copy of the source data to be stored. For queries that access only summary data in the aggregations of a partition, HOLAP is the equivalent of MOLAP. Queries that access source data.. For example, if you want to drill down to an atomic cube cell for which there is no aggregation data must retrieve data from the relational database and will not be as fast as they would be if the source data were stored in the MOLAP structure. With HOLAP storage mode, users will typically experience substantial differences in query times depending upon whether the query can be resolved from cache or aggregations versus from the source data itself.