RELATIONAL DATABASE MANAGEMENT SYSTEM

माहिती

प्रस्तावना

1. Introduction To RDBMS
1.1 Introduction
1.2 Introduction to popular RDBMS product and their features
1.3 Difference between DBMS and RDBMS
1.4 Relationship among application programs, RDBMS
2. PL / SQL
2.1 Overview of PL/SQL
2.2 Data types
2.3 PL/SQL block
2.4 Exceptional handling
2.5 Functions, procedures
2.6 Cursor
2.7 Database triggers
2.8 Oracle packages
3. Transaction Management
3.1 Transaction concept
3.2 Transaction properties:
3.3 Transaction states
3.4 Concurrent execution
3.5 Serializability
3.6 Recoverability
4. Concurrency Control
4.1 Concurrency control
4.2 Lock based protocols
4.3 Timestamp - based protocols
4.4 Validation - based protocols
4.5 Deadlock handling
5. Recovery System
5.1 Introduction
5.2 Failure classification
5.3 Storage structure
5.4 Recovery and atomicity
5.5 Recovery with concurrent transactions
5.6 Remote backup systems

शैक्षणिक माहिती