DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It typically requires less disk storage
|
|
|
It typically requires more disk storage
|
|
|
Typical business queries requiring aggregate functions take more time
|
|
|
Increasing the size of a dimension is difficult
|
Detailed explanation-1: -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-2: -Multi-dimensional models are used when you have a large amount of data. If the size of your database is in terabytes, then the Multidimensional Model is the only option you have. The Multi-dimensional Model requires a huge quantity of high-speed disks, whereas disks are not important in the Tabular Model.
Detailed explanation-3: -The multidimensional data model is composed of logical cubes, measures, dimensions, hierarchies, levels, and attributes. The simplicity of the model is inherent because it defines objects that represent real-world business entities.
Detailed explanation-4: -Examples to Implement Multidimensional Data Model The Multi-Dimensional Data Models are, in general, applied on complex systems, whereas the single dimension data models can be used for simple uncomplicated data models. For Instance, One such complex system is the Healthcare system.