Database Dictionary

A glossary of essential database concepts and terminology. Each entry explains a term in plain language with practical SQL examples you can try in Chat2DB (opens in a new tab).

• Foreign Key
• ACID (Atomicity, Consistency, Isolation, Durability)
• Aggregation
• Alias
• Anchored Window Function
• Anti Join
• B+ Tree Index
• Backup
• Batch Processing in Databases
• Binary Large Object (BLOB)
• Bitmap Index
• Buffer Pool
• Candidate Key
• Cardinality
• Cascade
• Checkpoint
• Clustered Index
• Column
• Commit
• Concurrency Control
• Constraint
• What are CUBE and ROLLUP Operators
• Cursor
• Data Control Language (DCL)
• Data Query Language (DQL)
• Data Warehouse?
• Database Management System (DBMS)
• Deadlock
• Data Definition Language (DDL)
• Denormalization
• Derived Table
• Dimension Table
• Dirty Read
• Distribution in the Context of Data and Computing
• Document Store
• Duplicate Elimination
• Entity-Relationship Diagram (ERD)
• Entity
• Eventual Consistency
• EXPLAIN Plan
• Fact Table
• Full Outer Join
• Function-Based Index
• Functional Dependency
• Gather Statistics
• Granularity
• GROUP BY
• Hash Join
• Histogram
• Horizontal Partitioning
• In-Memory Database
• Incremental Backup
• Index
• Inner Join
• Insert Statement
• Isolation Level
• JOIN in SQL?
• JSON Data Type
• Kafka Connector?
• Key
• Left Outer Join
• Load Balancing?
• Lock?
• Logical Volume Manager (LVM)
• Data Manipulation Language (DML)
• Materialized View
• Memory-Optimized Table?
• Mergesort?
• Metadata?
• Multi-Version Concurrency Control (MVCC)?
• Nested Loop Join?
• Nesting?
• Normalization?
• NoSQL?
• Object-Oriented Database?
• OLAP (Online Analytical Processing)?
• OLTP (Online Transaction Processing)?
• Optimization in Database Management Systems
• Oracle PL/SQL
• Outer Joins in SQL
• Partition Pruning
• Partition
• Pipelined Function
• Primary Key
• Procedure
• Query Execution Plan
• Query Optimization
• Query Optimizer
• Range Scan
• Recovery
• Redo Log
• Referential Integrity
• Replication
• Right Outer Join
• Rollback
• Row-Level Locking
• Row
• Recursive Common Table Expression
• Scalar Function?
• Schema
• Sequence?
• Serialization
• Set Operations (UNION, INTERSECT, MINUS)?
• Database Snapshot
• Soft Delete?
• Sparse Index?
• Spatial Database
• Star Schema?
• Stored Procedure?
• Subquery?
• Surrogate Key?
• Symmetric Multiprocessing (SMP)?
• Table?
• Temporal Table?
• Text Search?
• Transaction?
• Tree Structure?
• Trigger?
• Tuple?
• Union?
• Unique Constraint?
• Unpivot Operation
• Update Statement?
• Upsert?
• User Defined Function (UDF)?
• Versioning in Databases
• Vertical Partitioning
• View in DBMS
• Virtual Table?
• Window Function?
• Write-Ahead Logging (WAL)?
• XACT_ABORT?
• XML Data Type?
• Yield?
• Z-order Curve?
• Zero-Padding