DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Relational data.
|
|
|
Operational data.
|
|
|
Metadata.
|
|
|
Informational data.
|
Detailed explanation-1: -Explanation: Metadata Describes the data contained in the data warehouse.
Detailed explanation-2: - Metadata in a data warehouse defines the warehouse objects. Metadata acts as a directory. This directory helps the decision support system to locate the contents of a data warehouse. Note − In a data warehouse, we create metadata for the data names and definitions of a given data warehouse.
Detailed explanation-3: -All such metadata is stored in a repository. By going through Metadata, the end-users get to know from where they can begin analyzing the DW system. Else, it is tough for the end-users to know where to start the data analysis from in such a huge DW system.
Detailed explanation-4: -What is held in the catalog of the warehouse database system? Answer-A) Algorithmic level metadata is held in the catalog of the warehouse database system.
Detailed explanation-5: -There are three main types of metadata: descriptive, administrative, and structural. Descriptive metadata enables discovery, identification, and selection of resources. It can include elements such as title, author, and subjects. Administrative metadata facilities the management of resources.