Database Management System (DBMS)

Last Updated : 29 Feb, 2020

‘Recent Articles’ on DBMS !

Introduction :

  1. DBMS Introduction | Set 1
  2. DBMS Introduction | Set 2 (3-Tier Architecture)
  3. DBMS Architecture 2-level 3-level
  4. Need For DBMS
  5. Data Abstraction and Data Independence
  6. Database Objects
  7. Multimedia Database
  8. Interfaces
  9. Categories of End Users
  10. Use of DBMS in System Software
  11. Choice of DBMS | Economic factors
  12. Disadvantages of DBMS

Entity Relationship Model :

  1. ER Model
  2. Enhanced ER Model
  3. Minimization of ER Diagram
  4. ER Model: Generalization, Specialization and Aggregation
  5. Recursive Relationships
  6. Impedance Mismatch

Relational Model :

  1. Relational Model and CODD Rules
  2. Relational Model
  3. Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
  4. Number of possible Superkeys
  5. Anomalies in Relational Model
  6. Mapping from ER Model to Relational Model
  7. Strategies for Schema design
  8. Schema Integration
  9. Star Schema in Data Warehouse modeling
  10. Data Warehouse Modeling | Snowflake Schema
  11. Dimensional Data Modeling

>> Quiz on ER and Relational Model

Relational Algebra :

  1. Introduction
  2. Basic Operators
  3. Extended Operators
  4. Inner Join vs Outer Join
  5. Join operation Vs nested query
  6. DBMS | Tupple Relational Calculus
  7. Row oriented vs. column oriented data stores
  8. How to solve Relational Algebra Problems for GATE
  9. How to Solve Relational Algebra Problems for GATE

Functional Dependencies :

  1. Functional Dependency and Attribute Closure
  2. Finding Attribute Closure and Candidate Keys using Functional Dependencies
  3. Armstrong’s Axioms in Functional Dependency
  4. Equivalence of Functional Dependencies
  5. Canonical Cover

Normalisation :

  1. Introduction
  2. Normal Forms
  3. Minimum relations satisfying 1NF
  4. The Problem of redundancy in Database
  5. Dependency Preserving Decomposition
  6. Lossless Join Decomposition
  7. LossLess Join and Dependency Preserving Decomposition
  8. How to find the Highest Normal Form of a Relation
  9. Domain Key normal form
  10. Introduction of 4th and 5th Normal form
  11. Denormalization in Databases
  12. DBMS | Data Replication

>> Quiz on Normal Forms

Transactions and Concurrency Control :

  1. Introduction
  2. ACID Properties
  3. Concurrency Control -Introduction
  4. Implementation of Locking in DBMS
  5. Concurrency Control Protocols – Lock Based Protocol
  6. Concurrency Control Protocol | Graph Based Protocol
  7. Concurrency Control Protocol | Two Phase Locking (2-PL)-I
  8. Concurrency Control Protocol | Two Phase Locking (2-PL)-II
  9. Concurrency Control Protocol | Two Phase Locking (2-PL)-III
  10. Concurrency Control Protocol | Multiple Granularity Locking
  11. Concurrency Control Protocol | Thomas Write Rule
  12. Concurrency Control | Polygraph to check View Serializabilty
  13. DBMS | Log based recovery
  14. Timestamp Ordering Protocols
  15. Introduction to TimeStamp and Deadlock Prevention Schemes
  16. Dirty read in SQL
  17. Types of Schedules
  18. Conflict Serializability
  19. View Serializability
  20. How to test if two schedules are View Equal or not ?
  21. Recoverability of Schedules
  22. Precedence Graph for testing Conflict Serializabilty
  23. Transaction Isolation Levels in DBMS
  24. Database Recovery Techniques
  25. Starvation in DBMS
  26. Deadlock in DBMS
  27. DBMS | OLAP vs OLTP
  28. Types of OLAP Systems
  29. DBMS | Types of Recoverability of Schedules and easiest way to test schedule | Set 2
  30. Web Information Retrieval | Vector Space Model
  31. Why recovery is needed?

>> Quiz on Transactions and concurrency control

Indexing, B and B+ trees :

  1. Indexing and its Types
  2. B-Tree | Set 1 (Introduction)
  3. B-Tree | Set 2 (Insert)
  4. B-Tree | Set 3 (Delete)
  5. B+ Tree (Introduction)
  6. Bitmap Indexing
  7. Inverted Index
  8. Difference between Inverted Index and Forward Index
  9. SQL queries on clustered and non-clustered Indexes

>> Practice questions on B and B+ Trees
>> Quizzes on Indexing, B and B+ Trees

File Organization:

  1. File Organization – Set 1
  2. File Organization – Set 2 (Hashing in DBMS)
  3. File Organization – Set 3
  4. File Organization – Set 4

>> Quiz on File structures

Advanced Topics :

  1. RAID
  2. Query Optimization
  3. How to store a password in database?
  4. Storage Area Networks
  5. Network attached storage
  6. Data Warehousing
  7. Data Warehouse Architecture
  8. Characteristics and Functions of Data warehouse
  9. Difficulties of Implementing Data Warehouses
  10. Data Mining
  11. Data Mining | KDD process
  12. Data Mining | Sources of Data that can be mined
  13. Data Marts
  14. ODBMS – Definition and overview
  15. Architecture of HBase
  16. Apache HBase
  17. Architecture and Working of Hive
  18. Apache Hive
  19. Difference between Hive and HBase
  20. Difference between RDBMS and HBase
  21. Challenges of database security
  22. Federated database management system issues
  23. Distributed Database System
  24. Functions of Distributed Database System
  25. Semantic Heterogeneity
  26. Advantages of Distributed database
  27. Comparison – Centralized, Decentralized and Distributed Systems
  28. Characteristics of Biological Data (Genome Data Management)
  29. Data Management issues in Mobile database
  30. Future Works in Geographic Information System
  31. Difference between Structured, Semi-structured and Unstructured data

SQL Tutorial

Similar Reads

Learn SQL and Database
SQL, developed by IBM in the 1970s, is a language for managing databases. It's used to store, retrieve, and manipulate structured data in various applications.Whether you are a beginner or an experienced professional, this tutorial will help build a solid foundation in sql and databases, empowering you to create impressive applications and projects
5 min read
The Ultimate Guide to Project Management
In this Project Management course, you will learn about the basics of Project Management, Phases of Project Management, Principles of Project Management, Project Management Process Activities, Phases of the Project Management Lifecycle, Kanban, Six Sigma and Lean Model of Project Management, What Does a Project Manager Do, Best Project Management C
3 min read
Grokking Modern System Design Interview Guide
This System Design Interview Guide will provide the latest system design interview questions and equip you with knowledge and techniques needed to design, build, and scale your own robust applications, for professionals as well as newbies.
3 min read
System Design Cheat Sheet
Welcome to the System Design Cheat Sheet. Join us on a journey to master the principles and techniques of designing complex systems and get ready to dive into the world of designing scalable, efficient, and robust systems
3 min read
Introduction of DBMS (Database Management System) - Set 1
A Database Management System (DBMS) is a software system that is designed to manage and organize data in a structured manner. It allows users to create, modify, and query a database, as well as manage the security and access controls for that database. DBMS provides an environment to store and retrieve the data in convenient and efficient manner. K
9 min read
Purpose of Database System in DBMS
Nowadays organizations are data-dependent. efficient management and retrieval of information play a crucial role in their success. A database is a collection of data that is organized, which is also called structured data. It can be accessed or stored in a computer system. It can be managed through a Database Management System (DBMS), a software us
3 min read
Database Management System - GATE CSE Previous Year Questions
Solving GATE Previous Year's Questions (PYQs) not only clears the concepts but also helps to gain flexibility, speed, accuracy, and understanding of the level of questions generally asked in the GATE exam, and that eventually helps you to gain good marks in the examination. Previous Year Questions help a candidate practice and revise for GATE, whic
5 min read
Federated database management system issues
What is a Federated Database Management System? A Federated Database Management System (FDBMS) is a type of distributed database management system that allows users to access and manipulate data stored in multiple databases. It is a system that integrates data from different sources, providing a single view of the data to users. This type of system
9 min read
Personnel involved in Database Management System
Many persons are involved in the design, use, and maintenance of a large database with a few hundred users. Here we will consider people who may be called "Actors on the Scene", whose jobs involve the day-to-day use of a large database. Database Administrators: Administrating the primary (database) and secondary (DBMS and related software) is the r
5 min read