On sale! -10%

Database Management Systems

₹207.00
₹230.00
1876

Specific References

According to SPPU New Revised CBCS Syllabus 2020-21

SY BCA (Science) Semester-III

A Text book of

Database Management Systems

Author: Dr. Reena Bharathi, Vandana Bhat

Price: 230/-

ISBN: 978-81-946618-2-5

Quantity
In Stock

Contents

1. Relational Database Design

1. Introduction

2. Controlling Program Flow    

3. Views  

4. Stored Functions in PL/pgSQL

5. Handling Errors and Exceptions   

6. Cursors and Triggers   

7. Triggers

2. Transaction Concepts   

1. Introduction

2. Transaction Concepts   

3. Concurrent Execution of Transaction and Conflicting Operations   

4. Schedules of Transaction

3. Concurrency Control    

1. Introduction

2. Ensuring Serializability by Locks

3. Basic Timestamp Method for Concurrency 

4. Multiple Granularity Locking

5. Dynamic Database Concurrency (Phantom Problem)   

6. Timestamp versus Locking    

7. Optimistic Concurrency Control Algorithm and Multi Version Concurrency Control    

8. Deadlock Handling Methods

4. Crash Recovery   

1. Introduction

2. Transaction Failure Classification

3. Recovery Concepts

4. Checkpoints 

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

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

7. Buffer Management

8. Relationship between Recovery Management and Buffer Management   

9. Database Backup and Recovery from Catastrophic Failures

10.Shadow Paging    

Solved Examples

5. Database Security

1. Introduction

2. Database Security Concepts  

3. Methods of Database Security

4. Discretionary Access Control Method    

5. Mandatory Access Control Method  

6. Uses of Views in Security Enforcement  

7. Overview of Encryption Technique for Database    

8. Statistical Database Security

6. Database System Architectures    

1. Introduction

2. Centralized and Client-Server Architecture  

3. Server System Architecture  

4. Introduction to Parallel Database Systems   

5. Introduction to Distributed Database Systems

6. Introduction to Object Based Databases

No customer reviews for the moment.

Related Products

On sale! -10%
Data Structures
0 Review(s)
In Stock
Price ₹247.50 Regular price ₹275.00

According to SPPU New Revised CBCS Syllabus 2020-21

SY BCA (Science) Semester-III

A Text book of

Data Structures

Author: Dr. Poonam Ponde

Price: 275/-

ISBN: 978-81-946618-1-8

On sale! -10%
Computer Networks
0 Review(s)
In Stock
Price ₹225.00 Regular price ₹250.00

According to SPPU New Revised CBCS Syllabus 2020-21

SY BCA (Science) Semester-III

A Text book of

Computer Networks

Author: Dr. Poonam Ponde

Price: 250/-

ISBN: 978-81-945486-8-3