Explore BrainMass

Explore BrainMass

    OLAP versus RDBMS

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Explain what one can do with an OLAP application that cannot be done with the same data in a spreadsheet or a relational database. Give two examples.

    © BrainMass Inc. brainmass.com October 9, 2019, 7:39 pm ad1c9bdddf

    Solution Preview

    Studies show that the Multidimensional database (OLAP):
    - Uses almost half the disk space of what Relational database requires for the same task,
    - Retrieves data between 8 and 200 times faster, and
    - Calculates the derived data at least 2 orders of magnitude faster than Relational.

    It is also seen that, when the best relational alternative was used, the generation and ...

    Solution Summary

    OLAP and RDBMS are compared.