metadata - CSE 412/598 DATABASE MANAGEMENT COURSE NOTES 11....

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CSE 412/598 DATABASE MANAGEMENT COURSE NOTES 11. METADATA/ SYSTEM CATALOG Department of Computer Science & Engineering Arizona State University CSE 412/598 Metadata 2 METADATA .... stores descriptions of the DB that the DBMS maintains meta-data conceptual schema internal schema external schemas mapping between schemas query optimization info security and authorization info CSE 412/598 Metadata 3 SYSTEM CATALOG vs. DATA DICTIONARY System Catalog main purpose is to store metadata for use by the DBMS Data dictionary stand-alone software package mainly used for information resource management including system documentation. Assume that the dictionary is active (used by the DBMS); otherwise passive CSE 412/598 Metadata 4 RELATIONAL DBMS catalog stored as relations and DBMS used to query and maintain catalog Examples : rel-and-attr-catalog (RELNAME, ATTRNAME , ATTRTYPE PKMEMBER, FKMEMBER, FKREL) view_queries (VIEWNAME , QUERY) view_attrs (VIEWNAME, ATTRNAME , ATTRNUM) NOTE: Trade-off between generality and efficiency using the DBMS to store information about the DBMS. CSE 412/598 Metadata 5 CATALOG ACCESS DDL Compiler: stores the database description in the catalog...
View Full Document

Page1 / 11

metadata - CSE 412/598 DATABASE MANAGEMENT COURSE NOTES 11....

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

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