-10%

Database Management Systems-II

₹216.00
₹240.00
Tax excluded
1876
22 Items

Specific References

According to New Revised CBCS syllabus w.e.f. 2020-21

BCA (Science Faculty)

Semesters-III

A Text book of

Database Management Systems-I

Author: Dr. Reenam Bharathi, Vandana Bhat

ISBN: 978-81-946618-2-5

Price: 240/-

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

Related Products

-10%
Computer Network
0 Review(s)
In Stock
Price ₹283.50 Regular price ₹315.00

According to New Revised CBCS syllabus w.e.f. 2020-21

BCA (Science Faculty)

Semesters-III

A Text book of

Computer Network

Author: Dr. Poonam Ponde

ISBN: 978-81-945486-8-3

Price: 315/-

-10%
Data Structures
0 Review(s)
In Stock
Price ₹256.50 Regular price ₹285.00

According to New Revised CBCS syllabus w.e.f. 2020-21

BCA (Science Faculty)

Semesters-III

A Text book of

Data Structures

Author: Dr. Poonam Ponde

ISBN: 978-81-946618-1-8

Price: 285/-