DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
flat-files
|
|
|
database table
|
|
|
online data
|
|
|
all
|
Detailed explanation-1: -All data warehouses share a basic design in which metadata, summary data, and raw data are stored within the central repository of the warehouse. The repository is fed by data sources on one end and accessed by end users for analysis, reporting, and mining on the other end.
Detailed explanation-2: -A typical data warehouse often includes the following elements: A relational database to store and manage data. An extraction, loading, and transformation (ELT) solution for preparing the data for analysis. Statistical analysis, reporting, and data mining capabilities.
Detailed explanation-3: -A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools.
Detailed explanation-4: -A system that is used to run the business in real time and is based on historical data.
Detailed explanation-5: -Detailed Solution Explanation: Data warehouse usually contains historical data concluded from transactional data. A data warehouse includes ETL(extraction, transformation, and loading), OLAP engine, other tools that manages the collection of data and deliver this data to business users.