Kudale, G. A.
Textbook of relational database: Computer science (CS-202): paper-II According to new CBSC syllabus w. e. f. 2019-20 - 1st ed. - Pune: Vision publications, 2019. - 176 p. : 25 cm
Contents
1. Introduction to RDBMS
1. Introduction
2. Introduction to Popular RDBMS Product and their Features
3. Difference between DBMS and RDBMS
4. Relationship among Application Programs and RDBMS
2. PL-SQL
1. Overview of PL/SQL
2. Data Types
3. PL/SQL Block
4. Exceptional Handling
5. Functions, Procedures
6. Cursor
7. Database Triggers
8. Oracle Packages
3. Introduction to RDBMS
1. Transaction Concept
2. Transaction Properties
3. Transaction States
4. Concurrent Execution
5. Serializability
4. Concurrency Control and Recovery System
1. Concurrency Control
2. Lock Based Protocols
3. Timestamp-Based Protocols
4. Validation-Based Protocols
5. Deadlock Handling
6. Recovery System
7. Failure Classification
8. Storage Structure
9. Recovery and Atomicity
10.Recovery with Concurrent Transactions
11.Remote Backup Systems
Relational databases
Management information systems
File organization (Computer science)
658.403 / BHA
Textbook of relational database: Computer science (CS-202): paper-II According to new CBSC syllabus w. e. f. 2019-20 - 1st ed. - Pune: Vision publications, 2019. - 176 p. : 25 cm
Contents
1. Introduction to RDBMS
1. Introduction
2. Introduction to Popular RDBMS Product and their Features
3. Difference between DBMS and RDBMS
4. Relationship among Application Programs and RDBMS
2. PL-SQL
1. Overview of PL/SQL
2. Data Types
3. PL/SQL Block
4. Exceptional Handling
5. Functions, Procedures
6. Cursor
7. Database Triggers
8. Oracle Packages
3. Introduction to RDBMS
1. Transaction Concept
2. Transaction Properties
3. Transaction States
4. Concurrent Execution
5. Serializability
4. Concurrency Control and Recovery System
1. Concurrency Control
2. Lock Based Protocols
3. Timestamp-Based Protocols
4. Validation-Based Protocols
5. Deadlock Handling
6. Recovery System
7. Failure Classification
8. Storage Structure
9. Recovery and Atomicity
10.Recovery with Concurrent Transactions
11.Remote Backup Systems
Relational databases
Management information systems
File organization (Computer science)
658.403 / BHA