Data dictionary management. The DBMS stores definitions of the data elements and their relationships (metadata)
in a data dictionary. In turn, all programs that access the data in the database work through the DBMS.
The DBMS uses the data dictionary to look up the required data component structures and relationships,
thus relieving you from having to code such complex relationships in each program. Additionally, any changes
made in a database structure are automatically recorded in the data dictionary, thereby freeing you from having
to modify all of the programs that access the changed structure. In other words, the DBMS provides data
abstraction, and it removes structural and data dependence from the system. For example, Figure 1.10 shows
how Microsoft SQL Server Express presents the data definition for the CUSTOMER table.
Data dictionary management. The DBMS stores definitions of the data elements and their relationships (metadata)
in a data dictionary. In turn, all programs that access the data in the database work through the DBMS.
The DBMS uses the data dictionary to look up the required data component structures and relationships,
thus relieving you from having to code such complex relationships in each program. Additionally, any changes
made in a database structure are automatically recorded in the data dictionary, thereby freeing you from having
to modify all of the programs that access the changed structure. In other words, the DBMS provides data
abstraction, and it removes structural and data dependence from the system. For example, Figure 1.10 shows
how Microsoft SQL Server Express presents the data definition for the CUSTOMER table.
การแปล กรุณารอสักครู่..
