DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -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.
Detailed explanation-3: -The data warehouse is an object-oriented, integrated, unaltered dataset that supports chronology and can play the role of a comprehensive source of reliable information for operational analysis and decision-making.
Detailed explanation-4: -A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.
Detailed explanation-5: -State whether True or False: Data warehouse is generally updated in real-time. Answer-B) False. The Data warehouse is not generally updated in real-time.