DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Dimensional modeling
|
|
|
Physical model
|
|
|
Logical model.
|
|
|
ER Model
|
Detailed explanation-1: -Star Schema: This is the most common technique and basic modelling type and is easy to understand. In which Fact table is connected with other all Dimension tables and considerably accepted architectural model and used to develop DWH and Data marts.
Detailed explanation-2: -Data Mart Structures Data fields can refer to one or multiple objects. Data marts are structured in a multidimensional schema that works as a blueprint for data analysis by users of the database. The three main structures or schema for data marts are star, snowflake, and vault.
Detailed explanation-3: -A Data modeling technique used for data marts is Dimensional modeling.
Detailed explanation-4: -Data Dimensional Modelling (DDM) is a technique that uses Dimensions and Facts to store the data in a Data Warehouse efficiently. It optimises the database for faster retrieval of the data. Dimensional Models have a specific structure and organise the data to generate reports that improve performance.
Detailed explanation-5: -A data mart is a persistent physical store of operational and aggregated data statistically processed data that supports businesspeople in making decisions based primarily on analyses of past activities and results.