DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
two dimensional model
|
|
|
three dimensional model
|
|
|
multidimensional model
|
|
|
unidirectional model
|
Detailed explanation-1: -Answer-C) The multidimensional model of a data warehouse is known as a data cube.
Detailed explanation-2: -Multidimensional data model in data warehouse is a model which represents data in the form of data cubes. It allows to model and view the data in multiple dimensions and it is defined by dimensions and facts. Multidimensional data model is generally categorized around a central theme and represented by a fact table.
Detailed explanation-3: -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-4: -Data warehouse modeling is the process of designing and organizing your data models within your data warehouse platform. The design and organization process consists of setting up the appropriate databases and schemas so that the data can be transformed and then stored in a way that makes sense to the end user.
Detailed explanation-5: -A multidimensional database allows to rapidly and reliably providing data-related responses to complicated market questions. The Multidimensional Data Model can be defined as a way to arrange the data in the database, to help structure and organize the contents of the database.