Rapid Recall Key 01–40
Do not use until you have attempted the prompt.
- Metadata Management: planning, implementation, and control enabling processing, maintenance, integration, security, audit, and governance of other data.
- It includes meaning, rules, ownership, systems, processes, quality, security, lineage, runtime status, and relationships—not only structural descriptions.
- Information can exist but remain hard to find/use without a catalog; Metadata makes organizational data knowledge discoverable and understandable.
- Manage business terminology; integrate diverse Metadata; assure quality/consistency/currency/security; provide standard access; enforce technical exchange standards.
- Organizational Commitment; Strategy; Enterprise Perspective; Socialization; Access; Quality; Audit; Improvement.
- Senior-management support/funding and recognition of Metadata as part of managing data as an enterprise asset.
- Define how Metadata will be created, maintained, integrated, and accessed; align it to business priorities before evaluating products.
- Design for enterprise extensibility while implementing iteratively/incrementally; enterprise perspective does not require big bang.
- Explain Metadata value and encourage business participation/contribution of expertise.
- Ensure consumers know how to find, access, and use Metadata.
- Process owners are accountable for quality of Metadata produced through modeling, SDLC, integration, process definition, and similar work.
- Audit: set/enforce/audit standards. Improvement: feedback mechanisms to identify/correct bad or stale Metadata.
- Metadata has values, owners, quality, lifecycle, security, and use requirements and therefore should itself be managed as data.
- Classification depends on context/abstraction: information describing one asset can be ordinary business data in another process.
- Business Metadata = meaning, business rules, ownership, governance, standards, quality/security/privacy, and usage context.
- Examples: definitions, business rules, calculations, DQ rules/results, SOR designation, valid values, Owner/Steward, security classification, known issues, usage notes.
- Technical Metadata = physical/technical structures, systems, mappings, and processes that store/move data.
- Examples: table/column names, datatypes, keys/indexes, schemas, source-target mappings, ETL details, application/program info, dependencies, technical lineage, access rights.
- Operational Metadata = runtime processing and access evidence about data.
- Examples: job logs, extract results, errors, schedule anomalies, query/report access/duration, SLA status, backup/DR status, volumes, retention/purge operations.
- Business = meaning/governance; Technical = implementation/structure/movement.
- Technical = design/implementation; Operational = actual execution/access state/evidence.
- Descriptive identifies/retrieves resources; Structural describes parts/relationships; Administrative supports lifecycle management.
- ISO/IEC 11179 provides a Metadata Registry framework for standardized data-element definitions/registration and Metadata-driven exchange.
- Parts 1, 3, 4, 5, and 6 as listed in Chapter 12.
- Less-structured content needs Metadata for discovery, classification, provenance, security, retention, and use.
- Minimum examples: name, format, source, version, date received, plus organization-required attributes.
- Application repositories; Business Glossary; BI tools; CMDB/configuration; Data Dictionaries; Integration tools; DBMS/system catalogs; Mapping tools; DQ tools; Directories/Catalogs; Event Messaging; Modeling tools/repositories; Reference Data repositories; Service Registries; Other Metadata stores.
- Business concepts, terminology, definitions, relationships, ownership/status/workflow.
- Data-set/data-element names, descriptions, characteristics, defaults, storage, relationships, uniqueness, and related detail.
- Glossary = business concept/term meaning; Dictionary = detailed data-set/element structure/characteristics.
- Dictionary = element/detail; Directory/Catalog = discover where systems/data/sources are located.
- IT assets/configuration items, relationships, versions, implementation/change context.
- Reports, calculations, filters, report fields/layouts, users, distribution information.
- Mappings, transformations, transient-file details, lineage, job status/duration/last successful run.
- Tables, columns, indexes, constraints, views, procedures, sizing, versions, deployment, availability information.
- Validation rules, profiles, quality scores, observed patterns.
- Conceptual/logical/physical model Metadata, entities, attributes, relationships, tables, keys, constraints.
- Domains, coded values, descriptions, contextual use, mappings, relationships.
- Service definitions, endpoints, interfaces, operations, parameters, policies, versions, availability, connection information.