Codd's 4th Rule

Codd's 4th Rule - Codds 4th Rule: Dynamic Catalog Rule...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Codd’s 4 th Rule: Dynamic Catalog Rule Presented By: Suneel R D R L Rao Sheetal Chauhan Nirav Patel Kushal E Pavan
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Definition It states that a relational database should be self describing
Background image of page 2
Codd’s 4 th rule (contd. .) Need for self description Storage of structural information System catalog Tables in RDBMS - User table - System table
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Codd’s 4 th rule (contd. .) Collection of system tables - System catalog or data dictionary Owned , created and maintained by DBMS itself Contains data that describes structure of the database (metadata)
Background image of page 4
Codd’s 4 th rule (contd. .) Automatically created when database is created System catalog is read only Accessed in the same manner as user table
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
METADATA Example: Dictionary DICTIONARY COMMENTS ALL_THE_TABLES Description of all objects and relations ALL_ARGUMENTS Argument in object accessible to the user ALL_ASSOCIATIONS All associations available to user ALL_AUDIT_POLICIES All fine grained policies in the database
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

Codd's 4th Rule - Codds 4th Rule: Dynamic Catalog Rule...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online