Business Glossary vs Data Dictionary
People think a business glossary and a data dictionary are the same list. A glossary explains business words, like active customer, in plain words. A data dictionary lists the columns in a table. It gives each one a type and a unit. One says what a word means. The other says where it is kept.
Business Glossary
A shared list of what a company's key words mean.
A business glossary is a shared list of a company's key words and what each one means. It defines terms like active customer, churn or net revenue in plain language. Each term has an owner who agrees the meaning. Terms are linked to the tables and columns that hold them. It is about meaning, not about the data's structure.
Data Dictionary
A list of each column in a table and what it means.
A data dictionary lists every column in a set of tables, so people know what each one holds. For each one, it gives the name, the type and what it means. It also lists the values that are allowed, the units and whether a blank is fine. Analysts read it before they use a table they do not know. A business glossary defines words. A data dictionary defines columns.
In one line
- Business Glossary
- A shared list of what a company's key words mean.
- Data Dictionary
- A list of each column in a table and what it means.