On sale! -10%

Database Management Systems-II

₹207.00
₹230.00
1876
23 Items

Specific References

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

A Text book of

B.C.A. (Science)

Semester-III

Database Management Systems-I

Author: Dr. Reenam 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

Related Products

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

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

A Text book of

B.C.A. (Science)

Semester-III

Computer Network

Author: Dr. Poonam Ponde

Price: 250/-

ISBN: 978-81-945486-8-3

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

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

A Text book of

B.C.A. (Science)

Semester-III

Data Structures

Author: Dr. Poonam Ponde

Price: 275/-

ISBN: 978-81-946618-1-8