Database Management System-II
Book ID: 2091
Author: Dr. Reena Bharathi, Vandana Bhat
ISBN: 978-81-988224-7-5
About Authors
Dr. Reena Bharathi, a doctorate in Computer Science, has been in teaching profession for the past 25 years, with a dedicated approach in the chosen field. She is working as a lecturer in Nowrosjee Wadia college, Pune. Her area of interest includes Databases, NoSQL Databases, Big Data, Data Analytics, Operating Systems. It is indeed on her apt to have chosen to write a book on the subject, ‘Database Management Systems’, pertaining to the F.Y.B.Sc.(CS), on which she has an indepth knowledge. It is also a subject which she has been teaching for quite some years with passion.
She had already co-authored a book on ‘Relational Database Management System’ for S.Y.B.Sc. (CS), which has been well received and appreciated by students.
Mrs. Vandana Bhat, a post graduate in Computer Science, has been in teaching profession for past 23 years, with complete dedication.
She has also Completed her M.Phil. degree in Computer Science and published research paper based on “Contemporary Methods of Effective Classroom Teaching.”
The book “File Organization and Fundamental of Databases” is a subject which she has been teaching for quite a few years.
The other books Co-authored by her with Dr. Mrs. Reena Bharathi who is a great inspiration for her and helped her in knowledge enrichment and improving teaching skills.
Original price was: ₹260.₹221Current price is: ₹221.
23 in stock
Description
Contents
1. Relational Database Design Using PL/PGSQL
1. Introduction to PL/SQL
2. PL/PgSQL
2.1 PL/PgSQL Data Types
2.2 Language Structure
3. Controlling the Program Flow, Conditional Statements, Loops
3.1 Conditional statements
3.2 Loops
4. Stored Procedures
5. Stored Functions
6. Handling Errors and Exceptions
7. Cursors
8. Triggers
8.1 Types of Triggers
2. Transaction Concepts and Concurrency Control
1. Introduction
2. Describe a Transaction, Properties of Transaction, State of the Transaction
3. Executing Transactions Concurrently Associated Problem in Concurrent Execution
4. Schedules, Types of Schedules, Concept of Serializability, Precedence Graph of Serializability
5. Ensuring Serializability by Locks, Different Lock Modes, 2PL and its Variations
5.1 Lock Based Protocols
5.2 Two Phase Locking Protocol (2PL)
6. Basic Timestamp Method for Concurrency, Thomas Write Rule
6.1 Time Stamp Based Protocols
6.2 Thomas Write Rule
7. Locks with Multiple Granularity, Dynamic Database Concurrency (Phantom Problem)
8. Timestamps versus Locking
9. Deadlock and Deadlock Handling-Deadlock Avoidance (wait-die, wound-wait), Deadlock Detection and Recovery (wait for graph)
10. Deadlock Avoidance (Wound-Wait, Wait-die)
11. Deadlock Detection and Recovery (Wait For Graph)
3. Database Integrity and Security Concepts
1. Introduction
2. Domain Constraints
3. Referential Integrity
4. Introduction to Database Security Concepts
5. Methods of Database Security
5.1 Discretionary Access Control Method
5.2 Mandatory Access Control Method
5.3 Role Based Access Control for Multilevel Security
6. Use of Views in Security Enforcement
7. Overview of Encryption Technique for Database
8. 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, Relationship between Database Manager and Buffer Cache
5.1 A Checkpoint
5.2 Relationship between Database Manager and Buffer Cache
6. The ARIES Algorithm
7. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit)
8. Database Backup and Recovery from Catastrophic Failures
5. Other Databases
1. Introduction to Parallel and Distributed Databases
1.1 Parallel Databases
1.2 Distributed Databases
2. Introduction to Object Based Databases
2.1 Data Modeling for Object-Oriented Databases
2.2 New Data Types
2.3 Manipulating the New Data
3. XML databases
3.1 Databases, Information Retrieval and XML
3.2 A data model for XML
3.3 Querying XML Data
4. NoSQL Databases
4.1 Different Types of NoSQL Databases
4.2 Benefits of NoSQL Databases
5. Multimedia Databases
5.1 MMDB data types
5.2 MMDB Querying
5.3 Challenges and issues in a MMDB
6. Big Data Databases
6.1 Big Data Characteristics
6.2 Benefits of Big Data Processing
6.3 Big Data Databases
Additional Details
Overview
Languages
Books on Discount
I’s till you’re 18
Original price was: ₹199.₹179Current price is: ₹179.
Customer Reviews
More Like This
Reviews
Clear filtersThere are no reviews yet.