Data dictionary is the centralized and structured source of information about a database table. It’s a logical layer situated over the database.
Data Dictionary does not contains the data like Emp name, Addresses etc but rather a type of data whose function is to define the properties of data such as type, length and relationship.
Advantages of data dictionary.
1. It helps in maintaining consistency of data when used in different applications.
2. A data type assigned to data dictionary can be available to any program in that application.
3. Data dictionary is a fast and efficient way to answer questions such as which entries exists in
Data Dictionary does not contains the data like Emp name, Addresses etc but rather a type of data whose function is to define the properties of data such as type, length and relationship.
Advantages of data dictionary.
1. It helps in maintaining consistency of data when used in different applications.
2. A data type assigned to data dictionary can be available to any program in that application.
3. Data dictionary is a fast and efficient way to answer questions such as which entries exists in
a table of the database, what is the structure of table.
Objects of Data Dictionary
1.Data Base Tables
Objects of Data Dictionary
1.Data Base Tables
2.Views
3. Structures
4. Data Elements
5. Domains
6. Search helps
7. Lock objects
8. Primary Key and Foreign Key
9.Table Maintenance Generator
nice work dada.. keep it up..
ReplyDeletenice work dada.. keep it up..
ReplyDeletehey basu !!! its informative !! :-)
ReplyDeletethanks..
ReplyDelete