DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Rollup
|
|
|
Drill down
|
|
|
Dicing
|
|
|
Pivoting
|
Detailed explanation-1: -The process of moving from finer granular data to coarser granular data is called as drill-down.
Detailed explanation-2: -Pivoting: changing the dimensions used in a cross-tab is called. Slicing: creating a cross-tab for fixed values only. Sometimes called dicing, particularly when values for multiple dimensions are fixed.
Detailed explanation-3: -OLAP (online analytical processing) is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view.
Detailed explanation-4: -Answer. The generalization of cross-tab which is represented visually is two dimensional cube which is also called as data cube .
Detailed explanation-5: -The Full Form of OLAP is Online Analytical Processing.