DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
subject oriented
|
|
|
time variant
|
|
|
collection from heterogeneous sources
|
|
|
volatile
|
Detailed explanation-1: -Answer-D) Volatile is not a property of the data warehouse.
Detailed explanation-2: -A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision making process.”
Detailed explanation-3: -Characteristics Of A Data Warehouse. The four characteristics of a data warehouse, also called features of a data warehouse, include SUBJECT ORIENTED, TIME VARIANT, INTEGRATED and NON-VOLATILE.
Detailed explanation-4: -Nonvolatile means that, once entered into the warehouse, data should not change. This is logical because the purpose of a warehouse is to enable you to analyze what has occurred.
Detailed explanation-5: -The major characteristic of a data warehouse is that it is subject-oriented time-variant, integrated and non-volatile . We have 4 stages of Data Warehouse processing that are offline database, offline data warehousing, real time data Warehousing and integrated Data warehousing.