---
title: "What Is a Data Dictionary? | Dawiso"
description: "A data dictionary documents an organization's data elements: names, types, definitions and relationships. How it differs from a glossary and a catalog."
url: "https://www.dawiso.com/glossary/data-dictionary"
language: "en"
---

June 8, 2026

data dictionarydata dictionary vs business glossarymetadata repositorytechnical metadatadata catalogdata definitions

# What Is a Data Dictionary?

A **data dictionary** is a centralized reference that documents the technical details of an organization's data elements - the tables, columns, and fields - including their names, data types, formats, allowed values, constraints, and relationships. If a database is the filing cabinet, the data dictionary is the index that explains what every drawer and folder contains, in precise technical terms. It answers the question a developer, analyst, or data engineer asks constantly: "what exactly is this column, what goes in it, and how does it relate to everything else?"

The data dictionary matters because data is useless if no one knows what it means at the field level. Without one, the same column is interpreted three different ways by three teams, integrations break on undocumented formats, and every new analyst rediscovers the schema from scratch. But the data dictionary is also one of the most *confused* terms in data management - routinely conflated with a [business glossary](https://www.dawiso.com/glossary/what-is-a-business-glossary) and a [data catalog](https://www.dawiso.com/glossary/data-catalog), which are related but distinct. Getting the distinction right is the key to understanding where each belongs.

TL;DR

A **data dictionary** is a technical reference describing an organization's data elements - column names, data types, formats, constraints, and relationships. It is *technical metadata* at the field level. It differs from a **[business glossary](https://www.dawiso.com/glossary/what-is-a-business-glossary)** (which defines *business terms* in plain language) and a **[data catalog](https://www.dawiso.com/glossary/data-catalog)** (which inventories *all* data assets across systems and links the other two together). Dictionaries can be **active** (managed live by the DBMS) or **passive** (a standalone document that drifts from reality). In modern stacks the dictionary is increasingly a layer *within* the catalog, kept current automatically.

## Data Dictionary Defined

A data dictionary is a collection of metadata that describes the structure and meaning of data elements within a database or system. It operates at the most granular, technical level of the data - the individual field - and is primarily used by the people who build and query systems: data engineers, database administrators, developers, and analysts.

Its defining characteristics:

- **Technical and granular** - It describes data at the table and column level: types, lengths, formats, keys, and constraints.
- **Structure-focused** - Its concern is how data is defined and organized, not what a business concept means.
- **System-scoped** - Traditionally it documents a specific database or system rather than the whole organization.
- **Reference-oriented** - It is a lookup tool used during design, development, integration, and analysis.

## What a Data Dictionary Contains

A typical data dictionary entry, for each data element, captures:

- **Name** - the field or column name (e.g. `customer_id`).
- **Data type & format** - integer, varchar(50), date, boolean, and so on.
- **Description** - what the element represents.
- **Allowed values & constraints** - ranges, enumerations, NOT NULL, uniqueness.
- **Keys & relationships** - primary and foreign keys, and how the element relates to others.
- **Source & default** - where the value originates and any default.

Together these let anyone working with the system understand a field without reverse-engineering it from the data.

## Dictionary vs Glossary vs Catalog

This is the distinction that causes the most confusion - and the most useful thing to get straight. The three are complementary layers, not competitors.

- **Data dictionary** - *technical* metadata. Describes the fields: `customer_id` is an integer, primary key, not null. Answers "what is this column?"
- **[Business glossary](https://www.dawiso.com/glossary/what-is-a-business-glossary)** - *business* metadata. Defines concepts in plain language: an "active customer" is one who purchased in the last 90 days. Answers "what does this term mean?"
- **[Data catalog](https://www.dawiso.com/glossary/data-catalog)** - the *inventory*. Lists all data assets across every system, makes them discoverable, and links the technical fields (dictionary) to the business meaning (glossary). Answers "what data do we have, and where?"

The relationship is layered: the glossary term "active customer" maps to specific columns documented in the dictionary, and the catalog is where you discover both and see how they connect. A dictionary without a glossary tells you the *how* but not the *what for*; a glossary without a dictionary defines meaning with nothing to anchor it to. You need all three, which is why modern platforms unify them.

## Active vs Passive Data Dictionaries

Data dictionaries come in two forms, distinguished by how they stay accurate:

- **Active data dictionary** - managed by the database management system itself and updated automatically when the schema changes. It is always in sync with reality because it *is* part of the system.
- **Passive (or standalone) data dictionary** - maintained separately, often in a spreadsheet or document, by hand. It is easy to create but drifts out of date the moment the schema changes and no one updates the file - the most common failure mode of traditional dictionaries.

The drift problem with passive dictionaries is exactly why the function has migrated into automated [metadata management](https://www.dawiso.com/glossary/metadata-management) and data catalogs, which harvest technical metadata directly from source systems and keep the dictionary current without manual upkeep - closer to [active metadata](https://www.dawiso.com/glossary/active-metadata) than a static document.

## Why It Matters

A data dictionary, properly maintained, delivers concrete value - and in a modern stack it does so as part of a governed [catalog](https://www.dawiso.com/glossary/data-catalog) rather than a forgotten spreadsheet:

- **Shared understanding.** Everyone interprets a field the same way, eliminating the "which definition of revenue?" class of error.
- **Faster onboarding and analysis.** New team members and analysts understand the schema without reverse-engineering it.
- **Safer change.** Documented relationships and constraints make the impact of schema changes visible before they break downstream systems - reinforced by [lineage](https://www.dawiso.com/glossary/data-lineage).
- **A foundation for governance and AI.** Reliable technical metadata is what lets a [glossary](https://www.dawiso.com/glossary/what-is-a-business-glossary), quality rules, and AI tools reason about data correctly.

This is where Dawiso brings the three layers together: the data dictionary's technical metadata, the business glossary's meaning, and the catalog's inventory in one governed place - harvested automatically so the dictionary never drifts. The dictionary tells you how the data is stored; the glossary tells you what it means; the catalog ties them to everything else. Separately they are useful; together they are how an organization actually understands its data.

## Conclusion

A data dictionary is the field-level technical truth about your data - the precise definitions of every column that make systems intelligible to the people who build and query them. Its enduring lesson is that technical metadata only delivers value when it stays accurate and is connected to business meaning. On its own, a hand-maintained dictionary drifts into fiction; embedded in a governed catalog alongside a business glossary, it becomes part of a complete, trustworthy picture of what your data is and what it means.

[See it in action](https://www.dawiso.com/product/business-glossary)

Business Glossary

Clear context is essential to ensure everyone interprets terms consistently and accurately.

### Table of contents

Data Dictionary DefinedWhat It ContainsDictionary vs Glossary vs CatalogActive vs PassiveWhy It Matters

## Related Terms

### [What Is Metadata? Definition, Types, and Examples](https://www.dawiso.com/glossary/metadata)

Metadata is data about data: what it describes, the main types of metadata with examples, and why business and technical metadata matter for AI.

Read more →

### [What Is Data Discovery?](https://www.dawiso.com/glossary/data-discovery)

Data discovery is the process of finding, understanding, and evaluating data assets across an organization. Learn how modern data catalogs automate discovery, the role of metadata, and why discoverability is the foundation of data-driven culture.

Read more →

### [What Is a Data Ecosystem?](https://www.dawiso.com/glossary/data-ecosystem)

A data ecosystem is the connected set of tools, platforms, data, people, and processes that collect, store, manage, and use an organization's data. Learn its layers.

Read more →

### [What Is OpenMetadata? Open-Source Data Catalog Explained](https://www.dawiso.com/glossary/what-is-openmetadata)

OpenMetadata is an open-source metadata platform for data cataloging, lineage, and governance. Learn how it works, its architecture, and where it fits.

Read more →

### [What Is a Data Catalog?](https://www.dawiso.com/glossary/data-catalog)

Learn what a data catalog is, how it works, and why it's the foundation of modern data governance.

Read more →

### [Data Catalog Pricing Compared for 2026](https://www.dawiso.com/glossary/data-catalog-pricing)

Data catalog pricing compared from public sources. Marketplace list prices for Atlan, Alation, and Collibra, Purview usage rates, open source, and Dawiso.

Read more →
