Glossary: An Essential Tool for Database Design and Standardization

Definition

A glossary is a document or dictionary that clearly defines and standardizes the meaning of terms used in database design and data standardization. Its purpose is to unify the names of entities (tables) and attributes (columns) to prevent confusion and to ensure consistent use of English names.

Related Terms

• Entity: A unit of information stored in a database, corresponding to a table.
• Attribute: An element that represents a characteristic of an entity, corresponding to a column in a table.
• Standard Word Dictionary: Used in the process of extracting, classifying, and standardizing words from existing data models and glossaries.

Practical Use Cases

• In corporate database design, a glossary is used to clearly define the names of entities and attributes, facilitating smooth communication across departments.
• Public institutions manage technical terminology through standardized terminology dictionaries and promote the localization of foreign terms through official terminology services.

Etymology and Background

The concept of the glossary emerged as databases grew more complex. As consistency of terminology became important in database design, a systematic document was needed to manage it.

FAQ

1. Why is a glossary important? A glossary prevents terminological confusion during database design and standardization and supports smooth communication across departments.

2. What types of glossaries are there? There are standardized technical terminology dictionaries and public terminology services, each supporting the standardization of specialized and public terminology respectively.

3. How is a glossary structured? A glossary includes the definition, category, type, English name, and abbreviation of each term, and handles synonyms and homonyms.

Additional Information

• Standard Terminology Dictionary
• Public Terminology Service

A glossary is an essential tool for database design and standardization, supporting efficient data management and communication through the clear definition and standardization of terms.