2.4 Design Tools

Many methodologies exist that can make the database design process easier for both designers and users. They vary from general techniques described in the systems analysis and software engineering literature to commercial products to automate the design process.

2.4.1 Data Dictionary

A DBMS system catalog, sometimes called a data directory, active data dictionary, or integrated data dictionary, as discussed in Section 2.2.2, is a repository of information about the logical structure of the database. It contains metadata, or data about the data in the database. It has entries for all the types of objects that exist in the database. A system catalog is always consistent with the actual database structure because it is maintained ...

Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.