|
Course Keywords:
DBMS architecture and administration; Centralized and Client-Server approaches, System Catalog, Data Dictionary. Transaction management; Transactions: concepts, characteristics. Recovery techniques, Concurrency control techniques: Serializability, Deadlock, Locking schemes, Time-stamp ordering, Multi-version, Optimistic techniques; DB security; Distributed databases; Distributed DBMS, Data fragmentation and replication, Distributed transactions management. Object-Oriented databases. Introducing to new emerging DB technologies and applications; Web DBs, Multimedia DBs, Data Warehousing and Data Mining, etc. The lab covers all the issues of DBA, including installation, configuration, operation, optimization, user management, recovery and backup, etc. A well known DBMS is selected to allow real experiences for students.
|
|
Text Book:
R. Elmasri; S. Navathe; Fundamentals of Database systems; 3rd ed.; 2000، Addison Wesley.
OCP Orcle 9i , DBA Fundementals , Biju Thomas & Bob Bryla , Sybex Inc 2002 ( For DBMS Lab )
|