DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Subject-oriented.
|
|
|
Integrated.
|
|
|
Non-volatile.
|
|
|
All of the above.
|
Detailed explanation-1: -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-2: -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.
Detailed explanation-3: -A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools.
Detailed explanation-4: -A system that is used to run the business in real time and is based on historical data.