DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Accommodates historical data for many years
|
|
|
Organizing daily data
|
|
|
Statements 1 and 2 are correct
|
|
|
Statements 1 and 2 are wrong
|
Detailed explanation-1: -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-2: -While operational systems reflect current values as they support day-to-day operations, data warehouse data represents a long time horizon (up to 10 years) which means it stores mostly historical data.
Detailed explanation-3: -A data warehouse is specially designed for data analytics, which involves reading large amounts of data to understand relationships and trends across the data. A database is used to capture and store data, such as recording details of a transaction.
Detailed explanation-4: -Historic load: A data warehouse contains historical data. Based on user requirements data in warehouse has to be retained for a particular duration of time. This duration could be anywhere from a single year to several decades. When a data warehouse is created i.e., tables in them are created, it contains no records.