Types of Meta Data

Types of Meta Data (According to Arun K. Pujari):

1.7.1.1 Build Time Meta Data

At the time of data DWH designing and building, the metadata that we generate can be termed as build time meta data. This metadata links business and Ware house terminology and describe the data technical structure. IT is most detailed and exact type of meta data and is used extensively by ware house designer, developer and administrator.

1.7.1.2 Usage Meta Data

When the ware house is in production, usage meta data, which is derived from built time meta data is an important tool for users and data administrator.

1.7.1.1 Control Meta Data

This metadata is used by databases and other tools to manage their own operation. Control metadata are used by system programmer only. It provides vital information about the timelines of ware house data and helps user track the sequence and timing of ware events.

Ex: Suppose a copy of build time meta data catalog I maintained DBMS for the internal representation. This will be called control metadata.