Please enable JavaScript.
Coggle requires JavaScript to display documents.
DBMS Functionality - Coggle Diagram
DBMS Functionality
Data Manipulation Language (DML)
Insert Data
Update Data
Delete Data
Query Data (Select Statements)
Data Retrieval and Projection
Sorting and Grouping
Aggregation Functions
Data Integrity and Consistency
Entity Integrity (Primary Key Constraint)
Referential Integrity (Foreign Key Constraint)
Domain Constraints
Check Constraints
Transaction Isolation Levels
Concurrency Control
Data Definition Language (DDL)
Create Tables
Alter Tables
Drop Tables
Create Indexes
Define Constraints (Primary Key, Foreign Key, etc.)
Data Querying and Retrieval
Query Optimization
Query Execution Plans
Query Languages (SQL, QBE, etc.)
Joins and Subqueries
Views and Materialized Views
Data Security and Access Control
User Authentication
User Authorization
Role-Based Access Control
Data Encryption
Auditing and Logging
Data Concurrency and Transaction Management
ACID Properties (Atomicity, Consistency, Isolation, Durability)
Transaction Processing
Locking Mechanisms
Deadlock Detection and Resolution
Two-Phase Commit Protocol
Data Modeling and Design
Entity-Relationship (ER) Model
Relational Model
Normalization
Database Design Principles
Conceptual, Logical, and Physical Design
Query Optimization and Performance Tuning
Query Execution Plans
Indexing Strategies
Query Rewriting and Transformation
Statistics and Cost Estimation
Caching and Buffering Techniques
Database Administration and Management
Database Installation and Configuration
Capacity Planning
Backup and Recovery Strategies
Performance Monitoring and Tuning
Schema and Security Management
Database Connectivity and Application Development
Database APIs and Drivers
Object-Relational Mapping (ORM) Tools
SQL Programming
Stored Procedures and Triggers
Database Integration with Programming Languages
Data Recovery and Backup
Transaction Logging
Point-in-Time Recovery
Full and Incremental Backups
Restore and Rollback Operations
Data Replication and Distributed Databases
Data Replication Techniques
Distributed Database Architecture
Data Fragmentation and Distribution
Data Consistency and Replication Synchronization