DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
operational environment.
|
|
|
informal environment.
|
|
|
formal environment.
|
|
|
technology environment.
|
Detailed explanation-1: -The data within a data warehouse is usually derived from a wide range of sources such as application log files and transaction applications. A data warehouse centralizes and consolidates large amounts of data from multiple sources.
Detailed explanation-2: -A data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence. The operational data are used as a source for the data warehouse.
Detailed explanation-3: -Data warehouse contains summary data that is not found in operational environment.
Detailed explanation-4: -Data warehousing environments are data management systems typically designed to optimize the performance of data analysis queries on large data repositories.