Explain Different Types of Olap Servers
Dependent data marts pull data from existing data warehouses. ROLAP servers can be easily used with existing RDBMS. Data Warehousing Olap Few companies hire file server for storing and process data then database server is best option compare to file server. . Logically OLAP servers present business users with multidimensional data from the data warehouse or data marts without concerned regarding how or where the data are stored. Below explain each one. 1 Roll-up 2 Drill-down 3 Slice 4 Dice and 5 Pivot. OLAP Online Analytical Processing MOLAP Multidimensional Online Analytical Processing ROLAP Relational Online Analytical Processing HOLAP Hybrid Online Analytical Processing. WOLAP refers to an OLAP application that can be accessed through a web browser. An Action in simple terms is basically an event which can be initiated by a userapplication and it can take various forms depending upon the type of Action defined. ...
