DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
two.
|
|
|
three.
|
|
|
four.
|
|
|
five.
|
Detailed explanation-1: -A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly.
Detailed explanation-2: -The four characteristics of a data warehouse, also called features of a data warehouse, include SUBJECT ORIENTED, TIME VARIANT, INTEGRATED and NON-VOLATILE.
Detailed explanation-3: -Functions of Data Warehouse Tools and Utilities Data Transformation − Involves converting the data from legacy format to warehouse format. Data Loading − Involves sorting, summarizing, consolidating, checking integrity, and building indices and partitions. Refreshing − Involves updating from data sources to warehouse.
Detailed explanation-4: -The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart.