Loading...

Cookie choices

WoHoTech uses essential cookies for login and site features. Non-essential analytics load only after you accept them.

Read privacy policy

DBMS Topics

Hub Unit 1 — Introduction to DBMS & Entity-Relationship Model Advantages and Disadvantages of DBMS Aggregation Characteristics of DBMS Data Independence Data Models Database Users and Administrators DBMS Languages ER Diagrams Entity-Relationship ER Model Introduction to DBMS Keys in DBMS Relationships and Cardinality Schema and Instance Specialization and Generalization Unit 1 Summary — Introduction to DBMS & ER Model Three-Level Architecture ANSI/SPARC Architecture Weak Entity Set Unit 2 — Relational Model & SQL Constraints in SQL Cursors DCL and TCL Commands DDL Commands DML Commands Domain Relational Calculus DRC Functions and Stored Procedures Joins in SQL Nested Queries Subqueries Relational Algebra Relational Calculus Relational Model SQL Introduction Unit 2 Summary — Relational Model & SQL Triggers in SQL Tuple Relational Calculus TRC Views in SQL Armstrong's Axioms & Closure of Attributes Boyce-Codd Normal Form BCNF Closure of Attributes Dependency Preservation Fifth Normal Form 5NF First Normal Form 1NF Fourth Normal Form 4NF Functional Dependency Lossless Decomposition Multivalued Dependency Normal Forms — Overview Normalization — Introduction Second Normal Form 2NF Unit 3 Summary — Normalization Third Normal Form 3NF Unit 4 — Transaction Management & Concurrency Control ACID Properties Checkpoints Concurrency Control & Serializability Deadlock in DBMS Lock-Based Protocols & Two-Phase Locking Log-Based Recovery Recovery System Serializability Shadow Paging Unit 4 Summary — Transaction Management & Concurrency Control Timestamp-Based Protocol Transaction Management Transaction States Two-Phase Locking 2PL Unit 5 — Storage & Indexing B+ Tree B-Tree Cost Estimation Dynamic Hashing File Organization Hashing Techniques Indexing — Introduction Multi-Level Indexing Query Optimization Query Processing Single-Level Indexing Static Hashing Unit 5 Summary — Storage & Indexing Unit 6 — Advanced Topics in DBMS Big Data and DBMS Cloud Database Data Mining Data Warehouse Database Security Distributed Database Distributed Query Processing Distributed DBMS Architecture, Fragmentation & Replication MongoDB — Introduction NoSQL Database Replication in Distributed Databases Unit 6 Summary — Advanced Topics in DBMS Viva Voce — DBMS Important Viva Questions — DBMS Interview Questions — DBMS Viva Answers — DBMS DBMS Multiple Choice Questions MCQs DBMS Lab Programs

Unit 6 — Advanced Topics in DBMS

Last Updated : 21 May, 2026

This unit covers modern and advanced database topics including distributed databases, NoSQL technologies, Big Data, data warehousing, and database security.

Unit 6108 words2 headingsTables included

Unit Overview

This unit covers modern and advanced database topics including distributed databases, NoSQL technologies, Big Data, data warehousing, and database security.

Topics Covered

Topic	Description
Distributed Database	Data distributed across multiple sites
Distributed DBMS Architecture	Client-server, peer-to-peer models
Fragmentation	Horizontal, vertical, mixed
Replication	Copies of data for availability
Distributed Query Processing	Multi-site query execution
NoSQL Database	Non-relational database systems
MongoDB Introduction	Document-oriented NoSQL database
Big Data and DBMS	5 Vs, Hadoop, Spark
Data Warehouse	OLAP, star/snowflake schema
Data Mining	KDD process, techniques
Cloud Database	DBaaS, cloud-native databases
Database Security	Authentication, authorization, encryption

Exam Focus

Revise definitions, diagrams, examples, and short-answer points for Unit 6 — Advanced Topics in DBMS.

Interview Use

Prepare one clear explanation, one practical example, and one common mistake for this DBMS topic.

Search Terms

dbms, database management system, database notes, sql, unit, unit 6 — advanced topics in dbms

Related DBMS Topics

Continue learning this concept

Unit 6Unit 6 Summary — Advanced Topics in DBMS Unit 6Big Data and DBMSBig Data refers to datasets that are so large, fast-moving, or complex that traditional database systems cannot process them efficiently. It requires new technologies and Unit 6Distributed DBMS Architecture, Fragmentation & ReplicationA Distributed DBMS DDBMS consists of software at each site that manages its local data and participates in global query processing.Unit 6Cloud DatabaseA cloud database is a database service built, deployed, and accessed through a cloud computing platform. It provides database capabilities as a service DBaaS — Database a Unit 6Data MiningData Mining is the process of discovering interesting, previously unknown patterns, correlations, anomalies, and insights from large amounts of data stored in databases a Unit 6Data WarehouseA Data Warehouse DW is a large, centralized repository of integrated data from multiple sources, optimized for analytical querying and business intelligence BI — not for

PreviousUnit 5 Summary — Storage & Indexing NextBig Data and DBMS