02704nam a22002177a 4500003000400000005001700004008004100021020001800062040000800080082003000088100001500118245015800133250001200291260003800303300002000341501201100361650002502372650003502397650004102432700001302473OSt20200309115201.0190826b        xxu||||| |||| 00| 0 eng d  a9789350164891  cAEF  223rd  ed. a658.403	bBHA1 aBharti, R.10aText book of relational database management system:bComputer science (CS-202): paper-II, Sem-IIcAccording to new CBCS revised syllabus w.e.f. 2019-2020  a1st ed.  aPune:bvision publication,c2019.  a210 p. :c25 cm  aContents

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  aRelational databases  aManagement information systems  aFile organization (Computer science)10aBhat, V.