Data Dictionary Gordon A. Russell（数据字典戈登·a·罗素）.pdfVIP

Data Dictionary Data Dictionary Unit 5.3 Unit 5.3 Dr Gordon Russell, Copyright Unit 5.3 - Data Dictionary 1 Dr Gordon Russell, Copyright Unit 5.3 - Data Dictionary 1 @ Napier University @ Napier University Data Dictionary A tool for recording and processing information (metadata) about the data that an organisation uses. A central catalogue for metadata. Can be integrated within the DBMS or be separate. May be referenced during system design, programming, and by actively-executing programs. Can be used as a repository for common code (e.g. library routines). Dr Gordon Russell, Copyright Unit 5.3 - Data Dictionary 2 Dr Gordon Russell, Copyright Unit 5.3 - Data Dictionary 2 @ Napier University @ Napier University Benefits of a DDS Benefits of a DDS are mainly due to the fact that it is a central store of information about the database. Benefits include - improved documentation and control consistency in data use easier data analysis reduced data redundancy simpler programming the enforcement of standards better means of estimating the effect of change. Dr Gordon Russell, Copyright Unit 5.3 - Data Dictionary 3 Dr Gordon Russell, Copyright Unit 5.3 - Data Dictionary 3 @ Napier University @ Napier University DDS Facilities A DDS should provide two sets of facilities: To record and analyse data requirements independently of how they are going to be met - conceptual data models (entities, attributes, relationships). To record and design decisions in terms of database or file structures implemented and the programs which access them - internal schema. One of the main functions of a DDS is to show the relationship between the conceptual and im