DOLAP
OLAP PROVIDERS
ROLAP
DRILL THROUGH
OLAP
HOLAP
CUBE OLAP
MOLAP
It is one of the most significant and useful tools of the system, since it allows the user to break down any data from a report to the original receipt, to know the detail of how it was calculated.
DESKTOP OLAP. MOLAP INSTALLATION IN A CLIENT EQUIPMENT
IT IS A DATABASE THAT POSSESSES SEVERAL DIMENSIONS, EXPANDING THE POSSIBILITIES THAT, UP TO THE MOMENT, OFFER THE KNOWN CALCULATION SHEETS
It requires a preprocessing and storage of the information contained in the OLAP cube. store this data in an optimized multidimensional storage array, rather than in a relational database
These are OLAP systems and tools (OnLine Analytical Processing) built on a relational database. It is an alternative to MOLAP (Multidimensional OLAP) technology that is built on multidimensional data bases.
It is a combination of ROLAP and MOLAP, which are other possible implementations of OLAP. HOLAP allows you to store a part of the data as in a MOLAP system and the rest as in a ROLAP. The degree of control that the application operator has over this partitioning varies from one product to another.
BUSINESS OBJECT, MICROSTRATEGY OLAP, COGNOS OLAP, IBM OLPA, ORACLE, SAS INSTITUTE.
IT IS A MULTIDIMENSIONAL DATABASE WHERE THE PHYSICAL STORAGE OF THE DATA IS REALIZED IN A UNIDIMENSIONAL VECTOR.
