March 2022
Intermediate to advanced
682 pages
22h 58m
English
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.
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 ...