DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
subject-oriented.
|
|
|
time-variant.
|
|
|
integrated.
|
|
|
All of the above.
|
Detailed explanation-1: -Explanation: The important aspect of the data warehouse environment is that data found within the data warehouse is: Subject-oriented, Time-variant, Integrated.
Detailed explanation-2: -What are the key components of a data warehouse? A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly.
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. The three prominent ones among these are. INTEGRATED, TIME VARIANT, NON VOLATILE.
Detailed explanation-4: -A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data.