Ideal data dictionary, Database Management System

An ideal data dictionary should have everything a DBA wants to know about the database.

1 Conceptual, External, and internal database descriptions.

2.    Descriptions of attributes (fields), entities (record types) as well as origin, cross- references and meaning of data elements.

3. Authorisation ,Synonyms and security codes.

4. Which external schemas are used by which programs, what their authorisations are, and who the users are.

5.  Statistics about database and its usage containing number of records, etc.

A data dictionary is executed as a database so that users can query its contents. The cost efficiency of a data dictionary increases as the difficulty of an information system increases. A data dictionary can be an enormous asset not only to the DBA for database design, execution and maintenance, but also to managers or end users in their project planning.

Posted Date: 3/6/2013 5:02:41 AM | Location : United States







Related Discussions:- Ideal data dictionary, Assignment Help, Ask Question on Ideal data dictionary, Get Answer, Expert's Help, Ideal data dictionary Discussions

Write discussion on Ideal data dictionary
Your posts are moderated
Related Questions
All edges of a cube are expanding at a rate of 6 centimeters per second. How fast is the surface area changing when each edge is (a) 2 centimeters and (b) 10 centimeters?

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

ERD Diagram of Medical Recruitment Agency?

Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

WHERE and HAVING clause in SQL ? The WHERE clause is commonly used for implementing conditions on each tuple of the relation. The HAVING clause is used in combination along wi

What is abstraction? Abstraction in the object orientation is a idea that provide opportunity to express necessary properties of object without providing much details of the im


1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict


what are information system hirarchy?