Data Dictionaries数据字典.pptVIP

* * * * * Data Dictionaries CSCI 4127/5127 Database Advanced Topics Overview What Is a Data Dictionary? How Does the DBMS Use a Data Dictionary? How Do You Use a Data Dictionary? What Is In a Data Dictionary? Oracle’s Data Dictionary? What Is a Data Dictionary? Contains information about the structures in the database Also called System Catalog Strictly speaking this is what Oracle has Meta Data Generic term, for data about data Data Repository Synonym for Data Dictionary used to imply stand-alone systems According to Codd an RDB MUST use tables for its Data Dictionary How Does the DBMS Use a Data Dictionary? Security Integrity View Definition Parsing SQL Optimizing SQL How Do You Use a Data Dictionary? By the DBA Who built what when Who gave you access to this item and when By the programmer Checking information when building programs Building self adapting code Documenting the database layout What Is In a Data Dictionary? Each “object” in the database Tables, Views,Types, Procedures, Functions, Columns … Who created it Its Definition What it uses What uses it Oracle’s Data Dictionary Tables For details see Loney, Chapter 45 Palinski, Chapter 3 (older text) Elmasri Navathe, Chapter 17 (older text) Three types of views of the meta data USER (created by this user) ALL (accessible to this user) USER is those tuples in ALL where owner = current user DBA (accessible only to persons with DBA privileges) Average User User All DBA (Cannot be viewed) DBA User User All and DBA are the same and visible An example: User_Tables (7 items): BRANCH STAFF PROPERTYFORRENT CLIENT