Enumerate the different types of metadata explaining their purposes.

 Metadata is pervasive in information systems, and comes in many forms. The core features of most software packages we use every day are metadata-driven. People listen to music through Spotify; post photos on Instagram; locate video on YouTube; manage finances through Quicken; connect with others via email, text, and social media; and store lengthy contact lists on their mobile devices. All of this content comes with metadata—information about the item’s creation, name, topic, features, and the like. Metadata is key to the functionality of the systems holding the content, enabling users to find items of interest, record essential information about them, and share that information with others.

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. In terms of data warehouse, we can define metadata as follows.

•  Metadata is the road-map to a data warehouse. 
•  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. 

Metadata can be broadly categorized into three categories: 

•  Business Metadata - It has the data ownership information, business definition, and changing policies. 
•  Technical Metadata - It includes database system names, table and column names and sizes, data types and allowed values. Technical metadata also includes structural information such as primary and foreign key attributes and indices. 
•  Operational Metadata - It includes currency of data and data lineage. Currency of data means whether the data is active, archived, or purged. Lineage of data means the history of data migrated and transformation applied on it.

Metadata has a very important role in a data warehouse. The role of metadata in a warehouse is different from the warehouse data, yet it plays an important role. The various roles of metadata are explained below. 

•  Metadata acts as a directory. 
•  This directory helps the decision support system to locate the contents of the data warehouse. 
•  Metadata helps in decision support system for mapping of data when data is transformed from operational environment to data warehouse environment. 
•  Metadata helps in summarization between current detailed data and highly summarized data. 
•  Metadata also helps in summarization between lightly detailed data and highly summarized data. 
•  Metadata is used for query tools. 
•  Metadata is used in extraction and cleansing tools. 
•  Metadata is used in reporting tools. 
•  Metadata is used in transformation tools. 
•  Metadata plays an important role in loading functions.

Subcribe on Youtube - IGNOU SERVICE

For PDF copy of Solved Assignment

WhatsApp Us - 9113311883(Paid)