Data Dictionary Storage

Data Dictionary Storage - o Type of index 3 This...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Dictionary Storage 1. The database also needs to store information about the relations, known as the data dictionary . This includes: o Names of relations. o Names of attributes of relations. o Domains and lengths of attributes. o Names and definitions of views. o Integrity constraints (e.g., key constraints). plus data on the system users: o Names of authorized users. o Accounting information about users. plus (possibly) statistical and descriptive data: o Number of tuples in each relation. o Method of storage used for each relation (e.g., clustered or non-clustered). 2. When we look at indices (Chapter 11), we'll also see a need to store information about each index on each relation: o Name of the index. o Name of the relation being indexed. o Attributes the index is on.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: o Type of index. 3. This information is, in itself, a miniature database. We can use the database to store data about itself, simplifying the overall structure of the system, and allowing the full power of the database to be used to permit fast access to system data. 4. The exact choice of how to represent system data using relations must be made by the system designer. One possible representation follows. 5. aaaaaaaaaaaa¯ System-catalog-schema = (relation-name, number-attrs) 6. 7. Attr-schema = (attr-name, rel-name, domain-type, position, length) 8. 9. User-schema = (user-name, encrypted-password, group) 10. 11. Index-schema = (index-name, rel-name, index-type, index-attr) 12. 13. View-schema = (view-name, definition) 14....
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Ask a homework question - tutors are online