DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Multidimensional cube
|
|
|
Hyper cube
|
|
|
Cube
|
|
|
Both Multidimensional and Hyper Cube
|
Detailed explanation-1: -OLAP system is an OLAP cube also called a multidimensional cube or a hypercube. It consists of numeric facts called measures that are categorized by dimensions.
Detailed explanation-2: -An OLAP cube, also known as multidimensional cube or hypercube, is a data structure in SQL Server Analysis Services (SSAS) that is built, using OLAP databases, to allow near-instantaneous analysis of data.
Detailed explanation-3: -In a hypercube, each dimension belongs to one cube only. A dimension is “owned” by the hypercube. In a multicube, a dimension can be part of multiple cubes. That is, dimensions are not “owned” by any one cube; rather, they are available to all cubes. Also, there can be dimensions that do not belong to any cube.
Detailed explanation-4: -Vendors offer a variety of OLAP products that can be grouped into three categories: multidimensional OLAP (MOLAP), relational OLAP (ROLAP), and hybrid OLAP (HOLAP).
Detailed explanation-5: -A data cube (also called a business intelligence cube or OLAP cube) is a data structure optimized for fast and efficient analysis. It enables consolidating or aggregating relevant data into the cube and then drilling down, slicing and dicing, or pivoting data to view it from different angles.