DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data mining
|
|
|
Data warehouse
|
|
|
Data mart
|
|
|
Basis data
|
Detailed explanation-1: -A subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management’s decisions. On the other hand, Ralph Kimball concisely defines a data warehouse as: A copy of transaction data specifically structured for query and analysis.
Detailed explanation-2: -“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.
Detailed explanation-3: -Explanation: Data warehouse is subject oriented, integrated, time variant, nonvolatile collection of data in support of management decisions.
Detailed explanation-4: -Subject Oriented − A data warehouse is subject oriented because it provides information around a subject rather than the organization’s ongoing operations. These subjects can be product, customers, suppliers, sales, revenue, etc.
Detailed explanation-5: -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.