KM_Pres_PA_Ch7_update_fall_05

KM_Pres_PA_Ch7_update_fall_05 - Chapter 7 Project Q& A...

Info iconThis preview shows pages 1–7. 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: Chapter 7 Project Q & A Functions of a DBMS Functions Data storage, retrieval and update User accessible catalog Management of shared/concurrent update Provision for backup and recovery Provision for security Integrity services Support of data independence Support for replication Utilities What most users think of when using a database How is this done in Oracle? Data Storage, Retrieval and Update User Accessible Catalog Crucial information for understanding a database Also called metadata Also called a data-dictionary How does Oracle do this? Oracle’s Approach Data dictionary is actually views based on underlying tables called system tables Systems tables hold data about tables, rows, views, columns, security, users, permissions, and other things… Oracle 8i has over 900 views! Most are used internally by Oracle for optimization but some are useful to you Warning: Don’t mess with these tables All_catalog All_users Dba_free_space User_tab_privs_made User_tab_privs_recd User_constraints Oracle’s Approach (cont) The table names will usually start with DBA, USER, ALL, SYS Select table_name from all_synonyms Where table_name like ’USER%’;...
View Full Document

This note was uploaded on 04/16/2008 for the course BA 105W taught by Professor Mohle during the Spring '08 term at CSU Fresno.

Page1 / 19

KM_Pres_PA_Ch7_update_fall_05 - Chapter 7 Project Q& A...

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