Metadata is commonly defined as 'data about data'. It includes information about the business usage of the data, about the population and storage of the data and the interrelations, and about people who own and manage the data.
Metadata can be broadly classified into the following categories:
- Business metadata which includes
- Business attribute definitions
- Business rules and transformations used to populate the business attribute
- System of record and the source attributes
- Data lineage including all intermediate data points
- Valid values and their definitions
- Technical metadata which includes
- Databases, reports, table name, column name
- Names of jobs and applications producing and consuming the data
- Data types, nullability, primary keys, foreign keys, indices, etc
- Operational Metadata which includes
- Audit controls and balancing information
- Exceptions and errors
- Data refresh time and schedule
- Data backup and recovery schedule
- Organizational metadata which includes
- Business and IT owners
- Data Stewards
This information is scattered throughout the enterprise and is not accessible. A metadata management solution facilitates the collection, dissemination, and management of metadata. Metadata management like most Data Management disciplines requires support, and commitment from corporate leadership. It requires the definition of a robust process and organization structure to make it happen. It is usually implemented along with or after a Data Governance program.
