MOLAP Operations-
In organisation lots of data are available,That all data saved in operational database. The multi-dimensional OLAP Store large data in cubicle format and with user requirement all data can extract from dimensional cube,for extract data the MOLAP use the following operations for fetching data from cubicle format. The operations are as follows-
- Roll-Up
- Roll-down
- Slice and Dice
- pivot
1. Roll-Up-
It is the simplest process of display data to user. The role of operations represent data with hierarchical tree structure. In that information displayed as summarized format. In roll-up reduce the all size of data cube and hiding the background information with hiding the dimensions of the cube and reduction of information and only E-result is shown to user.
2. Roll-Down –
It is the opposite process of roll up follows the summary information for display to user. In roll-up the all information can hide and only result can show to user but in roll down adding the extra dimensions in to the hierarchical tree and display result as detailed format.
3. Slice and Dice-
Slice and dice break the body of information in smaller part for user shows that information in different view points. In cooking we can slice onion first in small part then rotate that onion and cut in dice so in slice and dice exactly same process is follows in that all information can slice first and then dice the information for fast process.
Slice-
In diagram shows the slicing of cube with user requirement with different dimension divide station.
Dice-
In following diagram shows that slice data is again dies into smaller part for getting a particular information to user with their requirement.
4. Pivot-
It is the operation of rotating cube in various format for dimensions for getting a better output to user. In that the cube is rotated vertically or horizontally with different dimension.
