Database Terms

A set of database transaction properties (Atomicity, Consistency, Isolation, Durability) ensuring reliable data processing.

A technique of maintaining a cache of reusable database connections to reduce the overhead of creating new connections.

A data structure technique that improves query performance by creating quick lookup paths to rows in database tables.

A version-controlled approach to evolving database schemas over time with incremental, reversible changes.

A distributed search and analytics engine built on Apache Lucene, designed for horizontal scalability and near real-time search.

Google's app development platform offering real-time database, authentication, hosting, and cloud functions.

A document-oriented NoSQL database that stores data in flexible, JSON-like documents with dynamic schemas.

The world's most popular open-source relational database management system, widely used for web applications.

A database performance anti-pattern where a query fetches N items then executes N additional queries for related data.

A category of databases that don't use traditional relational tables, offering flexible schemas for unstructured data.

Object-Relational Mapping - a technique that maps database tables to programming language objects, abstracting SQL queries.

A powerful open-source relational database with advanced features like JSON support, full-text search, and extensibility.

Structured Query Language - a standard language for managing and manipulating relational databases with declarative syntax.

A self-contained, serverless SQL database engine that stores the entire database in a single file on disk.

An open-source Firebase alternative providing PostgreSQL database, authentication, storage, and real-time subscriptions.