Data Dictionary

What is Data Dictionary?

1.

A data dictionary is (generally) a read-only set of tables and views that holds metadata - used in a database management system. The data dictionary may be considered a database in its own right.

Amongst other things, a Data Dictionary holds the following information:

* Usernames, Roles and Privileges

*Schema Objects

*IntegrityConstraints

*Stored procedures and Triggers

*General Database Structure

*Audit information

*Space allocations

One benefit of a well prepared data dictionary is a consistency between data items across different tables.

several tables may hold telephone numbers, using a data dictionary the format of this telephone number field will be consistent.
17

Random Words:

Quadracasting
1. TO BROADCAST ON 4 DIFFERENT BLOG VIDEO SITES AT ONCE THIS MORNING I AM QUADRACASTING ON BLOGTV, JUSTINTV, LIVESTREAM AND USTREAM. 1. ..
Read more
J-dar
1. An uncanny ability to identify members of the tribe. Like gaydar but for Jews. You'd have to have great j-dar to know Paul Newman ..
Read more
Umass Darty
1. Slang for University of Massachusetts Dartmouth, may also be referred to as "Darty" "Sorry, I cannot go to the party ton..
Read more

Best StartPage for your browser.

All you need for a faster workflow in one place.



Get it for Free