03646nam a22003017a 4500999001500000003000400015005001700019008004100036020001800077040000800095082003000103100002100133245015800154250001200312260003800324300002000362501201100382650003102393650004102424650004602465700001902511942001202530952016102542952015802703952016102861952016103022952016103183  c7940d7940OSt20200309115201.0190826b        xxu||||| |||| 00| 0 eng d  a9789350164891  cAEF  223rd  ed. a658.403	bBHA1 91051aBharti, R.10aText book of relational database management system:bComputer science (CS-202): paper-II, Sem-IIcAccording 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91325  aManagement information systems91326  aFile organization (Computer science)959910aBhat, V.91124  2ddccBK  00102ddc4070aAEFbAEFd2020-03-03eBill No. : 1766 dated 01-03-2020g138.75l4m0o658.403	 BHAp5141r2025-07-07s2025-07-07t1v185.00w2020-03-09yBK  00102ddc4070aAEFbAEFd2020-03-03eBill No. : 1766 dated 01-03-2020g138.75l2o658.403	 BHAp5142r2023-07-25s2023-04-28t2v185.00w2020-03-09yBK  00102ddc4070aAEFbAEFd2020-03-03eBill No. : 1766 dated 01-03-2020g138.75l4m0o658.403	 BHAp5143r2024-02-06s2024-02-06t3v185.00w2020-03-09yBK  00102ddc4070aAEFbAEFd2020-03-03eBill No. : 1766 dated 01-03-2020g138.75l4m0o658.403	 BHAp5144r2024-01-08s2024-01-08t4v185.00w2020-03-09yBK  00102ddc4070aAEFbAEFd2020-03-03eBill No. : 1766 dated 01-03-2020g138.75l2m0o658.403	 BHAp5145r2024-01-08s2024-01-08t5v185.00w2020-03-09yBK