A savepoint is a named marker inside a database transaction that allows a partial rollback to that point without aborting the whole…
A schema in databases is the formal definition of how data is organized, including its tables, columns, data types, keys and constraints.
SELECT is the SQL statement that retrieves data from database tables, declaring which rows and columns to return and leaving the execution…
Sharding splits a database horizontally across several servers by a shard key, so each server stores and serves only part of the…
A slow query log is a database log that records SQL statements exceeding a set execution time, used to find and fix…
SQLite is an embedded, serverless relational database engine that stores a complete SQL database in a single file inside the application.
A star schema is a data modeling pattern that places one central fact table of measurements among denormalized dimension tables for fast…
A subquery in SQL is a SELECT statement nested inside another statement, supplying a value, a list or a derived table to…
Synchronous replication is a database replication mode in which a commit succeeds only after one or more replicas confirm they have received…