FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is metadata in data warehousing? You may answer more than one
A
Business definition
B
Data dictionary
C
BI report
D
Measures
Explanation: 

Detailed explanation-1: -Metadata is simply defined as data about data. The data that is used to represent other data is known as metadata. For example, the index of a book serves as a metadata for the contents in the book. In other words, we can say that metadata is the summarized data that leads us to detailed data.

Detailed explanation-2: -A Data Dictionary is an integral part of a database. It holds the information about the database and the data that it stores called as metadata. A meta data is the data about the data. It is the self-describing nature of databases. It holds the information about each data element in the database.

Detailed explanation-3: -Data that provide information about other data. Metadata summarizes basic information about data, making finding & working with particular instances of data easier. Metadata can be created manually to be more accurate, or automatically and contain more basic information.

Detailed explanation-4: -There are three main types of metadata: descriptive, administrative, and structural. Descriptive metadata enables discovery, identification, and selection of resources.

There is 1 question to complete.