DBMS Topics
HubUnit 1 — Introduction to DBMS & Entity-Relationship ModelAdvantages and Disadvantages of DBMSAggregationCharacteristics of DBMSData IndependenceData ModelsDatabase Users and AdministratorsDBMS LanguagesER DiagramsEntity-Relationship ER ModelIntroduction to DBMSKeys in DBMSRelationships and CardinalitySchema and InstanceSpecialization and GeneralizationUnit 1 Summary — Introduction to DBMS & ER ModelThree-Level Architecture ANSI/SPARC ArchitectureWeak Entity SetUnit 2 — Relational Model & SQLConstraints in SQLCursorsDCL and TCL CommandsDDL CommandsDML CommandsDomain Relational Calculus DRCFunctions and Stored ProceduresJoins in SQLNested Queries SubqueriesRelational AlgebraRelational CalculusRelational ModelSQL IntroductionUnit 2 Summary — Relational Model & SQLTriggers in SQLTuple Relational Calculus TRCViews in SQLArmstrong's Axioms & Closure of AttributesBoyce-Codd Normal Form BCNFClosure of AttributesDependency PreservationFifth Normal Form 5NFFirst Normal Form 1NFFourth Normal Form 4NFFunctional DependencyLossless DecompositionMultivalued DependencyNormal Forms — OverviewNormalization — IntroductionSecond Normal Form 2NFUnit 3 Summary — NormalizationThird Normal Form 3NFUnit 4 — Transaction Management & Concurrency ControlACID PropertiesCheckpointsConcurrency Control & SerializabilityDeadlock in DBMSLock-Based Protocols & Two-Phase LockingLog-Based RecoveryRecovery SystemSerializabilityShadow PagingUnit 4 Summary — Transaction Management & Concurrency ControlTimestamp-Based ProtocolTransaction ManagementTransaction StatesTwo-Phase Locking 2PLUnit 5 — Storage & IndexingB+ TreeB-TreeCost EstimationDynamic HashingFile OrganizationHashing TechniquesIndexing — IntroductionMulti-Level IndexingQuery OptimizationQuery ProcessingSingle-Level IndexingStatic HashingUnit 5 Summary — Storage & IndexingUnit 6 — Advanced Topics in DBMSBig Data and DBMSCloud DatabaseData MiningData WarehouseDatabase SecurityDistributed DatabaseDistributed Query ProcessingDistributed DBMS Architecture, Fragmentation & ReplicationMongoDB — IntroductionNoSQL DatabaseReplication in Distributed DatabasesUnit 6 Summary — Advanced Topics in DBMSViva Voce — DBMSImportant Viva Questions — DBMSInterview Questions — DBMSViva Answers — DBMSDBMS Multiple Choice Questions MCQsDBMS Lab Programs
Unit 6 Summary — Advanced Topics in DBMS
Last Updated : 21 May, 2026
Unit 6145 words13 headingsTables includedExamples included
Quick Reference
Distributed Database Key Points
| Location | User unaware of where data is stored |
| Replication | User unaware of multiple copies |
| Fragmentation | User unaware of data splitting |
| CAP Theorem | Choose at most 2 of: |
Fragmentation Types
| Type | Splits By | Reconstruction |
|---|---|---|
| Horizontal | Rows (WHERE condition) | UNION of fragments |
| Vertical | Columns (projection) | NATURAL JOIN on PK |
| Mixed/Hybrid | Both rows and columns | UNION + JOIN |
Replication Models
| Full: All sites have all data | Max availability, high update cost |
| Partial: Selected data replicated | Balance of availability and overhead |
| None: Each fragment at one site only | Low overhead, single point of failure |
| Synchronous | All replicas updated in same transaction (strong consistency) |
| Asynchronous | Primary updates first; replicas lag behind (eventual consistency) |
NoSQL Database Types
| Type | Model | Examples | Best For |
|---|---|---|---|
| Key-Value | Hash map | Redis, DynamoDB | Cache, sessions |
| Document | JSON/BSON | MongoDB, CouchDB | Flexible schemas |
| Column-Family | Column groups | Cassandra, HBase | Analytics, IoT |
| Graph | Nodes + Edges | Neo4j, Neptune | Relationships |
ACID vs BASE
ACID (RDBMS): Atomic, Consistent, Isolated, Durable
BASE (NoSQL): Basically Available, Soft state, Eventually consistent
Data Warehouse vs OLTP
OLTP: Normalized, transactions, current data, many small queries
DW: Denormalized, analytics, historical data, few large queries
DW Schemas
Star Schema: Fact table + dimension tables (simple, fast)
Snowflake Schema: Star + normalized dimensions (less redundancy, more joins)
OLAP Operations
| Roll-up: Day | Month → Year (aggregate up) |
| Drill-down: Year | Month → Day (decompose down) |
| Slice | Fix one dimension |
| Dice | Fix multiple dimensions |
| Pivot | Rotate axes |
Data Mining Tasks
| Task | Goal | Example |
|---|---|---|
| Classification | Predict category | Spam/Not Spam |
| Clustering | Group similar items | Customer segments |
| Association Rules | Find co-occurrences | Market basket analysis |
| Regression | Predict number | House price |
| Anomaly Detection | Find outliers | Credit card fraud |
Database Security Checklist
| Authentication | Strong passwords, MFA, account lockout |
| Authorization | Least privilege, RBAC, column-level grants |
| SQL Injection | Parameterized queries (ALWAYS) |
| Encryption | At rest (AES-256) + In transit (TLS) |
| Auditing | Log all data access and changes |
| Masking | Hide sensitive data in non-production |
Cloud Database Advantages
| No hardware | pay-as-you-go |
| Auto-scaling | handle traffic spikes |
| Managed backups | automated, tested |
| High availability | Multi-AZ, 99.99% SLA |
| Global distribution | data near users |
Complete DBMS Summary — All 6 Units
| DDL | CREATE, ALTER, DROP, TRUNCATE, RENAME |
| DML | SELECT, INSERT, UPDATE, DELETE |
| DCL | GRANT, REVOKE |
| TCL | COMMIT, ROLLBACK, SAVEPOINT |
Exam Focus
Revise definitions, diagrams, examples, and short-answer points for Unit 6 Summary — 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, summary, unit 6 summary — advanced topics in dbms
Related DBMS Topics
Continue learning this concept
Unit 6Unit 6 — Advanced Topics in DBMSThis unit covers modern and advanced database topics including distributed databases, NoSQL technologies, Big Data, data warehousing, and database security.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 andUnit 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 aUnit 6Data MiningData Mining is the process of discovering interesting, previously unknown patterns, correlations, anomalies, and insights from large amounts of data stored in databases aUnit 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