DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The actual discovery phase of a knowledge discovery process
|
|
|
The stage of selecting the right data for a KDD process
|
|
|
A subject-oriented integrated time variant non-volatile collection of data in support of management
|
|
|
None of these
|
Detailed explanation-1: -“A data warehouse is a subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management’s decision making process”-William H. Inmon. Data warehousing is a collection of decision support technologies utilized across many industries.
Detailed explanation-2: -Time variant data structures. Time variance means that the data warehouse also records the timestamp of data. So inside a data warehouse, a time variant table can be structured almost exactly the same as the source table, but with the addition of a timestamp column.
Detailed explanation-3: -In the early nineties, Bill Inmon coined the term data warehouse: A subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s decisions.
Detailed explanation-4: -Data warehouses are characterized by being: Subject-oriented: A data warehouse typically provides information on a topic (such as a sales inventory or supply chain) rather than company operations. Time-variant: Time variant keys (e.g., for the date, month, time) are typically present.