Slide 16
Slide 16 text
Metadata Management
Business Metadata
• Definition and description of data sets, tables, and
columns
• Business rules, transformation rules, calculations, and
derivations
• Data models
• Data quality rules and measurement results
• Schedules by which data is updated
• Data provenance and data lineage
• Data standards
• Valid value constraints
• Stakeholder contact information (e.g., data owners, data
stewards)
• Security/privacy level of data
• Known issues with data
• Data usage notes
Technical Metadata
• Physical database table and column names
• Column property
• Database object properties
• Access permissions
• Data CRUD (create, replace, update and delete) rules
• Physical data models, including data table names, keys
and indexes
• Documented relationships between the data models and
the physical assets
• ETL job detail
• File format schema definitions
• Source-to-target mapping documentation
• Data lineage documentation, including upstream and
downstream change impact information
• Program and application names and descriptions
• Content update cycle jobs schedules and dependencies
• Recovery and backup rules
• Data access rights, groups, roles
Operational Metadata
• Logs of job execution for batch programs
• History of extracts and results
• Schedule anomalies
• Results of audit, balance, control measurements
• Error logs
• Reports and query access patterns, frequency and
execution time
• Patches and Version maintenance plan and execution,
current patching level
• Backup, retention, date created, disaster recovery
provisions
• SLA requirements and provisions
• Volumetric and usage patterns
• Data archiving and retention rules, related archives
• Purge criteria
• Data sharing rules and agreements
• Technical roles and responsibilities, contacts
16