DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Multidimensional
|
|
|
Single dimensional
|
|
|
Measured
|
|
|
Dimensional
|
Detailed explanation-1: -Explanation: Data that can be modelled as dimension attributes and measure attributes are called multi-dimensional data.
Detailed explanation-2: -A multidimensional model views data in the form of a data-cube. A data cube enables data to be modeled and viewed in multiple dimensions. It is defined by dimensions and facts. The dimensions are the perspectives or entities concerning which an organization keeps records.
Detailed explanation-3: -Multidimensional OLAP (MOLAP) is a classical OLAP that facilitates Data Analysis by using a multidimensional data cube. MOLAP tools process information with the same amount of response time irrespective of the level of summarizing. MOLAP server implements two level of storage to manage dense and sparse data sets.
Detailed explanation-4: -Answer-C) The multidimensional model of a data warehouse is known as a data cube.
Detailed explanation-5: -OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.