data dictionary
data dictionary Essentially a dictionary of the names used in the specifying documentation and programs for a data-processing application or group of related applications. Against each entry there would typically be the type of object being named (that is, whether it is a data item or field, record, file, report, screen display, etc.), its precise specification, some explanatory description of its use, and a reference to all places in the documentation and programs where it is used.
Developed in the late 1960s the purpose of such a dictionary was originally simply to assist in the maintenance of large-scale data-processing systems. The idea was further developed in the 1970s with the advent of special-purpose software systems to maintain such dictionaries, having features such as the automatic regeneration of Cobol data divisions as necessary when changes were made. These systems have evolved to include databases with features such as automatic DDL generation (see database language).
For large-scale and complex systems a data dictionary is a vital tool for the central control of naming, and of the semantics and syntax of the system. It is a tool widely used in database administration and increasingly to assist in the broader task of system design, many design methodologies being founded on the use of a data dictionary. The terms system dictionary and data directory may be used synonymously in the case of the more ambitious software-based dictionary systems.
The term data dictionary is sometimes used misleadingly by software product vendors to refer to the alphabetical listings of names automatically produced when database schema and data manipulation coding is being processed and compiled, and it is important not to confuse this use with the accepted technical meaning of the term.
Developed in the late 1960s the purpose of such a dictionary was originally simply to assist in the maintenance of large-scale data-processing systems. The idea was further developed in the 1970s with the advent of special-purpose software systems to maintain such dictionaries, having features such as the automatic regeneration of Cobol data divisions as necessary when changes were made. These systems have evolved to include databases with features such as automatic DDL generation (see database language).
For large-scale and complex systems a data dictionary is a vital tool for the central control of naming, and of the semantics and syntax of the system. It is a tool widely used in database administration and increasingly to assist in the broader task of system design, many design methodologies being founded on the use of a data dictionary. The terms system dictionary and data directory may be used synonymously in the case of the more ambitious software-based dictionary systems.
The term data dictionary is sometimes used misleadingly by software product vendors to refer to the alphabetical listings of names automatically produced when database schema and data manipulation coding is being processed and compiled, and it is important not to confuse this use with the accepted technical meaning of the term.
More From encyclopedia.com
Data Warehousing , Data warehousing refers to the organization and assembly of data created from day-to-day business operations. Data warehousing enables a user to retr… Data , Data
The word data (singular, datum ) is originally Latin for “things given or granted.” Because of its humble and generic meaning, the term enjoys c… data communications , data communications The collection and redistribution of information (data) through communication channels. Data communications may involve the trans… Database Administration , Database administration is simply maintaining records of any type—customer lists, vendor histories, or addresses, for example—using computer software… Sql , Databases are designed, built, and populated with data for a specific purpose and for an intended group of users. Databases are built for many differ… Data Mining , Data mining is the process of discovering potentially useful, interesting, and previously unknown patterns from a large collection of data. The proce…
You Might Also Like
NEARBY TERMS
data dictionary