DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It makes use of historical data to answer business questions
|
|
|
It reveals insight from data
|
|
|
It supports roll-up and drill-down to explore data
|
|
|
Its design is the same as database
|
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: -Drill-down refers to the process of viewing data at a level of increased detail, while roll-up refers to the process of viewing data with decreasing detail. Our system provides smooth and continuous level-of-detail control in all drilling operations.
Detailed explanation-3: -Roll-up data is the term given to the data that has been summarized. Before any raw data is purged, the minimum, maximum, and average values are calculated and can be preserved in several ways. Hourly data is the term given to data that is summarized, or rolled-up, every hour.