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:

Chandalleers
1. Really big, swinging balls. Dammit Andy, get your chandalleers off my shoulder. His Chandalleers were a hit at the reception. See bal..
Read more
Gagnéd
1. To be screwed over by someone who you once had trust in. Alex told AJ to take Beth home after the party, and he ended up banging her in..
Read more
Qwertacious
1. 1. (adj.) Of or relating to qwerty. 2. Awesome in a random or unexplainable way. 3. In reference to a Qwerteaen fictional animal, eg. ..
Read more

Best StartPage for your browser.

All you need for a faster workflow in one place.



Get it for Free