Theme Options

NEWSLETTER

Relational Database Management System

1667

New

According to New Revised Syllabus

Relational Database Management System

SY BSc Computers Sem-I

Author : Reena Bharthi. Vandana Babrekar

Book ID : 1667

ISBN : 978-93-5016-324-5

More details

Rs.113

Rs.125

-10%

Contents 

1. Relational Database Design

1. Introduction  

2. Pitfalls in Relational-Database Design

3. Functional Dependencies   

4. Canonical Cover     

5. Decomposition 

6. Multivalued dependencies  

7. PL/PGSQL

8. Stored Functions in PL/pgSQL    

9. Controlling Program Flow  

10. Handling Errors and Exceptions 

11. Cursors, Views and Triggers    

2. Transaction Concepts and Concurrency Control

1.  Introduction 

2.  Transaction Concepts     

3.  Executing Transactions Concurrently Associated Problem in Concurrent Execution 

4.  Schedules of Transaction 

5.  Ensuring Serializability by Locks    

6.  Basic Timestamp Method for Concurrency     

7.  Locks with Multiple Granularity

8.  Timestamps Versus Locking

9.  Deadlock Handling Methods

10. Deadlock Detection and Recovery (Wait For Graph) 

11. Prevention Algorithms(Wound-Wait, Wait-die)

3. Database Integrity and Security Concepts    

1. Introduction  

2. Domain Constraints  

3. Referential Integrity     

4. Database Security Concepts

5. Methods of Database Security    

6. Discretionary Access Control Method   

7. Mandatory Access Control Method 

8. Uses of Views in Security Enforcement 

9. Overview of Encryption Technique for Database     

10. Statistical Database Security  

4. Crash Recovery

1. Introduction  

2. Failure Classification    

3. Recovery Concepts   

4. Log Based Recovery Techniques (Deferred and Immediate Update) 

5. Checkpoints   

6. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit)     

7. Database Backup and Recovery from Catastrophic Failures 

8. Shadow Paging 

5. Client Server Technology  

1. Introduction  

2. Describe Client-Server Technology / Computing     

3. Evolution of Client Server Information Systems    

4. Client Server Architecture Benefits   

5. Client Server Architecture

No customer comments for the moment.

Write a review

Write a review

10 other products in the same category: