Theme Options

NEWSLETTER

Advanced Relational Database Management

1747

New

According to new reveised syllabus w.e.f. 2017-18

BCA (Science) Semester-III

Advanced Relational Database Management

Author : Reena Bharathi, Vandana Babrekar

Book ID : 1747

ISBN : 978-93-5016-402-0

More details

Rs.135

Contents

1. Relational Database Design
1.1 PL/PGSQL
1.2 Controlling Program Flow
1.3 Views
1.4 Stored Functions in PL/pgSQL
1.5 Handling Errors and Exceptions
1.6 Cursors and Triggers
1.7 Triggers
2. Transaction Concepts and Concurrency Control

2.1 Transaction Concepts
2.2 Concurrent Execution of Transaction and Conflicting Operations
2.3 Schedules of Transaction
2.4 Ensuring Serializability by Locks
2.5 Basic Timestamp Method for Concurrency
2.6 Multiple Granularity Locking
2.7 Dynamic Database Concurrency (Phantom Problem)
2.8 Timestamp Versus Locking
2.9 Optimistic Concurrency Control Algorithm and Multi Version Concurrency Control
2.10 Deadlock Handling Methods

3. Crash Recovery

3.1 Transaction Failure classification

3.2 Recovery Concepts

3.3 Checkpoints
3.4 Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit)
3. 5 Log Based Recovery Techniques (Deferred and Immediate Update)
3.6 Buffer Management
3.7 Relationship between Recovery Management and Buffer Management
3.8 The ARIES Algorithm
3.9 Database Backup and Recovery from Catastrophic Failures
3.10 Shadow Paging

4. Database Security

4.1 Database Security Concepts
4.2 Methods of Database Security
4.3 Discretionary Access Control Method
4.4 Mandatory Access Control Method
4.5 Uses of Views in Security Enforcement
4.6 Overview of Encryption Technique for Database
4.7 Statistical Database Security

5. Client Server Technology
5.1 Client-Server Computing
5.2 Evolution of Client Server Information Systems
5.3 Client Server Architecture Benefits
5.4 Client Server Architecture (2 tier, 3tier)
5.5 Client Server Components
5.6 Communication Middleware Components
5.7 Database Middleware Components
5.8 Client Server Databases

No customer comments for the moment.

Write a review

Advanced Relational Database Management

Advanced Relational Database Management

According to new reveised syllabus w.e.f. 2017-18

BCA (Science) Semester-III

Advanced Relational Database Management

Author : Reena Bharathi, Vandana Babrekar

Book ID : 1747

ISBN : 978-93-5016-402-0

Write a review