nam a22 7a 4500 7940 7940 OSt 20200309115201.0 190826b xxu||||| |||| 00| 0 eng d 9789350164891 AEF 23rd ed. 658.403 BHA 1051 Bharti, R. Text book of relational database management system: Computer science (CS-202): paper-II, Sem-II According to new CBCS revised syllabus w.e.f. 2019-2020 1st ed. Pune: vision publication, 2019. 210 p. : 25 cm Contents 1.Relational Database Design Using PLSQL 1. Introduction to PL/SQL 2. PL/PgSQL 3. Controlling the Program Flow, Conditional Statements, Loops 4. Stored Procedures 5. Stored Functions 6. Handling Errors and Exceptions 7. Cursors 8. Triggers 2. Transaction Concepts and Concurrency Control 1. Introduction 2. Describe a Transaction, Properties of Transaction, State of the Transaction 3. Executing Transactions Concurrently Associated Problem in Concurrent Execution 4. Schedules, Types of Schedules, Concept of Serializability, Precedence Graph of Serializability 5. Ensuring Serializability by Locks, Different Lock Modes,2PL and its Variations 6. Basic Timestamp Method for Concurrency, Thomas Write Rule 7. Locks with Multiple Granularity, Dynamic Database Concurrency (Phantom Problem) 8. Timestamps Versus Locking 9. Deadlock and Deadlock Handling-Deadlock Avoidance (wait-die, wound-wait) 10.Deadlock Avoidance (Wound-Wait, Wait-die) 11.Deadlock Detection and Recovery (Wait For Graph) 3. Database Integrity and Security Concepts 1. Introduction 2. Domain Constraints 2 3. Referential Integrity 4. Introduction to Database Security Concepts 5. Methods of Database Security 6. Use of Views in Security Enforcement 7. Overview of Encryption Technique for Database 8. Statistical Database Security 4. Crash Recovery 1. Introduction 2 2. Failure Classification 3. Recovery Concepts 4. Log Based Recovery Techniques (Deferred and Immediate Update) 5. Checkpoints, Relationship between Database Manager and Buffer Cache. Aries recovery Algorithm 6. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit) 7. Database Backup and Recovery from Catastrophic Failures 5. Other Databases 1. Introduction to Parallel and Distributed Databases 2. Introduction to Object Based Databases 3. XML databases 4. NoSQL Databases 5. Multimedia Databases 6. Big Data Databases Relational databases 1325 Management information systems 1326 File organization (Computer science) 599 Bhat, V. 1124 ddc BK 0 0 ddc 0 0 AEF AEF 2020-03-03 Bill No. : 1766 dated 01-03-2020 138.75 4 0 658.403 BHA 5141 2025-07-07 2025-07-07 1 185.00 2020-03-09 BK 0 0 ddc 0 0 AEF AEF 2020-03-03 Bill No. : 1766 dated 01-03-2020 138.75 2 658.403 BHA 5142 2023-07-25 2023-04-28 2 185.00 2020-03-09 BK 0 0 ddc 0 0 AEF AEF 2020-03-03 Bill No. : 1766 dated 01-03-2020 138.75 4 0 658.403 BHA 5143 2024-02-06 2024-02-06 3 185.00 2020-03-09 BK 0 0 ddc 0 0 AEF AEF 2020-03-03 Bill No. : 1766 dated 01-03-2020 138.75 4 0 658.403 BHA 5144 2024-01-08 2024-01-08 4 185.00 2020-03-09 BK 0 0 ddc 0 0 AEF AEF 2020-03-03 Bill No. : 1766 dated 01-03-2020 138.75 2 0 658.403 BHA 5145 2024-01-08 2024-01-08 5 185.00 2020-03-09 BK